PREVIEW / futures_1hour / 2019-11-06

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-06.parquet
  size:    58 KB
  rows:    1,882

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-06 00:00:00	ES	Futures	3336.17	3338.62	3335.9	3338.34	4778.0
2019-11-06 01:00:00	ES	Futures	3338.34	3338.89	3336.44	3337.26	4186.0
2019-11-06 02:00:00	ES	Futures	3337.26	3338.07	3334.81	3337.26	6190.0
2019-11-06 03:00:00	ES	Futures	3337.53	3341.88	3336.99	3340.52	13478.0
2019-11-06 04:00:00	ES	Futures	3340.52	3340.79	3333.46	3335.09	13294.0
2019-11-06 05:00:00	ES	Futures	3334.81	3338.07	3334.54	3337.8	11427.0
2019-11-06 06:00:00	ES	Futures	3337.53	3338.89	3336.71	3337.8	9465.0
2019-11-06 07:00:00	ES	Futures	3337.8	3341.6	3337.8	3340.52	15087.0
2019-11-06 08:00:00	ES	Futures	3340.52	3343.51	3339.43	3341.88	20718.0
2019-11-06 09:00:00	ES	Futures	3341.6	3341.88	3332.64	3338.34	125666.0
2019-11-06 10:00:00	ES	Futures	3338.34	3340.79	3335.63	3336.44	140276.0
2019-11-06 11:00:00	ES	Futures	3336.17	3343.23	3328.02	3331.28	213458.0
2019-11-06 12:00:00	ES	Futures	3331.28	3335.36	3331.01	3332.64	96039.0
2019-11-06 13:00:00	ES	Futures	3332.91	3340.25	3330.74	3339.7	90257.0
2019-11-06 14:00:00	ES	Futures	3339.7	3340.25	3336.71	3338.62	56000.0
2019-11-06 15:00:00	ES	Futures	3338.62	3340.52	3336.71	3339.97	121961.0
2019-11-06 16:00:00	ES	Futures	3339.97	3344.32	3339.16	3342.96	63561.0
2019-11-06 18:00:00	ES	Futures	3343.51	3344.05	3339.97	3339.97	5654.0
2019-11-06 19:00:00	ES	Futures	3339.97	3341.88	3339.43	3339.97	7092.0
2019-11-06 20:00:00	ES	Futures	3340.25	3340.25	3335.9	3336.71	12681.0
2019-11-06 21:00:00	ES	Futures	3336.71	3339.16	3336.17	3337.26	7448.0
2019-11-06 22:00:00	ES	Futures	3337.26	3338.62	3336.17	3337.8	4445.0
2019-11-06 23:00:00	ES	Futures	3338.07	3338.62	3337.53	3338.34	1928.0
2019-11-06 00:00:00	NQ	Futures	9540.06	9550.23	9539.19	9549.93	2303.0
2019-11-06 01:00:00	NQ	Futures	9549.93	9551.68	9542.96	9545.0	1922.0
2019-11-06 02:00:00	NQ	Futures	9545.0	9547.61	9538.02	9544.71	2614.0
2019-11-06 03:00:00	NQ	Futures	9545.0	9560.97	9542.38	9556.03	5731.0
2019-11-06 04:00:00	NQ	Futures	9556.62	9556.62	9531.92	9536.28	5095.0
2019-11-06 05:00:00	NQ	Futures	9536.28	9545.0	9535.12	9543.54	3174.0
2019-11-06 06:00:00	NQ	Futures	9543.25	9546.16	9537.73	9544.12	2894.0
2019-11-06 07:00:00	NQ	Futures	9544.12	9553.13	9542.38	9548.77	4661.0
2019-11-06 08:00:00	NQ	Futures	9548.77	9557.78	9547.03	9551.1	8397.0
2019-11-06 09:00:00	NQ	Futures	9551.1	9551.68	9515.37	9527.28	49775.0
2019-11-06 10:00:00	NQ	Futures	9527.57	9533.09	9503.46	9507.23	47495.0
2019-11-06 11:00:00	NQ	Futures	9507.23	9535.99	9482.83	9494.74	61709.0
2019-11-06 12:00:00	NQ	Futures	9495.61	9508.1	9493.0	9503.75	29118.0
2019-11-06 13:00:00	NQ	Futures	9503.75	9526.11	9498.81	9523.5	24748.0
2019-11-06 14:00:00	NQ	Futures	9523.79	9526.11	9514.79	9523.21	13605.0
2019-11-06 15:00:00	NQ	Futures	9522.92	9531.05	9514.79	9530.18	26776.0
2019-11-06 16:00:00	NQ	Futures	9529.89	9545.0	9528.15	9543.25	10032.0
2019-11-06 18:00:00	NQ	Futures	9544.12	9547.03	9531.05	9531.63	2300.0
2019-11-06 19:00:00	NQ	Futures	9531.34	9538.31	9530.18	9532.8	2334.0
2019-11-06 20:00:00	NQ	Futures	9532.8	9534.54	9516.53	9518.27	4921.0
2019-11-06 21:00:00	NQ	Futures	9518.27	9526.7	9516.53	9519.72	3519.0
2019-11-06 22:00:00	NQ	Futures	9520.01	9525.82	9516.82	9524.37	2123.0
2019-11-06 23:00:00	NQ	Futures	9523.79	9525.53	9522.34	9523.79	801.0
2019-11-06 00:00:00	YM	Futures	29830.6	29851.3	29829.6	29849.2	1346.0
2019-11-06 01:00:00	YM	Futures	29850.2	29855.7	29832.8	29840.4	967.0
2019-11-06 02:00:00	YM	Futures	29841.5	29847.0	29819.8	29840.4	1978.0
2019-11-06 03:00:00	YM	Futures	29841.5	29886.2	29831.7	29870.9	3636.0

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

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