PREVIEW / futures_1hour / 2019-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-29.parquet
  size:    56 KB
  rows:    1,798

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-01-29 00:00:00	ES	Futures	2861.69	2867.39	2860.33	2865.76	9478.0
2019-01-29 01:00:00	ES	Futures	2865.76	2867.66	2863.86	2863.86	6465.0
2019-01-29 02:00:00	ES	Futures	2864.13	2864.95	2861.14	2862.5	6899.0
2019-01-29 03:00:00	ES	Futures	2862.5	2865.49	2859.51	2865.22	18310.0
2019-01-29 04:00:00	ES	Futures	2864.95	2869.02	2864.67	2867.66	16610.0
2019-01-29 05:00:00	ES	Futures	2867.39	2870.92	2866.03	2868.48	13124.0
2019-01-29 06:00:00	ES	Futures	2868.48	2870.65	2865.22	2870.65	20666.0
2019-01-29 07:00:00	ES	Futures	2870.38	2874.18	2868.2	2872.82	43224.0
2019-01-29 08:00:00	ES	Futures	2872.82	2875.54	2871.74	2874.99	27100.0
2019-01-29 09:00:00	ES	Futures	2875.27	2877.98	2867.93	2874.99	133431.0
2019-01-29 10:00:00	ES	Futures	2874.99	2878.8	2856.25	2858.97	260833.0
2019-01-29 11:00:00	ES	Futures	2858.97	2867.39	2856.8	2866.03	152831.0
2019-01-29 12:00:00	ES	Futures	2866.3	2872.55	2864.4	2867.39	87535.0
2019-01-29 13:00:00	ES	Futures	2867.39	2872.55	2864.95	2871.46	77623.0
2019-01-29 14:00:00	ES	Futures	2871.46	2871.46	2861.69	2862.23	82927.0
2019-01-29 15:00:00	ES	Futures	2862.23	2868.48	2860.87	2866.58	140373.0
2019-01-29 16:00:00	ES	Futures	2866.58	2877.17	2863.86	2875.81	62337.0
2019-01-29 18:00:00	ES	Futures	2877.17	2879.88	2873.09	2873.09	9706.0
2019-01-29 19:00:00	ES	Futures	2873.09	2873.64	2869.29	2871.46	12390.0
2019-01-29 20:00:00	ES	Futures	2871.74	2873.36	2865.22	2870.38	16409.0
2019-01-29 21:00:00	ES	Futures	2870.65	2871.74	2868.48	2870.38	5455.0
2019-01-29 22:00:00	ES	Futures	2870.38	2875.27	2870.11	2873.64	6405.0
2019-01-29 23:00:00	ES	Futures	2873.64	2874.72	2871.19	2872.01	4224.0
2019-01-29 00:00:00	NQ	Futures	7801.75	7821.03	7797.36	7815.77	5349.0
2019-01-29 01:00:00	NQ	Futures	7816.06	7821.91	7809.34	7809.93	3214.0
2019-01-29 02:00:00	NQ	Futures	7810.22	7813.73	7797.36	7802.33	3619.0
2019-01-29 03:00:00	NQ	Futures	7802.92	7809.64	7790.35	7805.55	8415.0
2019-01-29 04:00:00	NQ	Futures	7805.55	7820.74	7804.96	7816.94	5737.0
2019-01-29 05:00:00	NQ	Futures	7816.94	7828.92	7811.39	7818.99	5231.0
2019-01-29 06:00:00	NQ	Futures	7818.69	7830.38	7809.05	7830.38	6374.0
2019-01-29 07:00:00	NQ	Futures	7830.38	7847.91	7825.71	7844.99	10108.0
2019-01-29 08:00:00	NQ	Futures	7845.28	7855.22	7843.82	7850.54	9172.0
2019-01-29 09:00:00	NQ	Futures	7851.13	7854.93	7804.08	7816.65	54953.0
2019-01-29 10:00:00	NQ	Futures	7817.53	7835.64	7733.38	7744.48	92747.0
2019-01-29 11:00:00	NQ	Futures	7744.77	7768.15	7736.3	7759.38	54783.0
2019-01-29 12:00:00	NQ	Futures	7759.67	7785.97	7753.54	7773.99	37180.0
2019-01-29 13:00:00	NQ	Futures	7773.99	7783.63	7761.72	7780.42	26363.0
2019-01-29 14:00:00	NQ	Futures	7780.71	7781.0	7745.65	7747.69	28116.0
2019-01-29 15:00:00	NQ	Futures	7747.98	7767.56	7743.6	7758.21	42759.0
2019-01-29 16:00:00	NQ	Futures	7758.21	7814.31	7745.65	7808.76	19504.0
2019-01-29 18:00:00	NQ	Futures	7819.28	7832.43	7806.42	7806.42	4905.0
2019-01-29 19:00:00	NQ	Futures	7806.42	7809.93	7795.61	7805.55	6614.0
2019-01-29 20:00:00	NQ	Futures	7805.55	7809.05	7781.29	7802.04	8652.0
2019-01-29 21:00:00	NQ	Futures	7802.04	7807.59	7795.9	7804.67	3697.0
2019-01-29 22:00:00	NQ	Futures	7804.96	7818.99	7804.38	7816.06	3688.0
2019-01-29 23:00:00	NQ	Futures	7815.77	7820.74	7811.1	7812.85	2410.0
2019-01-29 00:00:00	YM	Futures	26489.1	26537.9	26476.0	26527.1	2596.0
2019-01-29 01:00:00	YM	Futures	26528.2	26548.8	26509.7	26513.0	1978.0
2019-01-29 02:00:00	YM	Futures	26513.0	26520.6	26485.8	26498.8	2218.0
2019-01-29 03:00:00	YM	Futures	26499.9	26526.0	26466.3	26522.7	5222.0

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

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