PREVIEW / futures_1hour / 2017-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-20.parquet
  size:    46 KB
  rows:    1,343

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-20 00:00:00	ES	Futures	2470.2	2470.74	2470.2	2470.2	1482.0
2017-01-20 01:00:00	ES	Futures	2470.2	2471.01	2469.38	2469.38	2374.0
2017-01-20 02:00:00	ES	Futures	2469.38	2470.47	2468.56	2470.47	5444.0
2017-01-20 03:00:00	ES	Futures	2470.2	2472.1	2469.1	2471.29	17348.0
2017-01-20 04:00:00	ES	Futures	2471.29	2472.1	2470.47	2471.56	8594.0
2017-01-20 05:00:00	ES	Futures	2471.29	2472.38	2471.01	2471.83	11446.0
2017-01-20 06:00:00	ES	Futures	2471.83	2474.56	2470.74	2471.01	19654.0
2017-01-20 07:00:00	ES	Futures	2470.74	2472.92	2470.74	2472.1	11119.0
2017-01-20 08:00:00	ES	Futures	2472.1	2474.01	2471.29	2472.92	21032.0
2017-01-20 09:00:00	ES	Futures	2472.65	2479.74	2469.1	2477.56	312995.0
2017-01-20 10:00:00	ES	Futures	2477.29	2478.11	2474.29	2475.92	159675.0
2017-01-20 11:00:00	ES	Futures	2476.2	2477.56	2474.29	2475.92	103125.0
2017-01-20 12:00:00	ES	Futures	2475.92	2476.47	2465.56	2468.83	379676.0
2017-01-20 13:00:00	ES	Futures	2468.83	2472.38	2467.74	2469.65	96748.0
2017-01-20 14:00:00	ES	Futures	2469.92	2470.74	2466.1	2468.83	114601.0
2017-01-20 15:00:00	ES	Futures	2468.83	2473.2	2466.65	2472.65	319005.0
2017-01-20 16:00:00	ES	Futures	2472.65	2473.47	2471.01	2472.92	98251.0
2017-01-20 00:00:00	NQ	Futures	6041.57	6042.47	6040.68	6041.87	413.0
2017-01-20 01:00:00	NQ	Futures	6041.57	6043.66	6037.4	6037.99	746.0
2017-01-20 02:00:00	NQ	Futures	6037.99	6040.38	6035.61	6040.08	976.0
2017-01-20 03:00:00	NQ	Futures	6040.08	6045.45	6036.2	6042.77	2074.0
2017-01-20 04:00:00	NQ	Futures	6043.06	6043.96	6040.08	6041.27	1101.0
2017-01-20 05:00:00	NQ	Futures	6041.57	6046.05	6040.98	6044.56	1445.0
2017-01-20 06:00:00	NQ	Futures	6044.56	6048.73	6042.47	6042.77	2624.0
2017-01-20 07:00:00	NQ	Futures	6042.47	6047.54	6041.87	6046.35	1680.0
2017-01-20 08:00:00	NQ	Futures	6046.35	6048.43	6043.36	6044.85	2812.0
2017-01-20 09:00:00	NQ	Futures	6045.15	6065.44	6041.27	6057.98	39110.0
2017-01-20 10:00:00	NQ	Futures	6058.28	6059.77	6037.4	6040.38	28906.0
2017-01-20 11:00:00	NQ	Futures	6040.38	6046.94	6037.1	6045.45	14829.0
2017-01-20 12:00:00	NQ	Futures	6045.15	6049.33	6019.8	6028.45	50329.0
2017-01-20 13:00:00	NQ	Futures	6028.75	6036.8	6026.96	6029.34	13269.0
2017-01-20 14:00:00	NQ	Futures	6029.64	6032.92	6020.69	6028.75	15609.0
2017-01-20 15:00:00	NQ	Futures	6028.45	6037.99	6023.67	6034.41	27265.0
2017-01-20 16:00:00	NQ	Futures	6035.31	6039.78	6032.92	6039.19	6767.0
2017-01-20 00:00:00	YM	Futures	21347.1	21351.4	21346.0	21350.4	252.0
2017-01-20 01:00:00	YM	Futures	21349.3	21354.7	21342.8	21342.8	706.0
2017-01-20 02:00:00	YM	Futures	21343.9	21352.5	21335.2	21350.4	1045.0
2017-01-20 03:00:00	YM	Futures	21350.4	21362.3	21337.3	21349.3	3588.0
2017-01-20 04:00:00	YM	Futures	21349.3	21356.9	21343.9	21351.4	1172.0
2017-01-20 05:00:00	YM	Futures	21351.4	21362.3	21350.4	21358.0	1336.0
2017-01-20 06:00:00	YM	Futures	21358.0	21381.8	21353.6	21358.0	2873.0
2017-01-20 07:00:00	YM	Futures	21356.9	21379.7	21356.9	21377.5	2102.0
2017-01-20 08:00:00	YM	Futures	21377.5	21391.6	21367.7	21382.9	2971.0
2017-01-20 09:00:00	YM	Futures	21382.9	21455.6	21353.6	21431.7	27985.0
2017-01-20 10:00:00	YM	Futures	21431.7	21445.8	21413.3	21437.1	12484.0
2017-01-20 11:00:00	YM	Futures	21436.1	21453.4	21426.3	21439.3	9701.0
2017-01-20 12:00:00	YM	Futures	21440.4	21443.7	21359.0	21388.3	34946.0
2017-01-20 13:00:00	YM	Futures	21388.3	21422.0	21379.7	21393.8	8875.0
2017-01-20 14:00:00	YM	Futures	21393.8	21403.5	21369.9	21399.2	8155.0
2017-01-20 15:00:00	YM	Futures	21399.2	21431.7	21381.8	21428.5	17771.0

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

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