PREVIEW / futures_1hour / 2009-01-08

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-08.parquet
  size:    44 KB
  rows:    1,275

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-08 00:00:00	ES	Futures	857.66	857.9	856.48	856.95	1693.0
2009-01-08 01:00:00	ES	Futures	856.95	857.19	853.63	854.58	4609.0
2009-01-08 02:00:00	ES	Futures	854.34	855.29	853.39	854.34	7014.0
2009-01-08 03:00:00	ES	Futures	854.58	858.37	853.39	857.9	12775.0
2009-01-08 04:00:00	ES	Futures	858.14	860.51	856.71	857.43	11455.0
2009-01-08 05:00:00	ES	Futures	857.43	857.9	852.21	854.82	12271.0
2009-01-08 06:00:00	ES	Futures	855.05	858.14	854.1	856.24	8248.0
2009-01-08 07:00:00	ES	Futures	856.0	859.56	847.7	849.12	40921.0
2009-01-08 08:00:00	ES	Futures	849.12	852.44	845.8	851.5	66393.0
2009-01-08 09:00:00	ES	Futures	851.5	854.58	847.94	849.84	215926.0
2009-01-08 10:00:00	ES	Futures	849.6	857.43	847.7	855.76	314974.0
2009-01-08 11:00:00	ES	Futures	855.76	858.37	849.84	851.02	223484.0
2009-01-08 12:00:00	ES	Futures	851.02	856.0	850.55	852.68	122442.0
2009-01-08 13:00:00	ES	Futures	852.68	852.92	848.41	851.5	138558.0
2009-01-08 14:00:00	ES	Futures	851.5	859.09	850.55	857.66	217668.0
2009-01-08 15:00:00	ES	Futures	857.66	861.22	852.92	860.98	301768.0
2009-01-08 16:00:00	ES	Futures	860.98	860.98	859.09	860.03	56091.0
2009-01-08 17:00:00	ES	Futures	859.8	860.75	859.32	860.51	996.0
2009-01-08 18:00:00	ES	Futures	860.51	863.35	859.56	861.46	3512.0
2009-01-08 19:00:00	ES	Futures	861.46	862.88	861.22	861.22	2243.0
2009-01-08 20:00:00	ES	Futures	861.46	861.69	858.85	860.51	2722.0
2009-01-08 21:00:00	ES	Futures	860.51	862.41	860.03	860.75	2483.0
2009-01-08 22:00:00	ES	Futures	860.75	861.93	860.27	861.69	1212.0
2009-01-08 23:00:00	ES	Futures	861.93	862.88	861.69	862.41	1844.0
2009-01-08 00:00:00	NQ	Futures	1397.22	1397.22	1395.81	1396.09	30.0
2009-01-08 01:00:00	NQ	Futures	1396.09	1396.65	1392.98	1394.11	176.0
2009-01-08 02:00:00	NQ	Futures	1393.27	1396.37	1392.98	1394.96	302.0
2009-01-08 03:00:00	NQ	Futures	1395.24	1400.04	1393.55	1399.76	536.0
2009-01-08 04:00:00	NQ	Futures	1399.48	1407.95	1398.35	1402.58	1769.0
2009-01-08 05:00:00	NQ	Futures	1402.3	1402.87	1394.11	1398.91	582.0
2009-01-08 06:00:00	NQ	Futures	1398.35	1404.0	1397.5	1400.33	439.0
2009-01-08 07:00:00	NQ	Futures	1400.61	1407.1	1388.75	1390.44	3391.0
2009-01-08 08:00:00	NQ	Futures	1390.72	1395.81	1384.79	1392.7	5817.0
2009-01-08 09:00:00	NQ	Futures	1392.7	1396.65	1382.54	1386.21	36150.0
2009-01-08 10:00:00	NQ	Futures	1385.92	1400.89	1381.12	1397.22	41272.0
2009-01-08 11:00:00	NQ	Futures	1397.22	1401.74	1386.49	1389.88	29479.0
2009-01-08 12:00:00	NQ	Futures	1389.6	1397.22	1388.47	1391.85	16147.0
2009-01-08 13:00:00	NQ	Futures	1391.85	1394.68	1385.08	1393.27	22560.0
2009-01-08 14:00:00	NQ	Futures	1393.27	1412.19	1391.85	1409.93	44334.0
2009-01-08 15:00:00	NQ	Futures	1410.21	1415.01	1402.02	1413.88	45261.0
2009-01-08 16:00:00	NQ	Futures	1413.88	1414.73	1409.93	1411.06	6805.0
2009-01-08 17:00:00	NQ	Futures	1410.49	1412.47	1410.21	1412.47	108.0
2009-01-08 18:00:00	NQ	Futures	1410.77	1415.86	1409.64	1414.44	310.0
2009-01-08 19:00:00	NQ	Futures	1414.44	1415.01	1412.47	1414.44	142.0
2009-01-08 20:00:00	NQ	Futures	1414.44	1414.44	1410.21	1412.19	81.0
2009-01-08 21:00:00	NQ	Futures	1413.32	1414.73	1413.03	1413.32	32.0
2009-01-08 22:00:00	NQ	Futures	1413.03	1414.73	1411.9	1413.88	71.0
2009-01-08 23:00:00	NQ	Futures	1414.44	1416.99	1414.44	1416.14	56.0
2009-01-08 00:00:00	YM	Futures	7954.5	7955.4	7946.3	7946.3	171.0
2009-01-08 01:00:00	YM	Futures	7948.1	7950.0	7921.7	7932.6	229.0

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

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