PREVIEW / futures_1hour / 2019-11-04

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-04.parquet
  size:    60 KB
  rows:    1,900

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-11-04 00:00:00	ES	Futures	3335.63	3336.17	3335.09	3335.36	2496.0
2019-11-04 01:00:00	ES	Futures	3335.36	3336.17	3334.81	3335.9	4246.0
2019-11-04 02:00:00	ES	Futures	3335.63	3337.53	3334.27	3336.99	9018.0
2019-11-04 03:00:00	ES	Futures	3336.99	3341.6	3335.09	3339.16	26931.0
2019-11-04 04:00:00	ES	Futures	3339.43	3342.96	3339.16	3342.42	16870.0
2019-11-04 05:00:00	ES	Futures	3342.69	3346.49	3342.42	3344.59	20577.0
2019-11-04 06:00:00	ES	Futures	3344.59	3345.95	3342.96	3344.32	16041.0
2019-11-04 07:00:00	ES	Futures	3344.05	3344.86	3342.69	3342.96	14610.0
2019-11-04 08:00:00	ES	Futures	3343.23	3350.57	3342.96	3348.12	33013.0
2019-11-04 09:00:00	ES	Futures	3348.12	3349.75	3344.59	3345.68	191552.0
2019-11-04 10:00:00	ES	Futures	3345.41	3348.4	3342.15	3344.59	173498.0
2019-11-04 11:00:00	ES	Futures	3344.86	3347.85	3342.42	3342.69	103255.0
2019-11-04 12:00:00	ES	Futures	3342.96	3344.86	3341.33	3344.32	89872.0
2019-11-04 13:00:00	ES	Futures	3344.59	3345.95	3342.96	3345.41	57617.0
2019-11-04 14:00:00	ES	Futures	3345.14	3345.95	3342.96	3343.23	70785.0
2019-11-04 15:00:00	ES	Futures	3343.23	3344.59	3338.34	3342.69	184152.0
2019-11-04 16:00:00	ES	Futures	3342.69	3343.78	3340.25	3341.88	65093.0
2019-11-04 18:00:00	ES	Futures	3342.96	3352.74	3339.97	3349.75	20815.0
2019-11-04 19:00:00	ES	Futures	3349.48	3349.75	3344.05	3344.86	13202.0
2019-11-04 20:00:00	ES	Futures	3344.86	3345.95	3343.23	3345.68	10943.0
2019-11-04 21:00:00	ES	Futures	3345.68	3348.4	3344.59	3348.12	8581.0
2019-11-04 22:00:00	ES	Futures	3348.12	3350.02	3347.04	3349.75	8343.0
2019-11-04 23:00:00	ES	Futures	3349.75	3350.02	3347.31	3347.58	6298.0
2019-11-04 00:00:00	NQ	Futures	9515.95	9516.82	9511.88	9513.04	1096.0
2019-11-04 01:00:00	NQ	Futures	9513.04	9515.66	9510.72	9513.91	1418.0
2019-11-04 02:00:00	NQ	Futures	9513.91	9520.89	9508.39	9517.98	2615.0
2019-11-04 03:00:00	NQ	Futures	9517.69	9533.38	9510.72	9518.85	8750.0
2019-11-04 04:00:00	NQ	Futures	9519.72	9532.51	9519.43	9531.63	4985.0
2019-11-04 05:00:00	NQ	Futures	9531.63	9549.35	9529.6	9541.22	6898.0
2019-11-04 06:00:00	NQ	Futures	9541.22	9545.0	9534.25	9538.9	4095.0
2019-11-04 07:00:00	NQ	Futures	9538.9	9540.35	9533.38	9535.41	3605.0
2019-11-04 08:00:00	NQ	Futures	9535.41	9563.3	9533.96	9551.97	13557.0
2019-11-04 09:00:00	NQ	Futures	9552.55	9567.36	9543.83	9550.52	58745.0
2019-11-04 10:00:00	NQ	Futures	9551.1	9555.45	9532.51	9538.61	53499.0
2019-11-04 11:00:00	NQ	Futures	9538.31	9549.06	9529.6	9531.05	33648.0
2019-11-04 12:00:00	NQ	Futures	9531.63	9546.74	9529.6	9546.45	25961.0
2019-11-04 13:00:00	NQ	Futures	9546.45	9556.03	9542.67	9553.42	18433.0
2019-11-04 14:00:00	NQ	Futures	9553.42	9559.52	9546.16	9554.29	22637.0
2019-11-04 15:00:00	NQ	Futures	9554.29	9554.58	9536.86	9543.83	39818.0
2019-11-04 16:00:00	NQ	Futures	9543.83	9551.97	9535.12	9549.06	9509.0
2019-11-04 18:00:00	NQ	Futures	9553.13	9583.92	9540.35	9574.34	8053.0
2019-11-04 19:00:00	NQ	Futures	9574.05	9574.63	9558.65	9560.68	5066.0
2019-11-04 20:00:00	NQ	Futures	9560.39	9562.14	9551.97	9561.26	4178.0
2019-11-04 21:00:00	NQ	Futures	9561.26	9570.85	9558.36	9570.27	3138.0
2019-11-04 22:00:00	NQ	Futures	9570.56	9575.79	9566.78	9575.21	2500.0
2019-11-04 23:00:00	NQ	Futures	9575.21	9575.5	9570.27	9572.01	2728.0
2019-11-04 00:00:00	YM	Futures	29734.9	29738.1	29730.5	29730.5	576.0
2019-11-04 01:00:00	YM	Futures	29730.5	29740.3	29722.9	29731.6	975.0
2019-11-04 02:00:00	YM	Futures	29731.6	29747.9	29718.5	29744.7	2234.0
2019-11-04 03:00:00	YM	Futures	29744.7	29786.0	29726.2	29766.4	5266.0

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

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