PREVIEW / futures_1hour / 2019-04-11

all futures 1-hour files

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

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-04-11 00:00:00	ES	Futures	3138.28	3139.36	3137.74	3138.28	2989.0
2019-04-11 01:00:00	ES	Futures	3138.55	3139.91	3137.74	3139.64	5260.0
2019-04-11 02:00:00	ES	Futures	3139.36	3139.91	3138.28	3139.09	5363.0
2019-04-11 03:00:00	ES	Futures	3139.36	3140.72	3133.94	3134.76	17576.0
2019-04-11 04:00:00	ES	Futures	3134.76	3139.09	3133.94	3137.74	13133.0
2019-04-11 05:00:00	ES	Futures	3138.01	3142.08	3137.47	3140.99	11043.0
2019-04-11 06:00:00	ES	Futures	3140.99	3143.7	3140.45	3143.7	10882.0
2019-04-11 07:00:00	ES	Futures	3143.7	3144.79	3141.8	3142.62	14058.0
2019-04-11 08:00:00	ES	Futures	3142.62	3143.16	3139.91	3140.18	20992.0
2019-04-11 09:00:00	ES	Futures	3140.45	3143.16	3135.57	3138.82	157095.0
2019-04-11 10:00:00	ES	Futures	3138.82	3142.08	3135.84	3139.91	138967.0
2019-04-11 11:00:00	ES	Futures	3140.18	3141.26	3128.79	3133.13	139037.0
2019-04-11 12:00:00	ES	Futures	3133.4	3135.03	3131.23	3134.48	61295.0
2019-04-11 13:00:00	ES	Futures	3134.48	3135.84	3130.15	3132.04	55442.0
2019-04-11 14:00:00	ES	Futures	3132.04	3133.4	3129.33	3131.5	66684.0
2019-04-11 15:00:00	ES	Futures	3131.5	3138.01	3130.69	3136.38	138646.0
2019-04-11 16:00:00	ES	Futures	3136.38	3137.2	3133.94	3136.38	49151.0
2019-04-11 18:00:00	ES	Futures	3136.11	3140.18	3134.76	3137.47	7728.0
2019-04-11 19:00:00	ES	Futures	3137.47	3139.36	3136.38	3139.09	3993.0
2019-04-11 20:00:00	ES	Futures	3139.09	3139.64	3135.57	3138.82	9347.0
2019-04-11 21:00:00	ES	Futures	3138.82	3140.18	3136.38	3138.55	9321.0
2019-04-11 22:00:00	ES	Futures	3138.55	3140.18	3138.28	3139.09	5947.0
2019-04-11 23:00:00	ES	Futures	3139.09	3139.09	3138.01	3139.09	2740.0
2019-04-11 00:00:00	NQ	Futures	8893.65	8899.18	8893.36	8896.27	1777.0
2019-04-11 01:00:00	NQ	Futures	8896.27	8900.06	8892.78	8898.6	2511.0
2019-04-11 02:00:00	NQ	Futures	8898.6	8901.81	8896.27	8899.18	2561.0
2019-04-11 03:00:00	NQ	Futures	8898.89	8902.68	8880.26	8882.88	6894.0
2019-04-11 04:00:00	NQ	Futures	8882.88	8895.4	8879.68	8891.61	5222.0
2019-04-11 05:00:00	NQ	Futures	8892.2	8902.39	8891.03	8900.06	4574.0
2019-04-11 06:00:00	NQ	Futures	8899.77	8907.63	8898.02	8907.34	4820.0
2019-04-11 07:00:00	NQ	Futures	8907.63	8914.03	8903.26	8907.34	4821.0
2019-04-11 08:00:00	NQ	Futures	8907.05	8907.63	8895.69	8897.15	8721.0
2019-04-11 09:00:00	NQ	Futures	8897.15	8907.63	8868.03	8874.15	60300.0
2019-04-11 10:00:00	NQ	Futures	8873.85	8891.91	8868.03	8889.29	51988.0
2019-04-11 11:00:00	NQ	Futures	8889.58	8894.24	8862.21	8873.56	45104.0
2019-04-11 12:00:00	NQ	Futures	8873.85	8884.04	8868.03	8882.3	22544.0
2019-04-11 13:00:00	NQ	Futures	8882.3	8885.79	8860.75	8863.08	24556.0
2019-04-11 14:00:00	NQ	Futures	8863.66	8867.16	8852.89	8859.3	26947.0
2019-04-11 15:00:00	NQ	Futures	8858.71	8872.69	8856.38	8870.94	34812.0
2019-04-11 16:00:00	NQ	Futures	8870.65	8874.44	8864.83	8874.44	9559.0
2019-04-11 18:00:00	NQ	Futures	8870.94	8879.39	8865.99	8872.4	2757.0
2019-04-11 19:00:00	NQ	Futures	8872.4	8875.31	8865.41	8875.02	2030.0
2019-04-11 20:00:00	NQ	Futures	8875.02	8876.18	8863.95	8875.31	4583.0
2019-04-11 21:00:00	NQ	Futures	8875.6	8881.42	8867.45	8873.56	4582.0
2019-04-11 22:00:00	NQ	Futures	8873.56	8879.39	8870.94	8874.73	3325.0
2019-04-11 23:00:00	NQ	Futures	8874.73	8875.89	8870.36	8872.69	1854.0
2019-04-11 00:00:00	YM	Futures	28450.1	28461.0	28442.5	28447.9	1038.0
2019-04-11 01:00:00	YM	Futures	28446.8	28463.2	28443.6	28459.9	1383.0
2019-04-11 02:00:00	YM	Futures	28458.8	28461.0	28442.5	28450.1	1754.0
2019-04-11 03:00:00	YM	Futures	28451.2	28463.2	28402.3	28408.8	3345.0

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

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