PREVIEW / futures_1hour / 2009-03-05

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-05.parquet
  size:    43 KB
  rows:    1,239

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-05 00:00:00	ES	Futures	668.39	668.86	666.73	667.44	2662.0
2009-03-05 01:00:00	ES	Futures	666.97	668.39	665.78	668.15	3270.0
2009-03-05 02:00:00	ES	Futures	668.39	670.76	667.68	670.52	7589.0
2009-03-05 03:00:00	ES	Futures	670.52	670.52	666.97	666.97	21109.0
2009-03-05 04:00:00	ES	Futures	666.97	667.2	664.36	666.25	25336.0
2009-03-05 05:00:00	ES	Futures	666.25	667.91	662.46	662.93	19424.0
2009-03-05 06:00:00	ES	Futures	663.17	664.36	657.95	661.75	42189.0
2009-03-05 07:00:00	ES	Futures	661.75	662.46	657.71	659.85	38627.0
2009-03-05 08:00:00	ES	Futures	659.85	662.7	656.05	657.0	86206.0
2009-03-05 09:00:00	ES	Futures	657.24	666.25	657.0	663.64	316020.0
2009-03-05 10:00:00	ES	Futures	663.64	667.44	656.53	657.0	437369.0
2009-03-05 11:00:00	ES	Futures	657.0	658.9	649.65	651.31	445808.0
2009-03-05 12:00:00	ES	Futures	651.55	654.39	647.75	650.36	280904.0
2009-03-05 13:00:00	ES	Futures	650.13	657.0	648.46	651.31	307129.0
2009-03-05 14:00:00	ES	Futures	651.07	651.55	645.62	646.8	380889.0
2009-03-05 15:00:00	ES	Futures	646.57	653.45	641.59	647.52	671650.0
2009-03-05 16:00:00	ES	Futures	647.52	651.79	647.04	651.55	151378.0
2009-03-05 17:00:00	ES	Futures	651.31	652.5	651.31	652.5	3183.0
2009-03-05 18:00:00	ES	Futures	652.26	652.97	649.89	650.13	6429.0
2009-03-05 19:00:00	ES	Futures	650.13	651.31	649.41	650.13	4766.0
2009-03-05 20:00:00	ES	Futures	649.89	649.89	648.46	649.18	4562.0
2009-03-05 21:00:00	ES	Futures	649.18	650.36	648.46	650.13	3089.0
2009-03-05 22:00:00	ES	Futures	650.13	650.36	648.7	650.13	3429.0
2009-03-05 23:00:00	ES	Futures	650.13	650.36	649.18	650.13	1164.0
2009-03-05 00:00:00	NQ	Futures	1240.5	1241.63	1239.09	1239.65	43.0
2009-03-05 01:00:00	NQ	Futures	1238.52	1241.35	1237.39	1240.78	86.0
2009-03-05 02:00:00	NQ	Futures	1241.06	1244.73	1240.5	1244.45	248.0
2009-03-05 03:00:00	NQ	Futures	1244.45	1244.73	1238.8	1239.09	1082.0
2009-03-05 04:00:00	NQ	Futures	1239.09	1241.63	1234.85	1240.22	1431.0
2009-03-05 05:00:00	NQ	Futures	1240.22	1243.04	1234.57	1235.13	869.0
2009-03-05 06:00:00	NQ	Futures	1235.42	1237.39	1227.79	1234.57	2657.0
2009-03-05 07:00:00	NQ	Futures	1234.29	1235.7	1226.66	1228.92	3711.0
2009-03-05 08:00:00	NQ	Futures	1229.2	1239.93	1229.2	1233.72	8774.0
2009-03-05 09:00:00	NQ	Futures	1233.72	1248.4	1231.46	1241.63	47290.0
2009-03-05 10:00:00	NQ	Futures	1241.63	1248.4	1227.51	1228.36	55970.0
2009-03-05 11:00:00	NQ	Futures	1228.36	1232.59	1218.47	1222.14	57588.0
2009-03-05 12:00:00	NQ	Futures	1221.86	1227.23	1215.65	1220.45	39397.0
2009-03-05 13:00:00	NQ	Futures	1220.45	1230.33	1218.19	1222.14	40448.0
2009-03-05 14:00:00	NQ	Futures	1222.43	1222.71	1212.26	1215.37	51663.0
2009-03-05 15:00:00	NQ	Futures	1215.65	1231.74	1210.85	1215.37	94612.0
2009-03-05 16:00:00	NQ	Futures	1215.37	1224.68	1213.67	1222.14	12857.0
2009-03-05 17:00:00	NQ	Futures	1222.14	1224.97	1222.14	1224.4	444.0
2009-03-05 18:00:00	NQ	Futures	1223.84	1224.97	1220.45	1220.45	260.0
2009-03-05 19:00:00	NQ	Futures	1220.45	1222.14	1218.75	1219.32	182.0
2009-03-05 20:00:00	NQ	Futures	1219.32	1220.45	1217.91	1220.17	189.0
2009-03-05 21:00:00	NQ	Futures	1220.73	1222.14	1219.04	1222.14	159.0
2009-03-05 22:00:00	NQ	Futures	1222.43	1222.99	1219.6	1222.14	83.0
2009-03-05 23:00:00	NQ	Futures	1222.43	1222.99	1220.17	1221.3	42.0
2009-03-05 00:00:00	YM	Futures	6194.8	6199.4	6183.9	6191.2	187.0
2009-03-05 01:00:00	YM	Futures	6191.2	6200.3	6179.3	6196.7	269.0

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

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