PREVIEW / futures_1hour / 2009-03-09

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-09.parquet
  size:    42 KB
  rows:    1,209

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-09 00:00:00	ES	Futures	651.07	652.26	650.84	652.02	3211.0
2009-03-09 01:00:00	ES	Futures	652.02	653.92	651.79	652.5	1754.0
2009-03-09 02:00:00	ES	Futures	652.5	652.5	649.18	649.18	2150.0
2009-03-09 03:00:00	ES	Futures	649.41	653.21	647.75	652.26	8488.0
2009-03-09 04:00:00	ES	Futures	652.02	652.02	640.64	643.25	42817.0
2009-03-09 05:00:00	ES	Futures	643.25	643.48	636.37	642.3	39171.0
2009-03-09 06:00:00	ES	Futures	642.3	645.86	641.35	641.82	27626.0
2009-03-09 07:00:00	ES	Futures	641.82	646.33	638.98	643.25	31940.0
2009-03-09 08:00:00	ES	Futures	643.25	644.2	640.4	642.54	40848.0
2009-03-09 09:00:00	ES	Futures	642.54	653.92	639.21	648.94	345940.0
2009-03-09 10:00:00	ES	Futures	648.94	659.14	647.99	648.7	462448.0
2009-03-09 11:00:00	ES	Futures	648.7	652.02	645.86	648.94	303274.0
2009-03-09 12:00:00	ES	Futures	649.18	653.92	646.33	647.52	256607.0
2009-03-09 13:00:00	ES	Futures	647.52	647.52	641.35	644.67	240786.0
2009-03-09 14:00:00	ES	Futures	644.43	649.41	641.35	644.43	322419.0
2009-03-09 15:00:00	ES	Futures	644.2	646.57	637.55	640.64	421436.0
2009-03-09 16:00:00	ES	Futures	640.87	641.59	638.74	639.93	91029.0
2009-03-09 17:00:00	ES	Futures	639.93	640.16	639.21	639.69	1060.0
2009-03-09 18:00:00	ES	Futures	639.69	640.4	638.98	640.16	2021.0
2009-03-09 19:00:00	ES	Futures	640.4	641.35	639.93	641.11	2678.0
2009-03-09 20:00:00	ES	Futures	641.35	643.25	641.11	643.01	3832.0
2009-03-09 21:00:00	ES	Futures	642.77	644.91	642.54	644.43	4610.0
2009-03-09 22:00:00	ES	Futures	644.67	644.91	639.69	644.2	5761.0
2009-03-09 23:00:00	ES	Futures	644.2	648.23	643.96	647.28	6177.0
2009-03-09 00:00:00	NQ	Futures	1213.67	1215.37	1213.67	1214.8	65.0
2009-03-09 01:00:00	NQ	Futures	1215.08	1217.34	1215.08	1216.5	137.0
2009-03-09 02:00:00	NQ	Futures	1216.21	1216.21	1211.41	1211.7	396.0
2009-03-09 03:00:00	NQ	Futures	1211.41	1216.5	1207.74	1215.08	648.0
2009-03-09 04:00:00	NQ	Futures	1214.8	1214.8	1198.14	1203.51	3792.0
2009-03-09 05:00:00	NQ	Futures	1203.79	1203.79	1191.36	1200.4	4466.0
2009-03-09 06:00:00	NQ	Futures	1200.68	1205.77	1198.71	1200.68	1351.0
2009-03-09 07:00:00	NQ	Futures	1200.96	1208.02	1196.16	1204.92	2003.0
2009-03-09 08:00:00	NQ	Futures	1205.2	1205.77	1196.16	1199.27	5405.0
2009-03-09 09:00:00	NQ	Futures	1199.84	1222.99	1192.21	1211.7	58324.0
2009-03-09 10:00:00	NQ	Futures	1211.13	1228.64	1198.99	1199.27	70502.0
2009-03-09 11:00:00	NQ	Futures	1199.27	1206.89	1192.78	1196.73	48756.0
2009-03-09 12:00:00	NQ	Futures	1197.01	1204.92	1190.8	1192.49	39154.0
2009-03-09 13:00:00	NQ	Futures	1192.78	1193.06	1181.2	1185.43	43128.0
2009-03-09 14:00:00	NQ	Futures	1185.43	1193.34	1179.5	1183.17	54895.0
2009-03-09 15:00:00	NQ	Futures	1182.89	1186.85	1174.99	1179.22	73124.0
2009-03-09 16:00:00	NQ	Futures	1179.22	1184.59	1176.68	1180.63	12686.0
2009-03-09 17:00:00	NQ	Futures	1180.07	1182.05	1179.22	1180.63	368.0
2009-03-09 18:00:00	NQ	Futures	1180.35	1181.76	1179.22	1181.76	168.0
2009-03-09 19:00:00	NQ	Futures	1182.05	1183.17	1181.48	1181.76	366.0
2009-03-09 20:00:00	NQ	Futures	1181.76	1187.13	1181.76	1186.56	332.0
2009-03-09 21:00:00	NQ	Futures	1186.28	1188.82	1185.15	1187.98	162.0
2009-03-09 22:00:00	NQ	Futures	1187.69	1188.82	1180.92	1188.26	234.0
2009-03-09 23:00:00	NQ	Futures	1187.69	1193.62	1187.69	1192.49	413.0
2009-03-09 00:00:00	YM	Futures	6061.8	6075.5	6061.8	6073.6	239.0
2009-03-09 01:00:00	YM	Futures	6072.7	6083.7	6072.7	6074.6	160.0

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

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