PREVIEW / futures_1hour / 2009-03-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	781.69	782.88	780.73	781.69	2128.0
2009-03-26 01:00:00	ES	Futures	781.45	784.56	781.45	783.84	3627.0
2009-03-26 02:00:00	ES	Futures	783.84	787.92	783.84	786.72	6655.0
2009-03-26 03:00:00	ES	Futures	786.48	786.72	782.88	783.84	10377.0
2009-03-26 04:00:00	ES	Futures	784.08	785.04	780.01	781.21	18914.0
2009-03-26 05:00:00	ES	Futures	781.21	782.88	779.53	780.73	14676.0
2009-03-26 06:00:00	ES	Futures	780.73	784.56	780.25	782.88	14109.0
2009-03-26 07:00:00	ES	Futures	782.64	784.8	780.73	784.56	24270.0
2009-03-26 08:00:00	ES	Futures	784.56	787.44	780.97	784.56	61182.0
2009-03-26 09:00:00	ES	Futures	784.56	789.11	780.01	780.73	302824.0
2009-03-26 10:00:00	ES	Futures	780.97	785.04	777.37	782.4	418117.0
2009-03-26 11:00:00	ES	Futures	782.64	787.2	781.45	784.08	267678.0
2009-03-26 12:00:00	ES	Futures	784.32	788.87	782.64	783.84	254009.0
2009-03-26 13:00:00	ES	Futures	783.84	794.63	783.36	790.07	348401.0
2009-03-26 14:00:00	ES	Futures	790.07	794.39	783.12	783.6	318850.0
2009-03-26 15:00:00	ES	Futures	783.36	795.1	783.12	793.67	461060.0
2009-03-26 16:00:00	ES	Futures	793.67	796.06	791.75	792.71	132299.0
2009-03-26 17:00:00	ES	Futures	792.47	794.87	792.47	794.87	4153.0
2009-03-26 18:00:00	ES	Futures	794.15	795.58	792.23	792.23	3588.0
2009-03-26 19:00:00	ES	Futures	792.47	792.95	791.75	791.75	1865.0
2009-03-26 20:00:00	ES	Futures	791.75	793.67	791.51	793.43	2224.0
2009-03-26 21:00:00	ES	Futures	793.43	794.63	790.55	790.79	4552.0
2009-03-26 22:00:00	ES	Futures	790.55	791.03	789.35	789.35	3807.0
2009-03-26 23:00:00	ES	Futures	789.59	790.31	788.87	790.31	2984.0
2009-03-26 00:00:00	NQ	Futures	1414.16	1417.01	1412.74	1415.02	237.0
2009-03-26 01:00:00	NQ	Futures	1415.3	1419.28	1415.3	1418.43	155.0
2009-03-26 02:00:00	NQ	Futures	1418.71	1424.68	1418.43	1422.97	669.0
2009-03-26 03:00:00	NQ	Futures	1422.97	1423.54	1419.85	1420.7	603.0
2009-03-26 04:00:00	NQ	Futures	1420.98	1422.69	1414.73	1415.58	1444.0
2009-03-26 05:00:00	NQ	Futures	1415.87	1418.43	1413.88	1415.87	1007.0
2009-03-26 06:00:00	NQ	Futures	1415.87	1420.7	1415.02	1418.14	747.0
2009-03-26 07:00:00	NQ	Futures	1418.14	1422.97	1416.15	1422.69	3922.0
2009-03-26 08:00:00	NQ	Futures	1422.69	1431.5	1419.56	1424.96	7756.0
2009-03-26 09:00:00	NQ	Futures	1425.25	1435.47	1420.13	1425.81	47507.0
2009-03-26 10:00:00	NQ	Futures	1425.25	1432.92	1420.13	1429.51	56581.0
2009-03-26 11:00:00	NQ	Futures	1429.51	1439.74	1427.8	1436.04	41658.0
2009-03-26 12:00:00	NQ	Futures	1435.76	1444.85	1434.34	1435.47	41410.0
2009-03-26 13:00:00	NQ	Futures	1435.76	1452.52	1434.91	1446.27	51578.0
2009-03-26 14:00:00	NQ	Futures	1446.27	1451.67	1434.34	1434.34	44851.0
2009-03-26 15:00:00	NQ	Futures	1434.34	1453.09	1433.2	1452.24	62730.0
2009-03-26 16:00:00	NQ	Futures	1452.24	1456.78	1445.99	1448.83	17645.0
2009-03-26 17:00:00	NQ	Futures	1448.54	1451.39	1447.69	1451.1	229.0
2009-03-26 18:00:00	NQ	Futures	1449.97	1451.39	1446.27	1446.27	461.0
2009-03-26 19:00:00	NQ	Futures	1446.56	1447.12	1445.7	1446.84	181.0
2009-03-26 20:00:00	NQ	Futures	1446.56	1447.98	1445.7	1447.69	167.0
2009-03-26 21:00:00	NQ	Futures	1447.69	1449.97	1443.43	1443.43	322.0
2009-03-26 22:00:00	NQ	Futures	1443.71	1443.71	1441.73	1441.73	235.0
2009-03-26 23:00:00	NQ	Futures	1441.73	1442.29	1439.45	1441.73	168.0
2009-03-26 00:00:00	YM	Futures	7109.9	7117.3	7103.5	7109.0	170.0
2009-03-26 01:00:00	YM	Futures	7105.3	7132.0	7105.3	7129.2	204.0

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

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