PREVIEW / futures_1hour / 2017-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-19.parquet
  size:    54 KB
  rows:    1,649

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-01-19 00:00:00	ES	Futures	2472.1	2472.38	2471.29	2471.56	2090.0
2017-01-19 01:00:00	ES	Futures	2471.56	2473.2	2471.56	2472.92	2507.0
2017-01-19 02:00:00	ES	Futures	2472.65	2473.2	2472.1	2472.65	3701.0
2017-01-19 03:00:00	ES	Futures	2472.65	2472.92	2470.47	2470.74	11826.0
2017-01-19 04:00:00	ES	Futures	2470.74	2472.1	2469.1	2469.1	12277.0
2017-01-19 05:00:00	ES	Futures	2469.1	2469.38	2467.47	2468.56	14002.0
2017-01-19 06:00:00	ES	Futures	2468.29	2471.29	2468.29	2471.29	7436.0
2017-01-19 07:00:00	ES	Futures	2471.29	2471.29	2469.92	2470.47	8993.0
2017-01-19 08:00:00	ES	Futures	2470.47	2472.92	2469.92	2472.1	20386.0
2017-01-19 09:00:00	ES	Futures	2472.1	2476.2	2471.56	2473.47	167880.0
2017-01-19 10:00:00	ES	Futures	2473.2	2473.74	2468.01	2469.65	177676.0
2017-01-19 11:00:00	ES	Futures	2469.65	2471.29	2465.29	2469.65	164115.0
2017-01-19 12:00:00	ES	Futures	2469.38	2470.2	2467.2	2468.56	90711.0
2017-01-19 13:00:00	ES	Futures	2468.83	2469.65	2465.83	2466.38	94029.0
2017-01-19 14:00:00	ES	Futures	2466.38	2466.92	2458.19	2462.01	205535.0
2017-01-19 15:00:00	ES	Futures	2462.01	2466.38	2460.65	2464.47	263545.0
2017-01-19 16:00:00	ES	Futures	2464.47	2468.56	2464.47	2467.2	112843.0
2017-01-19 18:00:00	ES	Futures	2466.92	2469.38	2466.65	2469.1	5414.0
2017-01-19 19:00:00	ES	Futures	2469.1	2471.83	2468.83	2470.74	8112.0
2017-01-19 20:00:00	ES	Futures	2470.47	2470.74	2469.1	2469.38	3962.0
2017-01-19 21:00:00	ES	Futures	2469.65	2470.74	2469.1	2469.38	4455.0
2017-01-19 22:00:00	ES	Futures	2469.38	2471.29	2469.38	2470.47	2710.0
2017-01-19 23:00:00	ES	Futures	2470.2	2470.47	2469.65	2470.2	1280.0
2017-01-19 00:00:00	NQ	Futures	6028.45	6029.94	6026.96	6028.15	528.0
2017-01-19 01:00:00	NQ	Futures	6027.85	6031.43	6027.85	6029.94	525.0
2017-01-19 02:00:00	NQ	Futures	6029.94	6031.13	6028.45	6029.34	684.0
2017-01-19 03:00:00	NQ	Futures	6029.64	6030.24	6024.87	6025.76	2095.0
2017-01-19 04:00:00	NQ	Futures	6026.06	6029.94	6023.67	6023.67	2153.0
2017-01-19 05:00:00	NQ	Futures	6023.38	6023.38	6017.71	6018.6	2341.0
2017-01-19 06:00:00	NQ	Futures	6018.6	6029.04	6018.6	6028.75	1780.0
2017-01-19 07:00:00	NQ	Futures	6028.75	6029.34	6025.17	6026.96	1495.0
2017-01-19 08:00:00	NQ	Futures	6026.66	6033.22	6025.76	6031.13	3081.0
2017-01-19 09:00:00	NQ	Futures	6031.13	6055.59	6028.15	6054.1	35099.0
2017-01-19 10:00:00	NQ	Futures	6054.1	6054.4	6026.66	6030.24	33043.0
2017-01-19 11:00:00	NQ	Futures	6029.94	6040.68	6021.29	6035.91	22853.0
2017-01-19 12:00:00	NQ	Futures	6035.91	6039.78	6031.73	6034.12	10839.0
2017-01-19 13:00:00	NQ	Futures	6034.41	6036.2	6026.36	6027.55	11768.0
2017-01-19 14:00:00	NQ	Futures	6027.55	6029.34	6009.95	6018.01	23968.0
2017-01-19 15:00:00	NQ	Futures	6018.3	6026.66	6015.62	6022.18	21146.0
2017-01-19 16:00:00	NQ	Futures	6021.88	6033.52	6021.59	6033.22	6086.0
2017-01-19 18:00:00	NQ	Futures	6032.62	6035.91	6030.24	6034.12	1169.0
2017-01-19 19:00:00	NQ	Futures	6034.41	6042.17	6033.82	6039.78	1747.0
2017-01-19 20:00:00	NQ	Futures	6039.48	6040.98	6037.1	6037.4	736.0
2017-01-19 21:00:00	NQ	Futures	6037.69	6040.68	6037.4	6038.59	898.0
2017-01-19 22:00:00	NQ	Futures	6038.59	6042.77	6038.29	6040.38	657.0
2017-01-19 23:00:00	NQ	Futures	6040.68	6041.57	6039.78	6041.27	348.0
2017-01-19 00:00:00	YM	Futures	21402.4	21404.6	21398.1	21399.2	368.0
2017-01-19 01:00:00	YM	Futures	21399.2	21413.3	21398.1	21407.9	353.0
2017-01-19 02:00:00	YM	Futures	21407.9	21412.2	21405.7	21408.9	676.0
2017-01-19 03:00:00	YM	Futures	21410.0	21412.2	21387.2	21390.5	1635.0

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

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