PREVIEW / futures_1hour / 2019-03-14

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-14.parquet
  size:    53 KB
  rows:    1,737

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-14 00:00:00	ES	Futures	3053.15	3054.51	3052.07	3053.42	3233.0
2019-03-14 01:00:00	ES	Futures	3053.7	3055.86	3053.15	3055.59	6114.0
2019-03-14 02:00:00	ES	Futures	3055.32	3055.86	3053.15	3054.24	4589.0
2019-03-14 03:00:00	ES	Futures	3054.24	3056.95	3053.15	3056.95	5785.0
2019-03-14 04:00:00	ES	Futures	3056.68	3062.91	3056.68	3062.64	18205.0
2019-03-14 05:00:00	ES	Futures	3062.37	3063.46	3060.74	3062.64	14178.0
2019-03-14 06:00:00	ES	Futures	3062.91	3062.91	3048.55	3050.98	43828.0
2019-03-14 07:00:00	ES	Futures	3051.26	3055.59	3050.44	3055.32	15088.0
2019-03-14 08:00:00	ES	Futures	3055.59	3059.93	3055.05	3058.03	28338.0
2019-03-14 09:00:00	ES	Futures	3058.03	3058.58	3049.9	3053.42	162978.0
2019-03-14 10:00:00	ES	Futures	3053.42	3054.24	3045.56	3051.8	178761.0
2019-03-14 11:00:00	ES	Futures	3051.8	3058.85	3049.36	3056.41	121651.0
2019-03-14 12:00:00	ES	Futures	3056.68	3058.03	3052.61	3053.97	79558.0
2019-03-14 13:00:00	ES	Futures	3053.97	3054.24	3048.55	3049.63	66233.0
2019-03-14 14:00:00	ES	Futures	3049.63	3052.07	3048.0	3050.71	83073.0
2019-03-14 15:00:00	ES	Futures	3050.71	3054.78	3049.9	3051.53	141814.0
2019-03-14 16:00:00	ES	Futures	3051.53	3051.8	3048.82	3049.9	43416.0
2019-03-14 18:00:00	ES	Futures	3050.98	3052.88	3049.9	3051.53	5245.0
2019-03-14 19:00:00	ES	Futures	3051.53	3052.34	3049.9	3052.07	3048.0
2019-03-14 20:00:00	ES	Futures	3051.8	3054.24	3051.8	3053.97	6619.0
2019-03-14 21:00:00	ES	Futures	3053.97	3055.59	3052.88	3055.32	6618.0
2019-03-14 22:00:00	ES	Futures	3055.05	3060.2	3055.05	3059.39	10588.0
2019-03-14 23:00:00	ES	Futures	3059.12	3060.2	3055.86	3057.49	8160.0
2019-03-14 00:00:00	NQ	Futures	8480.21	8486.91	8476.13	8483.41	1708.0
2019-03-14 01:00:00	NQ	Futures	8483.41	8493.31	8480.5	8491.57	2337.0
2019-03-14 02:00:00	NQ	Futures	8491.86	8492.44	8484.29	8489.24	1914.0
2019-03-14 03:00:00	NQ	Futures	8488.95	8503.79	8486.62	8502.92	3061.0
2019-03-14 04:00:00	NQ	Futures	8502.92	8521.26	8501.76	8520.1	6098.0
2019-03-14 05:00:00	NQ	Futures	8520.1	8523.3	8511.95	8518.06	4765.0
2019-03-14 06:00:00	NQ	Futures	8518.35	8518.35	8478.46	8486.03	13665.0
2019-03-14 07:00:00	NQ	Futures	8486.33	8501.47	8484.29	8500.59	6080.0
2019-03-14 08:00:00	NQ	Futures	8500.88	8512.82	8495.06	8502.63	10077.0
2019-03-14 09:00:00	NQ	Futures	8502.05	8504.38	8468.27	8489.53	52651.0
2019-03-14 10:00:00	NQ	Futures	8489.53	8490.98	8465.65	8477.59	57981.0
2019-03-14 11:00:00	NQ	Futures	8477.88	8494.19	8470.6	8490.4	38365.0
2019-03-14 12:00:00	NQ	Futures	8490.4	8498.26	8479.92	8485.45	29305.0
2019-03-14 13:00:00	NQ	Futures	8485.74	8488.36	8473.22	8476.43	18740.0
2019-03-14 14:00:00	NQ	Futures	8476.43	8483.7	8470.31	8475.26	22081.0
2019-03-14 15:00:00	NQ	Futures	8475.26	8483.41	8466.82	8468.86	33672.0
2019-03-14 16:00:00	NQ	Futures	8469.15	8472.06	8461.87	8467.11	9061.0
2019-03-14 18:00:00	NQ	Futures	8469.73	8475.84	8467.4	8471.77	1617.0
2019-03-14 19:00:00	NQ	Futures	8471.19	8474.68	8466.53	8473.22	1528.0
2019-03-14 20:00:00	NQ	Futures	8473.22	8484.29	8473.22	8482.83	3396.0
2019-03-14 21:00:00	NQ	Futures	8482.83	8489.53	8480.21	8488.07	2849.0
2019-03-14 22:00:00	NQ	Futures	8488.07	8506.42	8488.07	8504.96	5389.0
2019-03-14 23:00:00	NQ	Futures	8504.67	8507.0	8491.28	8497.39	3383.0
2019-03-14 00:00:00	YM	Futures	27980.2	27993.3	27970.4	27981.3	732.0
2019-03-14 01:00:00	YM	Futures	27982.4	27999.8	27980.2	27996.6	1133.0
2019-03-14 02:00:00	YM	Futures	27996.6	27996.6	27967.2	27978.1	1154.0
2019-03-14 03:00:00	YM	Futures	27977.0	28004.2	27965.0	28000.9	1675.0

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

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