PREVIEW / futures_1hour / 2009-01-09

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-09.parquet
  size:    38 KB
  rows:    1,037

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-01-09 00:00:00	ES	Futures	862.41	862.64	860.51	861.22	1670.0
2009-01-09 01:00:00	ES	Futures	861.22	861.93	859.32	859.32	852.0
2009-01-09 02:00:00	ES	Futures	859.32	859.8	858.14	858.85	3946.0
2009-01-09 03:00:00	ES	Futures	858.85	859.32	854.1	855.05	15440.0
2009-01-09 04:00:00	ES	Futures	855.05	857.66	853.87	855.53	8019.0
2009-01-09 05:00:00	ES	Futures	855.76	858.85	855.76	858.61	6564.0
2009-01-09 06:00:00	ES	Futures	858.61	859.8	856.0	857.66	6338.0
2009-01-09 07:00:00	ES	Futures	857.9	859.56	857.19	858.85	10181.0
2009-01-09 08:00:00	ES	Futures	858.85	867.86	856.95	864.54	149848.0
2009-01-09 09:00:00	ES	Futures	864.54	864.78	842.25	844.85	395764.0
2009-01-09 10:00:00	ES	Futures	844.85	848.41	841.3	845.33	327230.0
2009-01-09 11:00:00	ES	Futures	845.57	850.07	843.91	846.28	195456.0
2009-01-09 12:00:00	ES	Futures	846.28	849.84	844.62	845.8	124001.0
2009-01-09 13:00:00	ES	Futures	845.57	848.65	842.72	845.09	146886.0
2009-01-09 14:00:00	ES	Futures	845.09	852.21	844.85	850.07	175989.0
2009-01-09 15:00:00	ES	Futures	850.07	851.73	838.92	841.53	348641.0
2009-01-09 16:00:00	ES	Futures	841.06	842.48	837.5	839.87	114449.0
2009-01-09 00:00:00	NQ	Futures	1415.57	1415.57	1413.32	1415.01	63.0
2009-01-09 01:00:00	NQ	Futures	1414.16	1414.16	1410.77	1410.77	31.0
2009-01-09 02:00:00	NQ	Futures	1410.77	1411.9	1408.51	1409.36	98.0
2009-01-09 03:00:00	NQ	Futures	1409.08	1409.93	1399.76	1400.89	1383.0
2009-01-09 04:00:00	NQ	Futures	1400.61	1405.97	1398.63	1401.17	611.0
2009-01-09 05:00:00	NQ	Futures	1401.74	1407.39	1401.17	1407.1	315.0
2009-01-09 06:00:00	NQ	Futures	1407.1	1408.51	1401.17	1404.84	349.0
2009-01-09 07:00:00	NQ	Futures	1405.13	1410.21	1404.56	1408.51	653.0
2009-01-09 08:00:00	NQ	Futures	1408.23	1418.96	1402.58	1416.99	13030.0
2009-01-09 09:00:00	NQ	Futures	1417.27	1417.55	1373.5	1376.89	53421.0
2009-01-09 10:00:00	NQ	Futures	1376.61	1385.64	1374.06	1381.41	43775.0
2009-01-09 11:00:00	NQ	Futures	1381.41	1389.6	1379.15	1385.08	21928.0
2009-01-09 12:00:00	NQ	Futures	1385.08	1391.85	1384.23	1385.36	16511.0
2009-01-09 13:00:00	NQ	Futures	1385.36	1390.72	1380.84	1385.64	17542.0
2009-01-09 14:00:00	NQ	Futures	1385.36	1399.2	1385.08	1395.53	24055.0
2009-01-09 15:00:00	NQ	Futures	1395.53	1397.78	1378.02	1380.56	41283.0
2009-01-09 16:00:00	NQ	Futures	1380.56	1382.54	1374.63	1379.15	9189.0
2009-01-09 00:00:00	YM	Futures	7936.3	7939.0	7920.8	7926.3	121.0
2009-01-09 01:00:00	YM	Futures	7926.3	7934.5	7910.8	7910.8	152.0
2009-01-09 02:00:00	YM	Futures	7911.7	7918.1	7900.7	7906.2	401.0
2009-01-09 03:00:00	YM	Futures	7908.0	7910.8	7873.4	7879.8	724.0
2009-01-09 04:00:00	YM	Futures	7878.0	7896.2	7872.5	7888.9	408.0
2009-01-09 05:00:00	YM	Futures	7890.7	7905.3	7883.4	7904.4	317.0
2009-01-09 06:00:00	YM	Futures	7903.5	7911.7	7881.6	7893.5	292.0
2009-01-09 07:00:00	YM	Futures	7894.4	7909.9	7891.6	7903.5	484.0
2009-01-09 08:00:00	YM	Futures	7902.6	7972.7	7891.6	7955.4	7240.0
2009-01-09 09:00:00	YM	Futures	7954.5	7956.3	7792.3	7815.1	26264.0
2009-01-09 10:00:00	YM	Futures	7814.2	7834.2	7784.1	7816.9	29466.0
2009-01-09 11:00:00	YM	Futures	7816.0	7854.3	7803.2	7834.2	17721.0
2009-01-09 12:00:00	YM	Futures	7834.2	7858.8	7813.3	7825.1	9094.0
2009-01-09 13:00:00	YM	Futures	7824.2	7848.8	7802.3	7819.6	13523.0
2009-01-09 14:00:00	YM	Futures	7819.6	7880.7	7817.8	7858.8	15958.0
2009-01-09 15:00:00	YM	Futures	7858.8	7876.1	7774.1	7791.4	29144.0

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

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