PREVIEW / futures_1hour / 2019-11-07

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-07.parquet
  size:    62 KB
  rows:    1,891

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-07 00:00:00	ES	Futures	3338.34	3339.7	3337.26	3339.43	4514.0
2019-11-07 01:00:00	ES	Futures	3339.7	3341.88	3339.16	3341.06	6404.0
2019-11-07 02:00:00	ES	Futures	3340.79	3360.08	3339.97	3354.1	63722.0
2019-11-07 03:00:00	ES	Futures	3353.83	3357.09	3352.2	3355.73	26869.0
2019-11-07 04:00:00	ES	Futures	3355.73	3358.45	3354.64	3356.82	18592.0
2019-11-07 05:00:00	ES	Futures	3356.82	3358.17	3355.46	3356.82	14788.0
2019-11-07 06:00:00	ES	Futures	3357.09	3357.36	3354.1	3354.37	13054.0
2019-11-07 07:00:00	ES	Futures	3354.1	3354.64	3352.47	3354.1	14280.0
2019-11-07 08:00:00	ES	Futures	3354.1	3356.0	3351.11	3353.28	26502.0
2019-11-07 09:00:00	ES	Futures	3353.28	3362.25	3353.01	3360.35	185472.0
2019-11-07 10:00:00	ES	Futures	3360.35	3364.42	3357.09	3361.98	181594.0
2019-11-07 11:00:00	ES	Futures	3362.25	3364.96	3357.36	3363.88	146580.0
2019-11-07 12:00:00	ES	Futures	3364.15	3364.69	3358.45	3360.89	104672.0
2019-11-07 13:00:00	ES	Futures	3360.89	3361.16	3356.0	3357.36	65138.0
2019-11-07 14:00:00	ES	Futures	3357.09	3359.8	3348.12	3353.01	132213.0
2019-11-07 15:00:00	ES	Futures	3353.28	3354.91	3345.14	3351.38	214997.0
2019-11-07 16:00:00	ES	Futures	3351.65	3354.1	3350.02	3352.74	54864.0
2019-11-07 18:00:00	ES	Futures	3353.28	3354.37	3351.38	3353.83	9173.0
2019-11-07 19:00:00	ES	Futures	3354.1	3357.9	3349.48	3350.02	20237.0
2019-11-07 20:00:00	ES	Futures	3350.02	3350.57	3345.95	3347.04	15670.0
2019-11-07 21:00:00	ES	Futures	3347.31	3347.31	3343.51	3345.95	11792.0
2019-11-07 22:00:00	ES	Futures	3345.95	3347.85	3345.41	3347.04	5564.0
2019-11-07 23:00:00	ES	Futures	3347.04	3347.04	3344.59	3344.86	4726.0
2019-11-07 00:00:00	NQ	Futures	9524.08	9530.47	9521.18	9530.18	2317.0
2019-11-07 01:00:00	NQ	Futures	9530.47	9538.9	9529.6	9535.12	2415.0
2019-11-07 02:00:00	NQ	Futures	9535.12	9602.22	9532.51	9580.73	20198.0
2019-11-07 03:00:00	NQ	Futures	9580.44	9590.31	9574.05	9585.67	9541.0
2019-11-07 04:00:00	NQ	Futures	9585.08	9596.7	9583.05	9592.93	7447.0
2019-11-07 05:00:00	NQ	Futures	9592.93	9597.28	9586.25	9590.02	4928.0
2019-11-07 06:00:00	NQ	Futures	9589.73	9590.02	9579.56	9580.15	4793.0
2019-11-07 07:00:00	NQ	Futures	9580.44	9585.96	9574.63	9583.34	5099.0
2019-11-07 08:00:00	NQ	Futures	9583.05	9585.67	9568.82	9574.05	10152.0
2019-11-07 09:00:00	NQ	Futures	9574.34	9599.03	9567.65	9590.6	48999.0
2019-11-07 10:00:00	NQ	Futures	9590.6	9613.26	9582.47	9606.87	50112.0
2019-11-07 11:00:00	NQ	Futures	9606.58	9623.72	9592.64	9617.62	38376.0
2019-11-07 12:00:00	NQ	Futures	9617.62	9619.94	9596.99	9605.71	28421.0
2019-11-07 13:00:00	NQ	Futures	9606.0	9606.58	9591.77	9594.67	16652.0
2019-11-07 14:00:00	NQ	Futures	9594.96	9601.06	9555.16	9568.53	35762.0
2019-11-07 15:00:00	NQ	Futures	9568.53	9574.92	9532.8	9560.1	54267.0
2019-11-07 16:00:00	NQ	Futures	9560.1	9568.24	9557.2	9564.46	8581.0
2019-11-07 18:00:00	NQ	Futures	9563.01	9572.3	9560.68	9571.43	4125.0
2019-11-07 19:00:00	NQ	Futures	9571.43	9584.21	9554.0	9555.16	7996.0
2019-11-07 20:00:00	NQ	Futures	9554.87	9556.33	9535.7	9540.35	6563.0
2019-11-07 21:00:00	NQ	Futures	9540.93	9541.51	9526.4	9536.57	4839.0
2019-11-07 22:00:00	NQ	Futures	9536.57	9542.67	9534.83	9539.48	2300.0
2019-11-07 23:00:00	NQ	Futures	9539.77	9540.35	9530.18	9530.47	2352.0
2019-11-07 00:00:00	YM	Futures	29833.9	29842.6	29825.2	29839.4	1116.0
2019-11-07 01:00:00	YM	Futures	29841.5	29860.0	29840.4	29850.2	1131.0
2019-11-07 02:00:00	YM	Futures	29850.2	30036.3	29844.8	29986.3	12396.0
2019-11-07 03:00:00	YM	Futures	29985.2	30017.8	29975.4	30008.1	6681.0

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

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