PREVIEW / futures_1hour / 2013-11-06

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-06.parquet
  size:    47 KB
  rows:    1,532

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2013-11-06 00:00:00	ES	Futures	1821.2	1821.46	1819.14	1819.65	4409.0
2013-11-06 01:00:00	ES	Futures	1819.39	1820.43	1819.14	1819.91	3883.0
2013-11-06 02:00:00	ES	Futures	1819.91	1821.2	1819.65	1820.17	6266.0
2013-11-06 03:00:00	ES	Futures	1819.91	1821.97	1819.65	1820.43	18212.0
2013-11-06 04:00:00	ES	Futures	1820.17	1821.2	1819.14	1820.94	13152.0
2013-11-06 05:00:00	ES	Futures	1820.68	1823.01	1820.17	1822.49	15201.0
2013-11-06 06:00:00	ES	Futures	1822.75	1823.26	1820.68	1821.72	11737.0
2013-11-06 07:00:00	ES	Futures	1821.46	1822.49	1820.17	1821.2	16840.0
2013-11-06 08:00:00	ES	Futures	1820.94	1821.46	1819.91	1820.17	23128.0
2013-11-06 09:00:00	ES	Futures	1820.17	1826.36	1819.65	1824.55	215740.0
2013-11-06 10:00:00	ES	Futures	1824.81	1826.1	1817.85	1819.39	267671.0
2013-11-06 11:00:00	ES	Futures	1819.39	1820.94	1816.04	1818.88	210629.0
2013-11-06 12:00:00	ES	Futures	1818.62	1822.23	1818.62	1820.43	92504.0
2013-11-06 13:00:00	ES	Futures	1820.43	1822.75	1819.91	1821.46	74239.0
2013-11-06 14:00:00	ES	Futures	1821.2	1822.23	1819.65	1821.46	71856.0
2013-11-06 15:00:00	ES	Futures	1821.46	1823.78	1819.65	1822.75	166438.0
2013-11-06 16:00:00	ES	Futures	1822.75	1823.01	1821.2	1821.46	60586.0
2013-11-06 17:00:00	ES	Futures	1821.46	1821.46	1820.17	1820.17	3076.0
2013-11-06 18:00:00	ES	Futures	1819.91	1820.68	1817.85	1818.62	6628.0
2013-11-06 19:00:00	ES	Futures	1818.62	1819.14	1817.85	1818.88	2694.0
2013-11-06 20:00:00	ES	Futures	1819.14	1820.68	1817.85	1818.36	5692.0
2013-11-06 21:00:00	ES	Futures	1818.36	1819.65	1817.85	1819.65	2411.0
2013-11-06 22:00:00	ES	Futures	1819.39	1819.91	1818.62	1819.14	1959.0
2013-11-06 23:00:00	ES	Futures	1818.88	1820.17	1818.62	1819.65	1423.0
2013-11-06 00:00:00	NQ	Futures	3944.65	3944.94	3940.3	3940.3	649.0
2013-11-06 01:00:00	NQ	Futures	3940.59	3942.04	3939.43	3942.04	497.0
2013-11-06 02:00:00	NQ	Futures	3941.75	3945.82	3941.46	3942.04	1105.0
2013-11-06 03:00:00	NQ	Futures	3942.33	3946.11	3941.17	3942.62	2355.0
2013-11-06 04:00:00	NQ	Futures	3942.04	3943.2	3938.56	3940.59	2024.0
2013-11-06 05:00:00	NQ	Futures	3940.88	3943.78	3939.43	3942.91	2391.0
2013-11-06 06:00:00	NQ	Futures	3942.91	3944.07	3939.72	3940.88	1481.0
2013-11-06 07:00:00	NQ	Futures	3940.88	3943.78	3939.43	3941.17	2446.0
2013-11-06 08:00:00	NQ	Futures	3940.88	3941.46	3938.56	3938.56	2711.0
2013-11-06 09:00:00	NQ	Futures	3938.56	3947.56	3933.04	3943.2	39097.0
2013-11-06 10:00:00	NQ	Futures	3943.49	3945.53	3920.55	3923.16	43166.0
2013-11-06 11:00:00	NQ	Futures	3922.87	3929.55	3915.32	3923.74	39187.0
2013-11-06 12:00:00	NQ	Futures	3923.74	3928.39	3919.97	3920.26	16811.0
2013-11-06 13:00:00	NQ	Futures	3919.97	3928.39	3918.52	3922.58	13668.0
2013-11-06 14:00:00	NQ	Futures	3922.58	3927.23	3920.26	3924.9	12708.0
2013-11-06 15:00:00	NQ	Futures	3924.9	3930.42	3922.29	3927.52	22668.0
2013-11-06 16:00:00	NQ	Futures	3927.81	3929.26	3920.26	3921.71	7533.0
2013-11-06 17:00:00	NQ	Futures	3921.71	3921.71	3919.68	3919.68	332.0
2013-11-06 18:00:00	NQ	Futures	3919.68	3920.26	3913.58	3915.03	1409.0
2013-11-06 19:00:00	NQ	Futures	3915.32	3916.77	3913.0	3916.48	818.0
2013-11-06 20:00:00	NQ	Futures	3916.77	3919.68	3914.16	3915.03	1034.0
2013-11-06 21:00:00	NQ	Futures	3915.32	3917.64	3914.45	3917.64	446.0
2013-11-06 22:00:00	NQ	Futures	3917.64	3917.93	3915.9	3916.48	430.0
2013-11-06 23:00:00	NQ	Futures	3916.48	3918.81	3915.9	3917.93	205.0
2013-11-06 00:00:00	YM	Futures	15953.9	15957.0	15937.6	15939.6	1324.0
2013-11-06 01:00:00	YM	Futures	15940.6	15944.7	15936.6	15940.6	466.0

> showing 50 of 1,532 rows — these rows as CSV

> unlock the full archive -- $79 one-time