PREVIEW / futures_1hour / 2009-03-10

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-10.parquet
  size:    41 KB
  rows:    1,182

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
2009-03-10 00:00:00	ES	Futures	647.04	648.46	645.14	647.99	2715.0
2009-03-10 01:00:00	ES	Futures	647.99	648.46	646.33	647.99	1637.0
2009-03-10 02:00:00	ES	Futures	648.23	649.41	645.86	647.28	3398.0
2009-03-10 03:00:00	ES	Futures	647.04	650.6	646.09	649.89	7749.0
2009-03-10 04:00:00	ES	Futures	649.89	654.16	647.52	653.45	31323.0
2009-03-10 05:00:00	ES	Futures	653.45	653.68	651.07	652.5	13420.0
2009-03-10 06:00:00	ES	Futures	652.73	656.53	651.55	654.63	24724.0
2009-03-10 07:00:00	ES	Futures	654.63	655.11	652.5	653.92	19707.0
2009-03-10 08:00:00	ES	Futures	653.92	656.05	652.02	652.73	55791.0
2009-03-10 09:00:00	ES	Futures	652.73	666.49	651.55	662.93	409582.0
2009-03-10 10:00:00	ES	Futures	663.17	671.47	662.93	669.1	514751.0
2009-03-10 11:00:00	ES	Futures	669.1	676.45	666.73	676.22	359151.0
2009-03-10 12:00:00	ES	Futures	676.45	678.82	674.08	674.32	327205.0
2009-03-10 13:00:00	ES	Futures	674.56	679.54	673.13	675.03	284932.0
2009-03-10 14:00:00	ES	Futures	675.03	677.4	670.76	676.45	308849.0
2009-03-10 15:00:00	ES	Futures	676.69	681.67	673.84	680.25	550623.0
2009-03-10 16:00:00	ES	Futures	680.48	684.75	678.11	680.48	201298.0
2009-03-10 17:00:00	ES	Futures	680.48	681.43	680.01	680.25	2527.0
2009-03-10 18:00:00	ES	Futures	679.77	681.2	679.77	680.96	3757.0
2009-03-10 19:00:00	ES	Futures	680.96	681.2	679.77	680.96	3704.0
2009-03-10 20:00:00	ES	Futures	680.96	683.09	680.25	682.38	4389.0
2009-03-10 21:00:00	ES	Futures	682.38	684.28	681.91	683.33	5338.0
2009-03-10 22:00:00	ES	Futures	683.09	683.09	680.48	680.96	3958.0
2009-03-10 23:00:00	ES	Futures	680.96	683.57	680.25	681.2	5981.0
2009-03-10 00:00:00	NQ	Futures	1191.36	1193.34	1188.54	1192.21	40.0
2009-03-10 01:00:00	NQ	Futures	1192.49	1194.19	1190.8	1193.06	170.0
2009-03-10 02:00:00	NQ	Futures	1193.91	1194.75	1190.23	1190.23	130.0
2009-03-10 03:00:00	NQ	Futures	1192.21	1197.58	1190.8	1196.45	903.0
2009-03-10 04:00:00	NQ	Futures	1196.16	1200.96	1192.49	1199.84	1814.0
2009-03-10 05:00:00	NQ	Futures	1200.12	1200.4	1196.45	1198.99	1092.0
2009-03-10 06:00:00	NQ	Futures	1198.42	1204.35	1198.14	1202.94	4519.0
2009-03-10 07:00:00	NQ	Futures	1203.51	1203.79	1198.71	1200.12	1542.0
2009-03-10 08:00:00	NQ	Futures	1199.84	1204.35	1197.29	1198.42	4360.0
2009-03-10 09:00:00	NQ	Futures	1198.14	1225.53	1197.29	1215.65	53001.0
2009-03-10 10:00:00	NQ	Futures	1215.93	1237.67	1215.37	1232.87	75407.0
2009-03-10 11:00:00	NQ	Futures	1232.87	1244.17	1226.94	1243.89	48945.0
2009-03-10 12:00:00	NQ	Futures	1244.17	1248.97	1242.19	1242.76	41389.0
2009-03-10 13:00:00	NQ	Futures	1243.04	1252.92	1242.19	1245.3	38074.0
2009-03-10 14:00:00	NQ	Futures	1245.3	1249.53	1237.96	1246.71	47583.0
2009-03-10 15:00:00	NQ	Futures	1246.71	1255.46	1243.04	1252.08	70950.0
2009-03-10 16:00:00	NQ	Futures	1252.36	1256.59	1247.56	1253.77	23872.0
2009-03-10 17:00:00	NQ	Futures	1253.21	1255.18	1252.64	1254.05	353.0
2009-03-10 18:00:00	NQ	Futures	1252.08	1254.05	1252.08	1253.77	203.0
2009-03-10 19:00:00	NQ	Futures	1254.33	1254.62	1252.36	1254.33	411.0
2009-03-10 20:00:00	NQ	Futures	1254.05	1256.59	1253.21	1256.31	180.0
2009-03-10 21:00:00	NQ	Futures	1256.31	1258.85	1255.46	1256.03	162.0
2009-03-10 22:00:00	NQ	Futures	1255.46	1255.75	1253.49	1253.49	109.0
2009-03-10 23:00:00	NQ	Futures	1254.05	1257.16	1253.49	1253.77	421.0
2009-03-10 00:00:00	YM	Futures	6000.7	6000.7	6000.7	6000.7	1.0
2009-03-10 01:00:00	YM	Futures	6008.1	6008.1	6005.3	6005.3	2.0

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

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