PREVIEW / futures_1hour / 2017-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-31.parquet
  size:    45 KB
  rows:    1,358

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
2017-03-31 00:00:00	ES	Futures	2580.38	2580.93	2579.02	2579.56	3762.0
2017-03-31 01:00:00	ES	Futures	2579.56	2579.56	2575.19	2577.65	15809.0
2017-03-31 02:00:00	ES	Futures	2577.65	2577.92	2574.92	2576.83	11015.0
2017-03-31 03:00:00	ES	Futures	2576.83	2579.29	2575.74	2577.38	13881.0
2017-03-31 04:00:00	ES	Futures	2577.1	2577.38	2575.47	2576.28	10288.0
2017-03-31 05:00:00	ES	Futures	2576.56	2578.47	2575.47	2576.83	10351.0
2017-03-31 06:00:00	ES	Futures	2576.83	2577.65	2576.01	2576.28	7952.0
2017-03-31 07:00:00	ES	Futures	2576.56	2578.47	2576.28	2578.2	8830.0
2017-03-31 08:00:00	ES	Futures	2578.47	2581.75	2578.2	2580.11	20690.0
2017-03-31 09:00:00	ES	Futures	2579.84	2581.47	2576.83	2580.38	108987.0
2017-03-31 10:00:00	ES	Futures	2580.38	2584.21	2579.02	2581.75	167346.0
2017-03-31 11:00:00	ES	Futures	2581.75	2584.21	2580.65	2581.75	119367.0
2017-03-31 12:00:00	ES	Futures	2582.02	2584.48	2581.47	2582.84	71152.0
2017-03-31 13:00:00	ES	Futures	2583.11	2585.84	2581.75	2582.02	105068.0
2017-03-31 14:00:00	ES	Futures	2582.02	2582.29	2577.92	2579.02	159565.0
2017-03-31 15:00:00	ES	Futures	2579.29	2585.3	2576.56	2576.83	502756.0
2017-03-31 16:00:00	ES	Futures	2576.83	2579.56	2575.74	2575.74	167587.0
2017-03-31 00:00:00	NQ	Futures	6478.29	6478.59	6475.9	6476.8	672.0
2017-03-31 01:00:00	NQ	Futures	6476.5	6476.5	6465.17	6469.05	2325.0
2017-03-31 02:00:00	NQ	Futures	6469.05	6473.22	6464.87	6471.13	2154.0
2017-03-31 03:00:00	NQ	Futures	6470.83	6476.2	6467.26	6472.33	2248.0
2017-03-31 04:00:00	NQ	Futures	6472.33	6473.22	6468.45	6472.03	1808.0
2017-03-31 05:00:00	NQ	Futures	6472.03	6477.99	6469.05	6473.82	2118.0
2017-03-31 06:00:00	NQ	Futures	6473.52	6475.01	6472.33	6473.52	1082.0
2017-03-31 07:00:00	NQ	Futures	6473.82	6477.1	6473.52	6477.1	1083.0
2017-03-31 08:00:00	NQ	Futures	6477.39	6484.85	6477.1	6480.67	3399.0
2017-03-31 09:00:00	NQ	Futures	6480.67	6486.93	6472.33	6483.36	19298.0
2017-03-31 10:00:00	NQ	Futures	6483.06	6494.09	6482.76	6489.32	24700.0
2017-03-31 11:00:00	NQ	Futures	6489.32	6497.67	6488.43	6492.0	16533.0
2017-03-31 12:00:00	NQ	Futures	6492.0	6499.46	6491.7	6496.77	10861.0
2017-03-31 13:00:00	NQ	Futures	6496.77	6502.74	6489.32	6489.32	15049.0
2017-03-31 14:00:00	NQ	Futures	6489.32	6491.41	6480.08	6486.04	19734.0
2017-03-31 15:00:00	NQ	Futures	6486.34	6500.95	6483.36	6483.36	29553.0
2017-03-31 16:00:00	NQ	Futures	6483.95	6487.83	6482.46	6482.46	8329.0
2017-03-31 00:00:00	YM	Futures	22436.8	22439.0	22425.9	22428.1	513.0
2017-03-31 01:00:00	YM	Futures	22428.1	22428.1	22396.6	22411.8	2317.0
2017-03-31 02:00:00	YM	Futures	22412.9	22417.2	22396.6	22409.6	1416.0
2017-03-31 03:00:00	YM	Futures	22408.5	22431.4	22400.9	22414.0	2091.0
2017-03-31 04:00:00	YM	Futures	22412.9	22414.0	22398.8	22408.5	1714.0
2017-03-31 05:00:00	YM	Futures	22407.5	22425.9	22400.9	22411.8	1229.0
2017-03-31 06:00:00	YM	Futures	22411.8	22417.2	22404.2	22405.3	898.0
2017-03-31 07:00:00	YM	Futures	22405.3	22427.0	22405.3	22425.9	1096.0
2017-03-31 08:00:00	YM	Futures	22425.9	22449.8	22425.9	22435.7	2942.0
2017-03-31 09:00:00	YM	Futures	22436.8	22442.2	22400.9	22403.1	12722.0
2017-03-31 10:00:00	YM	Futures	22404.2	22434.6	22402.0	22411.8	13336.0
2017-03-31 11:00:00	YM	Futures	22411.8	22435.7	22405.3	22416.2	8822.0
2017-03-31 12:00:00	YM	Futures	22416.2	22434.6	22414.0	22427.0	4501.0
2017-03-31 13:00:00	YM	Futures	22427.0	22452.0	22420.5	22423.8	6575.0
2017-03-31 14:00:00	YM	Futures	22423.8	22425.9	22383.6	22393.3	12993.0
2017-03-31 15:00:00	YM	Futures	22394.4	22447.7	22384.6	22387.9	19667.0

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

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