PREVIEW / futures_1hour / 2017-03-20

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-20.parquet
  size:    52 KB
  rows:    1,612

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-20 00:00:00	ES	Futures	2588.85	2589.12	2588.3	2588.85	2084.0
2017-03-20 01:00:00	ES	Futures	2589.12	2589.67	2588.85	2589.67	2580.0
2017-03-20 02:00:00	ES	Futures	2589.4	2590.76	2589.4	2589.67	1808.0
2017-03-20 03:00:00	ES	Futures	2589.67	2591.03	2589.4	2590.49	5763.0
2017-03-20 04:00:00	ES	Futures	2590.76	2592.95	2590.21	2590.49	12110.0
2017-03-20 05:00:00	ES	Futures	2590.49	2591.03	2589.4	2589.94	5910.0
2017-03-20 06:00:00	ES	Futures	2589.67	2591.58	2589.67	2591.58	6223.0
2017-03-20 07:00:00	ES	Futures	2591.58	2592.95	2591.31	2592.13	8295.0
2017-03-20 08:00:00	ES	Futures	2592.13	2592.4	2589.67	2589.94	17946.0
2017-03-20 09:00:00	ES	Futures	2589.94	2592.4	2588.58	2590.76	128564.0
2017-03-20 10:00:00	ES	Futures	2590.49	2595.95	2589.94	2594.86	156052.0
2017-03-20 11:00:00	ES	Futures	2594.86	2595.4	2591.85	2594.04	79929.0
2017-03-20 12:00:00	ES	Futures	2593.77	2594.31	2591.03	2593.22	87403.0
2017-03-20 13:00:00	ES	Futures	2593.22	2593.22	2586.39	2588.58	114063.0
2017-03-20 14:00:00	ES	Futures	2588.3	2589.94	2584.48	2586.39	145785.0
2017-03-20 15:00:00	ES	Futures	2586.66	2592.13	2586.12	2589.4	197103.0
2017-03-20 16:00:00	ES	Futures	2589.12	2590.21	2588.03	2588.85	65249.0
2017-03-20 18:00:00	ES	Futures	2588.3	2590.21	2587.76	2588.85	4240.0
2017-03-20 19:00:00	ES	Futures	2588.85	2588.85	2587.21	2588.58	4265.0
2017-03-20 20:00:00	ES	Futures	2588.58	2589.94	2587.76	2589.67	6171.0
2017-03-20 21:00:00	ES	Futures	2589.4	2594.86	2589.4	2594.31	12675.0
2017-03-20 22:00:00	ES	Futures	2594.59	2595.68	2593.49	2594.86	9385.0
2017-03-20 23:00:00	ES	Futures	2594.59	2595.13	2593.49	2593.77	2823.0
2017-03-20 00:00:00	NQ	Futures	6438.34	6440.42	6437.14	6440.13	826.0
2017-03-20 01:00:00	NQ	Futures	6439.83	6441.62	6439.53	6441.02	560.0
2017-03-20 02:00:00	NQ	Futures	6441.02	6444.3	6440.72	6443.7	756.0
2017-03-20 03:00:00	NQ	Futures	6443.41	6444.0	6442.21	6442.81	1466.0
2017-03-20 04:00:00	NQ	Futures	6442.51	6449.67	6441.62	6445.19	2352.0
2017-03-20 05:00:00	NQ	Futures	6444.9	6446.98	6443.7	6444.3	938.0
2017-03-20 06:00:00	NQ	Futures	6444.3	6447.58	6442.51	6447.58	1206.0
2017-03-20 07:00:00	NQ	Futures	6447.28	6449.97	6446.39	6449.07	1532.0
2017-03-20 08:00:00	NQ	Futures	6449.07	6449.07	6445.19	6446.69	2669.0
2017-03-20 09:00:00	NQ	Futures	6446.69	6457.42	6446.09	6454.74	20621.0
2017-03-20 10:00:00	NQ	Futures	6454.74	6473.22	6454.14	6468.15	25026.0
2017-03-20 11:00:00	NQ	Futures	6468.15	6470.54	6461.29	6464.28	12280.0
2017-03-20 12:00:00	NQ	Futures	6464.28	6465.47	6457.12	6463.68	11721.0
2017-03-20 13:00:00	NQ	Futures	6463.38	6463.38	6445.19	6450.56	14654.0
2017-03-20 14:00:00	NQ	Futures	6450.26	6453.54	6441.62	6446.98	15370.0
2017-03-20 15:00:00	NQ	Futures	6446.98	6460.7	6446.09	6458.61	21233.0
2017-03-20 16:00:00	NQ	Futures	6458.31	6463.08	6458.01	6460.1	4393.0
2017-03-20 18:00:00	NQ	Futures	6458.61	6462.79	6457.72	6460.4	682.0
2017-03-20 19:00:00	NQ	Futures	6460.1	6460.7	6455.93	6459.21	793.0
2017-03-20 20:00:00	NQ	Futures	6459.51	6463.68	6457.72	6462.19	1171.0
2017-03-20 21:00:00	NQ	Futures	6462.19	6477.39	6462.19	6476.2	2854.0
2017-03-20 22:00:00	NQ	Futures	6476.2	6481.27	6474.41	6476.8	2712.0
2017-03-20 23:00:00	NQ	Futures	6476.5	6477.39	6473.22	6473.82	577.0
2017-03-20 00:00:00	YM	Futures	22644.4	22647.6	22643.3	22647.6	499.0
2017-03-20 01:00:00	YM	Futures	22646.6	22653.1	22646.6	22649.8	475.0
2017-03-20 02:00:00	YM	Futures	22649.8	22662.9	22649.8	22657.4	844.0
2017-03-20 03:00:00	YM	Futures	22657.4	22662.9	22654.2	22656.3	1202.0

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

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