PREVIEW / futures_1hour / 2019-03-28

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-28.parquet
  size:    56 KB
  rows:    1,765

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
2019-03-28 00:00:00	ES	Futures	3042.31	3043.94	3039.06	3039.6	4935.0
2019-03-28 01:00:00	ES	Futures	3039.6	3040.95	3036.89	3037.97	5503.0
2019-03-28 02:00:00	ES	Futures	3037.97	3044.21	3034.72	3042.31	9638.0
2019-03-28 03:00:00	ES	Futures	3042.31	3046.92	3039.06	3040.41	14175.0
2019-03-28 04:00:00	ES	Futures	3040.68	3050.44	3039.87	3049.63	35517.0
2019-03-28 05:00:00	ES	Futures	3049.63	3052.07	3046.65	3050.17	15048.0
2019-03-28 06:00:00	ES	Futures	3050.17	3052.34	3046.11	3048.82	15805.0
2019-03-28 07:00:00	ES	Futures	3049.09	3049.09	3042.31	3044.21	18863.0
2019-03-28 08:00:00	ES	Futures	3044.48	3051.26	3043.12	3048.0	35623.0
2019-03-28 09:00:00	ES	Futures	3048.27	3058.58	3046.11	3056.95	175972.0
2019-03-28 10:00:00	ES	Futures	3056.95	3062.64	3053.42	3053.7	176420.0
2019-03-28 11:00:00	ES	Futures	3053.97	3054.78	3040.14	3045.29	183355.0
2019-03-28 12:00:00	ES	Futures	3045.29	3050.17	3039.06	3049.09	101891.0
2019-03-28 13:00:00	ES	Futures	3049.36	3053.7	3049.09	3053.42	70341.0
2019-03-28 14:00:00	ES	Futures	3053.42	3054.51	3049.36	3052.61	59566.0
2019-03-28 15:00:00	ES	Futures	3052.61	3059.39	3051.26	3058.03	133833.0
2019-03-28 16:00:00	ES	Futures	3057.76	3061.02	3055.86	3060.47	40302.0
2019-03-28 18:00:00	ES	Futures	3058.58	3062.1	3058.3	3059.66	4666.0
2019-03-28 19:00:00	ES	Futures	3059.93	3067.79	3059.39	3065.62	11962.0
2019-03-28 20:00:00	ES	Futures	3065.62	3067.52	3063.46	3064.27	11289.0
2019-03-28 21:00:00	ES	Futures	3064.0	3065.35	3060.47	3061.83	9722.0
2019-03-28 22:00:00	ES	Futures	3061.83	3066.98	3060.74	3066.44	7417.0
2019-03-28 23:00:00	ES	Futures	3066.44	3067.25	3065.35	3066.17	4578.0
2019-03-28 00:00:00	NQ	Futures	8526.8	8530.29	8516.9	8519.52	2521.0
2019-03-28 01:00:00	NQ	Futures	8519.81	8523.59	8511.95	8514.28	2979.0
2019-03-28 02:00:00	NQ	Futures	8513.99	8530.58	8503.21	8526.8	5371.0
2019-03-28 03:00:00	NQ	Futures	8526.5	8540.77	8515.73	8519.81	6605.0
2019-03-28 04:00:00	NQ	Futures	8519.81	8552.71	8517.48	8548.92	12633.0
2019-03-28 05:00:00	NQ	Futures	8548.63	8556.2	8541.35	8550.67	7273.0
2019-03-28 06:00:00	NQ	Futures	8550.96	8554.75	8539.61	8548.34	7848.0
2019-03-28 07:00:00	NQ	Futures	8548.05	8548.05	8525.63	8533.49	9859.0
2019-03-28 08:00:00	NQ	Futures	8533.49	8553.0	8528.83	8542.52	14671.0
2019-03-28 09:00:00	NQ	Futures	8542.23	8566.39	8527.96	8563.77	67830.0
2019-03-28 10:00:00	NQ	Futures	8564.06	8586.19	8547.47	8549.51	73276.0
2019-03-28 11:00:00	NQ	Futures	8549.8	8552.13	8503.5	8525.92	67654.0
2019-03-28 12:00:00	NQ	Futures	8525.92	8548.63	8508.45	8545.72	41779.0
2019-03-28 13:00:00	NQ	Futures	8545.43	8557.37	8541.94	8551.25	26801.0
2019-03-28 14:00:00	NQ	Futures	8551.25	8553.58	8532.62	8542.23	20695.0
2019-03-28 15:00:00	NQ	Futures	8542.52	8563.48	8539.9	8556.2	35784.0
2019-03-28 16:00:00	NQ	Futures	8555.91	8568.72	8552.13	8565.81	8802.0
2019-03-28 18:00:00	NQ	Futures	8560.28	8568.43	8560.28	8565.23	1391.0
2019-03-28 19:00:00	NQ	Futures	8564.65	8594.64	8564.06	8585.32	5683.0
2019-03-28 20:00:00	NQ	Futures	8585.32	8591.14	8577.17	8579.5	5011.0
2019-03-28 21:00:00	NQ	Futures	8579.5	8582.41	8566.39	8570.76	5253.0
2019-03-28 22:00:00	NQ	Futures	8571.34	8588.81	8568.14	8588.23	3576.0
2019-03-28 23:00:00	NQ	Futures	8588.23	8592.89	8584.44	8586.48	2157.0
2019-03-28 00:00:00	YM	Futures	27861.7	27872.6	27830.1	27833.4	1783.0
2019-03-28 01:00:00	YM	Futures	27833.4	27851.9	27809.5	27816.0	1762.0
2019-03-28 02:00:00	YM	Futures	27817.1	27874.7	27781.2	27859.5	3022.0
2019-03-28 03:00:00	YM	Futures	27859.5	27898.7	27833.4	27849.7	3696.0

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

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