PREVIEW / futures_1hour / 2017-11-13

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-13.parquet
  size:    53 KB
  rows:    1,637

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-11-13 00:00:00	ES	Futures	2827.5	2828.05	2823.12	2823.4	8543.0
2017-11-13 01:00:00	ES	Futures	2823.4	2823.67	2821.76	2823.4	7835.0
2017-11-13 02:00:00	ES	Futures	2823.4	2825.04	2823.12	2823.4	10673.0
2017-11-13 03:00:00	ES	Futures	2823.4	2825.86	2822.58	2822.85	25081.0
2017-11-13 04:00:00	ES	Futures	2823.12	2824.22	2819.29	2821.76	24380.0
2017-11-13 05:00:00	ES	Futures	2821.48	2822.03	2819.29	2819.84	13709.0
2017-11-13 06:00:00	ES	Futures	2819.57	2820.39	2817.65	2818.47	19675.0
2017-11-13 07:00:00	ES	Futures	2818.47	2819.02	2813.55	2815.74	47414.0
2017-11-13 08:00:00	ES	Futures	2816.01	2816.83	2813.55	2813.82	37219.0
2017-11-13 09:00:00	ES	Futures	2813.82	2820.94	2812.46	2820.66	163065.0
2017-11-13 10:00:00	ES	Futures	2820.66	2825.59	2820.39	2823.4	212580.0
2017-11-13 11:00:00	ES	Futures	2823.4	2826.13	2822.58	2825.59	96839.0
2017-11-13 12:00:00	ES	Futures	2825.59	2826.68	2824.49	2825.59	46453.0
2017-11-13 13:00:00	ES	Futures	2825.59	2826.68	2823.67	2826.41	41436.0
2017-11-13 14:00:00	ES	Futures	2826.13	2827.5	2825.86	2826.68	44072.0
2017-11-13 15:00:00	ES	Futures	2826.41	2829.14	2823.95	2826.41	148299.0
2017-11-13 16:00:00	ES	Futures	2826.41	2826.68	2823.67	2824.22	62591.0
2017-11-13 18:00:00	ES	Futures	2823.4	2824.49	2822.03	2822.58	5952.0
2017-11-13 19:00:00	ES	Futures	2822.58	2825.04	2821.48	2824.77	7202.0
2017-11-13 20:00:00	ES	Futures	2824.77	2825.59	2824.49	2825.04	6313.0
2017-11-13 21:00:00	ES	Futures	2825.04	2825.04	2821.76	2823.12	6756.0
2017-11-13 22:00:00	ES	Futures	2823.12	2823.12	2822.3	2822.85	2843.0
2017-11-13 23:00:00	ES	Futures	2822.85	2823.12	2822.03	2822.03	2879.0
2017-11-13 00:00:00	NQ	Futures	7520.77	7522.85	7508.58	7509.77	1950.0
2017-11-13 01:00:00	NQ	Futures	7510.06	7511.85	7505.9	7510.95	1612.0
2017-11-13 02:00:00	NQ	Futures	7510.66	7514.52	7509.47	7511.85	1883.0
2017-11-13 03:00:00	NQ	Futures	7511.55	7518.09	7507.68	7508.28	3076.0
2017-11-13 04:00:00	NQ	Futures	7508.28	7513.33	7502.03	7508.28	4199.0
2017-11-13 05:00:00	NQ	Futures	7508.58	7509.77	7500.25	7501.44	2397.0
2017-11-13 06:00:00	NQ	Futures	7501.73	7505.01	7493.7	7498.46	3215.0
2017-11-13 07:00:00	NQ	Futures	7498.46	7499.65	7480.02	7483.89	6084.0
2017-11-13 08:00:00	NQ	Futures	7484.19	7487.76	7472.89	7474.97	9776.0
2017-11-13 09:00:00	NQ	Futures	7475.26	7500.25	7472.29	7499.06	40893.0
2017-11-13 10:00:00	NQ	Futures	7499.06	7515.71	7499.06	7510.95	48658.0
2017-11-13 11:00:00	NQ	Futures	7510.66	7519.28	7506.79	7514.82	24892.0
2017-11-13 12:00:00	NQ	Futures	7515.12	7516.61	7510.66	7513.93	12414.0
2017-11-13 13:00:00	NQ	Futures	7513.93	7515.71	7507.98	7515.42	10821.0
2017-11-13 14:00:00	NQ	Futures	7515.42	7518.99	7513.93	7516.9	10372.0
2017-11-13 15:00:00	NQ	Futures	7517.2	7524.64	7505.9	7514.52	31116.0
2017-11-13 16:00:00	NQ	Futures	7514.52	7514.82	7507.98	7509.47	6088.0
2017-11-13 18:00:00	NQ	Futures	7507.68	7510.95	7503.52	7504.71	1341.0
2017-11-13 19:00:00	NQ	Futures	7505.01	7512.44	7500.84	7510.66	2051.0
2017-11-13 20:00:00	NQ	Futures	7511.25	7514.52	7510.66	7513.04	1224.0
2017-11-13 21:00:00	NQ	Futures	7512.74	7513.04	7502.63	7507.39	1594.0
2017-11-13 22:00:00	NQ	Futures	7507.09	7508.28	7504.71	7506.49	828.0
2017-11-13 23:00:00	NQ	Futures	7506.79	7507.39	7505.01	7506.2	567.0
2017-11-13 00:00:00	YM	Futures	25479.0	25481.2	25442.0	25445.3	1420.0
2017-11-13 01:00:00	YM	Futures	25445.3	25446.4	25429.0	25446.4	1723.0
2017-11-13 02:00:00	YM	Futures	25445.3	25457.3	25444.2	25445.3	1907.0
2017-11-13 03:00:00	YM	Futures	25444.2	25459.4	25432.2	25436.6	2361.0

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

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