PREVIEW / futures_1hour / 2019-11-05

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-05.parquet
  size:    59 KB
  rows:    1,874

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-05 00:00:00	ES	Futures	3347.58	3348.67	3346.22	3346.77	6958.0
2019-11-05 01:00:00	ES	Futures	3346.77	3349.48	3346.77	3347.85	6661.0
2019-11-05 02:00:00	ES	Futures	3347.58	3349.75	3345.14	3347.85	10355.0
2019-11-05 03:00:00	ES	Futures	3348.12	3348.94	3345.95	3348.67	16909.0
2019-11-05 04:00:00	ES	Futures	3348.4	3350.84	3347.85	3349.75	12325.0
2019-11-05 05:00:00	ES	Futures	3349.75	3351.93	3349.75	3351.11	12147.0
2019-11-05 06:00:00	ES	Futures	3350.84	3351.11	3345.14	3347.85	20665.0
2019-11-05 07:00:00	ES	Futures	3347.85	3350.3	3347.58	3348.94	13495.0
2019-11-05 08:00:00	ES	Futures	3348.67	3350.57	3347.85	3349.75	14836.0
2019-11-05 09:00:00	ES	Futures	3350.02	3351.11	3340.79	3342.69	148576.0
2019-11-05 10:00:00	ES	Futures	3342.96	3348.67	3335.36	3337.8	253895.0
2019-11-05 11:00:00	ES	Futures	3337.53	3342.42	3336.99	3338.62	123869.0
2019-11-05 12:00:00	ES	Futures	3338.62	3341.88	3335.63	3341.88	86249.0
2019-11-05 13:00:00	ES	Futures	3341.88	3343.23	3340.25	3342.15	66803.0
2019-11-05 14:00:00	ES	Futures	3341.88	3344.32	3341.06	3342.69	49289.0
2019-11-05 15:00:00	ES	Futures	3342.69	3343.23	3336.99	3338.62	135374.0
2019-11-05 16:00:00	ES	Futures	3338.89	3339.7	3336.71	3336.99	49527.0
2019-11-05 18:00:00	ES	Futures	3337.26	3338.89	3336.44	3338.07	6446.0
2019-11-05 19:00:00	ES	Futures	3337.8	3338.62	3334.27	3334.27	10757.0
2019-11-05 20:00:00	ES	Futures	3334.54	3335.9	3332.91	3335.36	10125.0
2019-11-05 21:00:00	ES	Futures	3335.36	3335.63	3334.0	3334.54	4557.0
2019-11-05 22:00:00	ES	Futures	3334.27	3336.71	3334.27	3335.9	4790.0
2019-11-05 23:00:00	ES	Futures	3335.9	3336.44	3335.63	3336.17	1811.0
2019-11-05 00:00:00	NQ	Futures	9571.72	9574.92	9567.95	9569.69	2583.0
2019-11-05 01:00:00	NQ	Futures	9569.69	9579.86	9569.11	9572.01	3531.0
2019-11-05 02:00:00	NQ	Futures	9571.72	9578.69	9562.43	9572.01	4129.0
2019-11-05 03:00:00	NQ	Futures	9572.01	9574.92	9564.75	9572.01	4861.0
2019-11-05 04:00:00	NQ	Futures	9572.01	9578.98	9571.14	9575.79	3592.0
2019-11-05 05:00:00	NQ	Futures	9576.08	9583.92	9575.5	9580.73	2919.0
2019-11-05 06:00:00	NQ	Futures	9580.73	9581.02	9561.84	9570.56	6461.0
2019-11-05 07:00:00	NQ	Futures	9570.56	9576.66	9567.95	9569.69	4882.0
2019-11-05 08:00:00	NQ	Futures	9569.11	9574.63	9565.91	9571.72	5819.0
2019-11-05 09:00:00	NQ	Futures	9572.01	9575.5	9537.73	9549.06	43036.0
2019-11-05 10:00:00	NQ	Futures	9549.64	9568.53	9520.3	9538.02	71387.0
2019-11-05 11:00:00	NQ	Futures	9537.73	9558.65	9537.73	9554.87	34147.0
2019-11-05 12:00:00	NQ	Futures	9554.87	9563.88	9548.48	9561.55	22801.0
2019-11-05 13:00:00	NQ	Futures	9560.97	9566.2	9556.62	9561.26	19705.0
2019-11-05 14:00:00	NQ	Futures	9560.97	9568.24	9557.2	9560.97	15707.0
2019-11-05 15:00:00	NQ	Futures	9560.97	9563.3	9542.09	9545.58	25899.0
2019-11-05 16:00:00	NQ	Futures	9545.58	9548.77	9538.02	9540.35	6890.0
2019-11-05 18:00:00	NQ	Futures	9537.44	9547.9	9537.44	9543.83	2124.0
2019-11-05 19:00:00	NQ	Futures	9544.12	9546.16	9533.96	9534.54	2830.0
2019-11-05 20:00:00	NQ	Futures	9534.25	9537.73	9529.02	9535.99	3597.0
2019-11-05 21:00:00	NQ	Futures	9535.7	9538.61	9532.21	9533.38	1931.0
2019-11-05 22:00:00	NQ	Futures	9533.67	9540.64	9533.09	9539.77	1584.0
2019-11-05 23:00:00	NQ	Futures	9539.77	9540.93	9538.02	9539.77	734.0
2019-11-05 00:00:00	YM	Futures	29856.8	29866.6	29842.6	29851.3	1085.0
2019-11-05 01:00:00	YM	Futures	29851.3	29869.8	29851.3	29860.0	901.0
2019-11-05 02:00:00	YM	Futures	29857.9	29879.6	29835.0	29864.4	2068.0
2019-11-05 03:00:00	YM	Futures	29863.3	29872.0	29844.8	29867.7	2758.0

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

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