PREVIEW / futures_1hour / 2009-03-17

all futures 1-hour files

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

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-17 00:00:00	ES	Futures	723.21	725.61	722.5	725.13	4641.0
2009-03-17 01:00:00	ES	Futures	724.89	727.29	724.65	726.57	3181.0
2009-03-17 02:00:00	ES	Futures	726.81	727.77	725.85	726.81	3063.0
2009-03-17 03:00:00	ES	Futures	726.81	727.29	722.74	723.45	9087.0
2009-03-17 04:00:00	ES	Futures	723.21	725.13	721.06	724.89	21605.0
2009-03-17 05:00:00	ES	Futures	724.89	724.89	722.5	723.45	7657.0
2009-03-17 06:00:00	ES	Futures	723.69	727.77	723.69	724.65	15286.0
2009-03-17 07:00:00	ES	Futures	724.65	724.65	720.82	721.54	19571.0
2009-03-17 08:00:00	ES	Futures	721.54	725.37	718.42	723.69	58140.0
2009-03-17 09:00:00	ES	Futures	723.93	723.93	715.07	719.14	272922.0
2009-03-17 10:00:00	ES	Futures	719.14	726.81	718.9	725.13	403273.0
2009-03-17 11:00:00	ES	Futures	724.89	725.13	720.34	724.41	206700.0
2009-03-17 12:00:00	ES	Futures	724.41	732.8	723.21	730.64	258773.0
2009-03-17 13:00:00	ES	Futures	730.64	734.96	728.97	729.45	182086.0
2009-03-17 14:00:00	ES	Futures	729.45	734.24	727.05	731.84	268105.0
2009-03-17 15:00:00	ES	Futures	732.08	742.39	731.12	741.91	476311.0
2009-03-17 16:00:00	ES	Futures	741.91	744.78	740.95	743.82	158629.0
2009-03-17 17:00:00	ES	Futures	743.58	744.3	743.1	743.82	1772.0
2009-03-17 18:00:00	ES	Futures	743.34	743.82	742.15	742.39	2688.0
2009-03-17 19:00:00	ES	Futures	742.39	742.63	741.19	741.67	4060.0
2009-03-17 20:00:00	ES	Futures	741.91	742.15	740.47	740.71	3885.0
2009-03-17 21:00:00	ES	Futures	740.71	740.95	739.27	739.51	4739.0
2009-03-17 22:00:00	ES	Futures	739.27	741.43	739.27	740.47	2848.0
2009-03-17 23:00:00	ES	Futures	740.47	742.39	740.47	741.43	2270.0
2009-03-17 00:00:00	NQ	Futures	1311.59	1316.14	1310.45	1315.57	122.0
2009-03-17 01:00:00	NQ	Futures	1314.72	1318.98	1314.72	1318.69	328.0
2009-03-17 02:00:00	NQ	Futures	1318.69	1319.83	1316.99	1317.27	142.0
2009-03-17 03:00:00	NQ	Futures	1317.27	1318.98	1311.31	1312.73	479.0
2009-03-17 04:00:00	NQ	Futures	1312.73	1315.57	1309.6	1315.28	1425.0
2009-03-17 05:00:00	NQ	Futures	1315.57	1315.57	1311.02	1312.73	840.0
2009-03-17 06:00:00	NQ	Futures	1313.01	1319.83	1312.16	1312.44	1141.0
2009-03-17 07:00:00	NQ	Futures	1312.73	1312.73	1306.47	1306.76	1440.0
2009-03-17 08:00:00	NQ	Futures	1307.33	1314.72	1303.35	1311.59	4562.0
2009-03-17 09:00:00	NQ	Futures	1311.87	1319.55	1304.2	1313.86	41881.0
2009-03-17 10:00:00	NQ	Futures	1314.15	1322.39	1311.02	1319.83	47197.0
2009-03-17 11:00:00	NQ	Futures	1319.55	1322.39	1315.28	1321.53	25362.0
2009-03-17 12:00:00	NQ	Futures	1321.82	1331.2	1319.26	1327.5	36322.0
2009-03-17 13:00:00	NQ	Futures	1327.79	1336.03	1325.8	1327.22	33118.0
2009-03-17 14:00:00	NQ	Futures	1327.22	1336.03	1321.53	1332.62	34891.0
2009-03-17 15:00:00	NQ	Futures	1332.62	1351.94	1332.05	1351.65	74028.0
2009-03-17 16:00:00	NQ	Futures	1351.94	1354.78	1349.95	1353.07	17862.0
2009-03-17 17:00:00	NQ	Futures	1353.36	1353.93	1352.22	1352.22	184.0
2009-03-17 18:00:00	NQ	Futures	1353.07	1353.36	1351.37	1351.65	259.0
2009-03-17 19:00:00	NQ	Futures	1351.65	1352.22	1350.23	1351.08	191.0
2009-03-17 20:00:00	NQ	Futures	1350.8	1350.8	1348.53	1348.81	278.0
2009-03-17 21:00:00	NQ	Futures	1348.53	1348.81	1346.82	1347.96	247.0
2009-03-17 22:00:00	NQ	Futures	1347.68	1350.23	1347.39	1349.1	171.0
2009-03-17 23:00:00	NQ	Futures	1348.81	1352.22	1348.81	1349.1	109.0
2009-03-17 00:00:00	YM	Futures	6608.2	6628.4	6601.7	6622.9	441.0
2009-03-17 01:00:00	YM	Futures	6623.8	6643.1	6621.0	6636.7	208.0

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

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