PREVIEW / futures_1hour / 2018-09-24

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-24.parquet
  size:    53 KB
  rows:    1,669

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
2018-09-24 00:00:00	ES	Futures	3185.64	3185.92	3184.83	3184.83	1414.0
2018-09-24 01:00:00	ES	Futures	3185.1	3185.92	3184.56	3185.64	4105.0
2018-09-24 02:00:00	ES	Futures	3185.64	3185.92	3181.84	3183.74	8955.0
2018-09-24 03:00:00	ES	Futures	3183.47	3186.19	3183.47	3184.56	16243.0
2018-09-24 04:00:00	ES	Futures	3184.28	3187.82	3184.28	3186.19	10011.0
2018-09-24 05:00:00	ES	Futures	3186.19	3187.55	3184.83	3185.37	7626.0
2018-09-24 06:00:00	ES	Futures	3185.64	3187.82	3185.64	3187.55	9437.0
2018-09-24 07:00:00	ES	Futures	3187.28	3188.09	3185.64	3186.19	9191.0
2018-09-24 08:00:00	ES	Futures	3186.19	3187.28	3185.1	3185.37	15823.0
2018-09-24 09:00:00	ES	Futures	3185.1	3186.73	3180.2	3184.83	182807.0
2018-09-24 10:00:00	ES	Futures	3184.56	3185.1	3174.49	3179.39	257705.0
2018-09-24 11:00:00	ES	Futures	3179.39	3183.47	3175.85	3179.12	126546.0
2018-09-24 12:00:00	ES	Futures	3179.39	3180.75	3176.12	3177.21	74014.0
2018-09-24 13:00:00	ES	Futures	3177.21	3181.84	3176.12	3181.02	72986.0
2018-09-24 14:00:00	ES	Futures	3181.02	3183.2	3179.93	3181.29	64250.0
2018-09-24 15:00:00	ES	Futures	3181.02	3184.01	3180.75	3181.84	153947.0
2018-09-24 16:00:00	ES	Futures	3182.11	3185.1	3181.84	3184.01	55631.0
2018-09-24 18:00:00	ES	Futures	3184.01	3184.56	3182.92	3183.47	2664.0
2018-09-24 19:00:00	ES	Futures	3183.47	3183.47	3182.65	3182.65	1005.0
2018-09-24 20:00:00	ES	Futures	3182.65	3183.2	3180.75	3181.56	4845.0
2018-09-24 21:00:00	ES	Futures	3181.56	3182.65	3181.02	3181.02	3012.0
2018-09-24 22:00:00	ES	Futures	3181.02	3182.38	3180.75	3182.11	3032.0
2018-09-24 23:00:00	ES	Futures	3182.11	3182.38	3181.56	3182.38	1284.0
2018-09-24 00:00:00	NQ	Futures	8825.82	8827.0	8823.18	8825.82	597.0
2018-09-24 01:00:00	NQ	Futures	8825.82	8828.76	8818.78	8822.01	2886.0
2018-09-24 02:00:00	NQ	Futures	8822.01	8824.65	8810.57	8816.73	2549.0
2018-09-24 03:00:00	NQ	Futures	8816.73	8826.41	8815.56	8819.66	5074.0
2018-09-24 04:00:00	NQ	Futures	8819.37	8830.81	8819.37	8825.82	3510.0
2018-09-24 05:00:00	NQ	Futures	8825.53	8829.64	8819.96	8821.72	2641.0
2018-09-24 06:00:00	NQ	Futures	8822.01	8831.1	8821.72	8827.58	3190.0
2018-09-24 07:00:00	NQ	Futures	8827.58	8828.17	8817.02	8817.9	3214.0
2018-09-24 08:00:00	NQ	Futures	8818.49	8824.06	8813.21	8814.97	5092.0
2018-09-24 09:00:00	NQ	Futures	8814.68	8842.54	8768.63	8833.16	87533.0
2018-09-24 10:00:00	NQ	Futures	8832.86	8853.69	8819.37	8840.78	91316.0
2018-09-24 11:00:00	NQ	Futures	8840.78	8878.62	8825.82	8870.11	52619.0
2018-09-24 12:00:00	NQ	Futures	8870.41	8876.27	8853.98	8859.26	27605.0
2018-09-24 13:00:00	NQ	Futures	8858.97	8888.3	8857.21	8885.37	24902.0
2018-09-24 14:00:00	NQ	Futures	8885.66	8889.77	8874.81	8879.21	17771.0
2018-09-24 15:00:00	NQ	Futures	8879.21	8897.98	8877.45	8892.4	30227.0
2018-09-24 16:00:00	NQ	Futures	8892.4	8909.71	8892.4	8906.19	10449.0
2018-09-24 18:00:00	NQ	Futures	8906.19	8907.95	8901.5	8902.08	1207.0
2018-09-24 19:00:00	NQ	Futures	8902.38	8904.14	8898.56	8899.44	931.0
2018-09-24 20:00:00	NQ	Futures	8899.44	8901.2	8889.47	8889.77	2746.0
2018-09-24 21:00:00	NQ	Futures	8889.77	8894.46	8885.66	8890.94	2044.0
2018-09-24 22:00:00	NQ	Futures	8890.65	8896.51	8888.3	8893.28	2145.0
2018-09-24 23:00:00	NQ	Futures	8893.58	8896.51	8892.4	8896.22	619.0
2018-09-24 00:00:00	YM	Futures	29009.9	29011.0	28993.6	29004.4	539.0
2018-09-24 01:00:00	YM	Futures	29003.4	29012.1	28994.7	29007.7	2161.0
2018-09-24 02:00:00	YM	Futures	29007.7	29014.2	28972.9	28988.1	2498.0
2018-09-24 03:00:00	YM	Futures	28989.2	29008.8	28987.1	28993.6	3149.0

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

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