PREVIEW / futures_1hour / 2010-04-28

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-28.parquet
  size:    47 KB
  rows:    1,399

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
2010-04-28 00:00:00	ES	Futures	1156.87	1157.11	1155.4	1155.4	3334.0
2010-04-28 01:00:00	ES	Futures	1155.89	1156.87	1155.4	1155.89	5916.0
2010-04-28 02:00:00	ES	Futures	1155.89	1157.11	1154.91	1155.65	21894.0
2010-04-28 03:00:00	ES	Futures	1155.65	1158.34	1154.67	1155.16	58535.0
2010-04-28 04:00:00	ES	Futures	1155.16	1155.65	1150.51	1152.47	81932.0
2010-04-28 05:00:00	ES	Futures	1152.71	1154.43	1150.51	1153.94	57231.0
2010-04-28 06:00:00	ES	Futures	1153.94	1156.63	1152.71	1156.63	52691.0
2010-04-28 07:00:00	ES	Futures	1156.63	1161.02	1156.38	1158.09	87826.0
2010-04-28 08:00:00	ES	Futures	1157.85	1162.49	1157.36	1161.51	127841.0
2010-04-28 09:00:00	ES	Futures	1161.76	1163.22	1157.11	1158.34	374967.0
2010-04-28 10:00:00	ES	Futures	1158.34	1160.05	1155.4	1160.05	421686.0
2010-04-28 11:00:00	ES	Futures	1160.05	1162.98	1151.49	1157.36	533276.0
2010-04-28 12:00:00	ES	Futures	1157.36	1161.27	1153.69	1160.54	193195.0
2010-04-28 13:00:00	ES	Futures	1160.54	1161.51	1159.31	1160.78	70060.0
2010-04-28 14:00:00	ES	Futures	1160.78	1165.42	1159.8	1163.47	279295.0
2010-04-28 15:00:00	ES	Futures	1163.47	1164.94	1157.85	1162.0	313694.0
2010-04-28 16:00:00	ES	Futures	1162.0	1164.45	1161.76	1163.96	115757.0
2010-04-28 17:00:00	ES	Futures	1163.96	1164.94	1163.71	1164.45	2996.0
2010-04-28 18:00:00	ES	Futures	1164.2	1165.42	1163.96	1164.2	5429.0
2010-04-28 19:00:00	ES	Futures	1164.45	1165.18	1164.2	1164.45	1408.0
2010-04-28 20:00:00	ES	Futures	1164.45	1164.45	1162.74	1163.22	4361.0
2010-04-28 21:00:00	ES	Futures	1162.98	1163.22	1161.51	1162.25	6333.0
2010-04-28 22:00:00	ES	Futures	1162.25	1162.98	1161.76	1162.98	3798.0
2010-04-28 23:00:00	ES	Futures	1162.98	1163.47	1162.0	1162.74	3915.0
2010-04-28 00:00:00	NQ	Futures	2303.58	2303.87	2302.44	2302.44	190.0
2010-04-28 01:00:00	NQ	Futures	2302.44	2303.87	2302.44	2303.01	274.0
2010-04-28 02:00:00	NQ	Futures	2303.01	2305.01	2300.14	2302.15	904.0
2010-04-28 03:00:00	NQ	Futures	2302.44	2306.44	2300.43	2301.29	3056.0
2010-04-28 04:00:00	NQ	Futures	2300.72	2302.15	2291.55	2294.42	5060.0
2010-04-28 05:00:00	NQ	Futures	2294.13	2298.71	2291.55	2298.71	3467.0
2010-04-28 06:00:00	NQ	Futures	2298.43	2305.87	2297.85	2305.59	5004.0
2010-04-28 07:00:00	NQ	Futures	2305.59	2312.75	2305.3	2309.31	6287.0
2010-04-28 08:00:00	NQ	Futures	2309.31	2317.04	2308.45	2314.75	11979.0
2010-04-28 09:00:00	NQ	Futures	2315.04	2316.75	2292.7	2294.99	51946.0
2010-04-28 10:00:00	NQ	Futures	2294.99	2296.14	2282.68	2290.98	70945.0
2010-04-28 11:00:00	NQ	Futures	2291.27	2296.42	2278.95	2287.26	65113.0
2010-04-28 12:00:00	NQ	Futures	2287.26	2292.7	2280.96	2291.55	25483.0
2010-04-28 13:00:00	NQ	Futures	2291.55	2297.57	2289.84	2294.7	16549.0
2010-04-28 14:00:00	NQ	Futures	2294.99	2304.15	2291.27	2301.58	39391.0
2010-04-28 15:00:00	NQ	Futures	2301.58	2304.73	2289.26	2297.57	38388.0
2010-04-28 16:00:00	NQ	Futures	2297.28	2300.72	2295.56	2299.0	11474.0
2010-04-28 17:00:00	NQ	Futures	2299.29	2302.44	2298.71	2300.72	939.0
2010-04-28 18:00:00	NQ	Futures	2300.72	2302.72	2300.43	2301.0	361.0
2010-04-28 19:00:00	NQ	Futures	2301.0	2302.15	2301.0	2301.29	72.0
2010-04-28 20:00:00	NQ	Futures	2301.29	2301.29	2298.43	2298.43	432.0
2010-04-28 21:00:00	NQ	Futures	2298.71	2299.29	2296.42	2296.71	388.0
2010-04-28 22:00:00	NQ	Futures	2296.99	2299.0	2296.71	2299.0	293.0
2010-04-28 23:00:00	NQ	Futures	2298.71	2299.29	2297.85	2298.14	298.0
2010-04-28 00:00:00	YM	Futures	10324.4	10324.4	10316.0	10316.9	97.0
2010-04-28 01:00:00	YM	Futures	10316.9	10323.5	10315.0	10319.7	234.0

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

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