PREVIEW / futures_1hour / 2018-10-19

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-19.parquet
  size:    48 KB
  rows:    1,408

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
2018-10-19 00:00:00	ES	Futures	3022.44	3025.44	3022.17	3024.08	2547.0
2018-10-19 01:00:00	ES	Futures	3024.35	3029.24	3023.8	3028.7	11596.0
2018-10-19 02:00:00	ES	Futures	3028.7	3030.6	3024.62	3026.8	19414.0
2018-10-19 03:00:00	ES	Futures	3026.52	3027.61	3019.72	3022.17	28072.0
2018-10-19 04:00:00	ES	Futures	3021.9	3022.17	3015.37	3020.27	35404.0
2018-10-19 05:00:00	ES	Futures	3020.0	3023.53	3017.82	3018.64	20682.0
2018-10-19 06:00:00	ES	Futures	3018.36	3024.35	3017.28	3020.27	20457.0
2018-10-19 07:00:00	ES	Futures	3020.54	3028.7	3020.0	3027.07	32799.0
2018-10-19 08:00:00	ES	Futures	3027.07	3031.69	3023.53	3026.52	53745.0
2018-10-19 09:00:00	ES	Futures	3026.8	3041.21	3022.44	3037.4	246914.0
2018-10-19 10:00:00	ES	Futures	3037.4	3046.92	3034.96	3040.4	238122.0
2018-10-19 11:00:00	ES	Futures	3040.4	3043.66	3024.08	3032.78	204364.0
2018-10-19 12:00:00	ES	Futures	3032.78	3034.68	3010.75	3020.54	224654.0
2018-10-19 13:00:00	ES	Futures	3020.27	3028.43	3012.92	3018.91	145366.0
2018-10-19 14:00:00	ES	Futures	3018.91	3021.36	3005.31	3015.92	192791.0
2018-10-19 15:00:00	ES	Futures	3015.64	3022.99	3009.66	3012.65	309827.0
2018-10-19 16:00:00	ES	Futures	3012.65	3014.28	3007.48	3011.02	98866.0
2018-10-19 00:00:00	NQ	Futures	8411.96	8421.05	8409.61	8414.89	1669.0
2018-10-19 01:00:00	NQ	Futures	8415.48	8436.01	8414.6	8434.83	4332.0
2018-10-19 02:00:00	NQ	Futures	8435.13	8442.75	8423.1	8427.5	6403.0
2018-10-19 03:00:00	NQ	Futures	8427.21	8427.8	8398.76	8408.44	10026.0
2018-10-19 04:00:00	NQ	Futures	8408.14	8408.44	8371.77	8390.84	12073.0
2018-10-19 05:00:00	NQ	Futures	8391.72	8410.2	8387.9	8389.66	6732.0
2018-10-19 06:00:00	NQ	Futures	8389.66	8416.36	8385.85	8403.45	7189.0
2018-10-19 07:00:00	NQ	Futures	8403.16	8432.78	8401.69	8428.09	11303.0
2018-10-19 08:00:00	NQ	Futures	8428.38	8440.41	8409.61	8422.22	18810.0
2018-10-19 09:00:00	NQ	Futures	8422.52	8486.16	8411.96	8467.1	91951.0
2018-10-19 10:00:00	NQ	Futures	8466.81	8499.36	8448.62	8466.22	98257.0
2018-10-19 11:00:00	NQ	Futures	8465.93	8480.3	8394.94	8421.93	83244.0
2018-10-19 12:00:00	NQ	Futures	8421.93	8428.68	8331.3	8378.23	80507.0
2018-10-19 13:00:00	NQ	Futures	8377.93	8404.04	8345.67	8363.56	49444.0
2018-10-19 14:00:00	NQ	Futures	8363.27	8379.99	8321.62	8355.64	60046.0
2018-10-19 15:00:00	NQ	Futures	8355.35	8387.61	8341.56	8352.71	70545.0
2018-10-19 16:00:00	NQ	Futures	8352.71	8357.69	8328.36	8335.4	21115.0
2018-10-19 00:00:00	YM	Futures	27602.8	27635.4	27600.7	27625.7	744.0
2018-10-19 01:00:00	YM	Futures	27625.7	27683.2	27622.4	27676.7	2457.0
2018-10-19 02:00:00	YM	Futures	27680.0	27691.9	27632.2	27648.5	3185.0
2018-10-19 03:00:00	YM	Futures	27647.4	27675.6	27595.2	27612.6	6379.0
2018-10-19 04:00:00	YM	Futures	27612.6	27619.1	27561.6	27607.2	7094.0
2018-10-19 05:00:00	YM	Futures	27606.1	27652.8	27588.7	27595.2	5094.0
2018-10-19 06:00:00	YM	Futures	27594.2	27655.0	27582.2	27623.5	4290.0
2018-10-19 07:00:00	YM	Futures	27622.4	27705.0	27619.1	27686.5	7706.0
2018-10-19 08:00:00	YM	Futures	27688.7	27725.6	27649.6	27695.2	11861.0
2018-10-19 09:00:00	YM	Futures	27693.0	27778.9	27620.2	27741.9	31779.0
2018-10-19 10:00:00	YM	Futures	27743.0	27810.4	27716.9	27765.8	29782.0
2018-10-19 11:00:00	YM	Futures	27765.8	27791.9	27618.1	27727.8	27584.0
2018-10-19 12:00:00	YM	Futures	27727.8	27756.0	27557.2	27647.4	33538.0
2018-10-19 13:00:00	YM	Futures	27647.4	27724.5	27594.2	27667.0	22171.0
2018-10-19 14:00:00	YM	Futures	27665.9	27684.3	27530.1	27637.6	26991.0
2018-10-19 15:00:00	YM	Futures	27635.4	27711.5	27587.6	27632.2	28082.0

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

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