PREVIEW / futures_1hour / 2019-04-10

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-10.parquet
  size:    53 KB
  rows:    1,726

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-10 00:00:00	ES	Futures	3127.16	3129.06	3126.62	3127.71	3464.0
2019-04-10 01:00:00	ES	Futures	3127.98	3129.6	3127.98	3129.06	5237.0
2019-04-10 02:00:00	ES	Futures	3129.06	3132.59	3128.52	3129.88	8177.0
2019-04-10 03:00:00	ES	Futures	3129.88	3132.32	3129.6	3131.23	9655.0
2019-04-10 04:00:00	ES	Futures	3131.23	3131.77	3129.33	3129.6	6509.0
2019-04-10 05:00:00	ES	Futures	3129.6	3131.77	3129.6	3131.5	4986.0
2019-04-10 06:00:00	ES	Futures	3131.5	3135.3	3130.96	3133.67	10944.0
2019-04-10 07:00:00	ES	Futures	3133.67	3135.03	3131.23	3131.5	11296.0
2019-04-10 08:00:00	ES	Futures	3131.5	3135.3	3127.16	3132.32	37514.0
2019-04-10 09:00:00	ES	Futures	3132.32	3134.21	3127.44	3131.5	162926.0
2019-04-10 10:00:00	ES	Futures	3131.5	3132.59	3126.62	3130.42	159702.0
2019-04-10 11:00:00	ES	Futures	3130.69	3133.94	3129.88	3132.59	84497.0
2019-04-10 12:00:00	ES	Futures	3132.32	3133.67	3130.69	3130.96	44104.0
2019-04-10 13:00:00	ES	Futures	3130.69	3134.76	3130.15	3134.21	44906.0
2019-04-10 14:00:00	ES	Futures	3133.94	3135.3	3128.79	3133.94	106766.0
2019-04-10 15:00:00	ES	Futures	3134.21	3138.55	3133.13	3137.74	157467.0
2019-04-10 16:00:00	ES	Futures	3137.47	3140.45	3137.2	3139.64	54974.0
2019-04-10 18:00:00	ES	Futures	3139.09	3141.53	3138.82	3140.18	4658.0
2019-04-10 19:00:00	ES	Futures	3140.18	3143.43	3139.64	3142.08	5534.0
2019-04-10 20:00:00	ES	Futures	3141.8	3142.89	3140.72	3141.26	6313.0
2019-04-10 21:00:00	ES	Futures	3141.53	3144.79	3141.53	3142.08	11896.0
2019-04-10 22:00:00	ES	Futures	3142.08	3142.08	3139.36	3140.18	6534.0
2019-04-10 23:00:00	ES	Futures	3139.91	3140.18	3136.11	3138.28	8146.0
2019-04-10 00:00:00	NQ	Futures	8844.74	8848.81	8843.28	8847.07	1654.0
2019-04-10 01:00:00	NQ	Futures	8847.07	8852.89	8846.49	8848.81	4096.0
2019-04-10 02:00:00	NQ	Futures	8848.81	8858.42	8846.78	8852.6	3968.0
2019-04-10 03:00:00	NQ	Futures	8852.31	8860.17	8851.44	8857.26	4356.0
2019-04-10 04:00:00	NQ	Futures	8857.26	8857.84	8848.23	8849.11	3826.0
2019-04-10 05:00:00	NQ	Futures	8849.4	8858.13	8848.23	8857.55	2981.0
2019-04-10 06:00:00	NQ	Futures	8857.26	8865.7	8854.93	8861.04	3765.0
2019-04-10 07:00:00	NQ	Futures	8861.33	8865.7	8857.26	8859.01	4257.0
2019-04-10 08:00:00	NQ	Futures	8858.71	8865.99	8842.41	8859.59	14823.0
2019-04-10 09:00:00	NQ	Futures	8859.3	8869.49	8846.49	8861.92	56621.0
2019-04-10 10:00:00	NQ	Futures	8861.63	8883.17	8849.98	8872.98	53724.0
2019-04-10 11:00:00	NQ	Futures	8873.27	8886.66	8872.98	8878.22	30922.0
2019-04-10 12:00:00	NQ	Futures	8878.22	8881.42	8868.9	8870.07	19683.0
2019-04-10 13:00:00	NQ	Futures	8870.36	8879.97	8864.25	8878.51	16701.0
2019-04-10 14:00:00	NQ	Futures	8878.51	8882.3	8854.64	8875.02	37760.0
2019-04-10 15:00:00	NQ	Futures	8875.02	8895.69	8873.56	8893.94	44344.0
2019-04-10 16:00:00	NQ	Futures	8893.94	8904.72	8893.07	8902.68	10642.0
2019-04-10 18:00:00	NQ	Futures	8902.39	8907.34	8899.48	8903.26	1832.0
2019-04-10 19:00:00	NQ	Futures	8903.84	8918.98	8901.81	8911.7	3683.0
2019-04-10 20:00:00	NQ	Futures	8911.7	8913.74	8907.34	8909.67	2867.0
2019-04-10 21:00:00	NQ	Futures	8909.96	8922.19	8909.38	8911.7	4827.0
2019-04-10 22:00:00	NQ	Futures	8911.41	8912.29	8902.1	8902.97	4277.0
2019-04-10 23:00:00	NQ	Futures	8902.68	8903.26	8888.7	8893.65	5362.0
2019-04-10 00:00:00	YM	Futures	28456.6	28471.9	28453.4	28459.9	811.0
2019-04-10 01:00:00	YM	Futures	28461.0	28479.5	28461.0	28471.9	1106.0
2019-04-10 02:00:00	YM	Futures	28473.0	28509.9	28467.5	28477.3	2102.0
2019-04-10 03:00:00	YM	Futures	28477.3	28503.4	28476.2	28489.3	1726.0

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

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