PREVIEW / futures_1hour / 2010-03-18

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-18.parquet
  size:    44 KB
  rows:    1,357

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
2010-03-18 00:00:00	ES	Futures	1135.85	1136.58	1135.6	1135.6	1258.0
2010-03-18 01:00:00	ES	Futures	1135.85	1135.85	1133.4	1133.65	7138.0
2010-03-18 02:00:00	ES	Futures	1133.65	1133.89	1132.92	1133.4	3502.0
2010-03-18 03:00:00	ES	Futures	1133.65	1133.89	1131.69	1131.94	10433.0
2010-03-18 04:00:00	ES	Futures	1131.69	1133.65	1131.45	1132.92	18134.0
2010-03-18 05:00:00	ES	Futures	1132.92	1134.14	1131.69	1133.65	12329.0
2010-03-18 06:00:00	ES	Futures	1133.65	1134.38	1132.67	1134.14	9698.0
2010-03-18 07:00:00	ES	Futures	1134.14	1134.63	1133.4	1134.38	15910.0
2010-03-18 08:00:00	ES	Futures	1134.38	1136.58	1134.14	1135.12	50133.0
2010-03-18 09:00:00	ES	Futures	1134.87	1136.58	1134.38	1135.85	162733.0
2010-03-18 10:00:00	ES	Futures	1135.85	1137.32	1132.92	1135.12	220560.0
2010-03-18 11:00:00	ES	Futures	1135.12	1136.34	1131.69	1132.18	282870.0
2010-03-18 12:00:00	ES	Futures	1132.43	1132.67	1130.47	1131.69	197577.0
2010-03-18 13:00:00	ES	Futures	1131.94	1134.63	1131.69	1133.65	104654.0
2010-03-18 14:00:00	ES	Futures	1133.65	1135.6	1132.43	1133.65	161724.0
2010-03-18 15:00:00	ES	Futures	1133.89	1136.09	1132.92	1134.87	251485.0
2010-03-18 16:00:00	ES	Futures	1134.87	1136.09	1134.38	1135.36	88757.0
2010-03-18 17:00:00	ES	Futures	1135.6	1135.85	1135.36	1135.36	1478.0
2010-03-18 18:00:00	ES	Futures	1135.6	1136.09	1135.12	1135.6	3138.0
2010-03-18 19:00:00	ES	Futures	1135.36	1135.85	1134.38	1134.63	2687.0
2010-03-18 20:00:00	ES	Futures	1134.87	1135.6	1134.38	1135.12	1960.0
2010-03-18 21:00:00	ES	Futures	1135.12	1136.34	1134.87	1135.85	2401.0
2010-03-18 22:00:00	ES	Futures	1135.85	1136.34	1135.12	1135.36	3550.0
2010-03-18 23:00:00	ES	Futures	1135.36	1135.85	1135.12	1135.36	1664.0
2010-03-18 00:00:00	NQ	Futures	2215.38	2216.52	2214.23	2214.23	59.0
2010-03-18 01:00:00	NQ	Futures	2214.23	2214.52	2212.51	2212.8	298.0
2010-03-18 02:00:00	NQ	Futures	2213.09	2213.66	2212.23	2212.51	282.0
2010-03-18 03:00:00	NQ	Futures	2212.51	2212.8	2209.94	2209.94	848.0
2010-03-18 04:00:00	NQ	Futures	2209.94	2213.09	2209.36	2211.37	1564.0
2010-03-18 05:00:00	NQ	Futures	2211.37	2213.66	2210.22	2212.51	896.0
2010-03-18 06:00:00	NQ	Futures	2212.51	2214.23	2211.66	2213.95	814.0
2010-03-18 07:00:00	NQ	Futures	2213.95	2215.38	2213.95	2215.09	1045.0
2010-03-18 08:00:00	NQ	Futures	2215.09	2219.39	2214.81	2216.52	4467.0
2010-03-18 09:00:00	NQ	Futures	2216.81	2219.96	2214.81	2217.38	25253.0
2010-03-18 10:00:00	NQ	Futures	2217.67	2220.53	2213.37	2219.39	30987.0
2010-03-18 11:00:00	NQ	Futures	2219.39	2223.11	2215.95	2216.52	41292.0
2010-03-18 12:00:00	NQ	Futures	2216.52	2218.24	2212.51	2217.67	28164.0
2010-03-18 13:00:00	NQ	Futures	2217.96	2222.25	2217.67	2220.82	18780.0
2010-03-18 14:00:00	NQ	Futures	2220.82	2223.97	2217.38	2220.82	27248.0
2010-03-18 15:00:00	NQ	Futures	2220.53	2225.4	2218.24	2222.54	31704.0
2010-03-18 16:00:00	NQ	Futures	2222.54	2225.4	2222.25	2223.68	9183.0
2010-03-18 17:00:00	NQ	Futures	2223.68	2225.12	2223.11	2224.83	162.0
2010-03-18 18:00:00	NQ	Futures	2224.26	2224.26	2223.11	2223.4	154.0
2010-03-18 19:00:00	NQ	Futures	2223.4	2223.97	2220.82	2221.11	340.0
2010-03-18 20:00:00	NQ	Futures	2221.39	2223.4	2221.11	2222.54	267.0
2010-03-18 21:00:00	NQ	Futures	2222.25	2224.54	2221.68	2223.97	367.0
2010-03-18 22:00:00	NQ	Futures	2223.68	2224.26	2222.25	2223.4	128.0
2010-03-18 23:00:00	NQ	Futures	2223.4	2223.68	2222.54	2223.11	154.0
2010-03-18 00:00:00	YM	Futures	10037.4	10043.1	10037.4	10038.4	88.0
2010-03-18 01:00:00	YM	Futures	10038.4	10038.4	10021.4	10023.3	305.0

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

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