PREVIEW / futures_1hour / 2019-11-27

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-27.parquet
  size:    55 KB
  rows:    1,805

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-27 00:00:00	ES	Futures	3418.2	3418.75	3416.3	3416.85	4349.0
2019-11-27 01:00:00	ES	Futures	3416.57	3417.66	3416.3	3416.85	3537.0
2019-11-27 02:00:00	ES	Futures	3417.12	3420.38	3417.12	3419.83	7990.0
2019-11-27 03:00:00	ES	Futures	3419.56	3420.11	3417.39	3419.83	21417.0
2019-11-27 04:00:00	ES	Futures	3419.83	3422.55	3419.56	3422.01	18201.0
2019-11-27 05:00:00	ES	Futures	3421.74	3422.82	3421.19	3421.46	9709.0
2019-11-27 06:00:00	ES	Futures	3421.46	3422.01	3419.02	3419.29	10013.0
2019-11-27 07:00:00	ES	Futures	3419.02	3420.38	3418.48	3419.83	11202.0
2019-11-27 08:00:00	ES	Futures	3419.83	3421.74	3417.93	3418.2	22212.0
2019-11-27 09:00:00	ES	Futures	3417.93	3418.75	3414.13	3417.12	122111.0
2019-11-27 10:00:00	ES	Futures	3417.12	3418.75	3414.13	3417.93	128538.0
2019-11-27 11:00:00	ES	Futures	3417.93	3420.38	3415.76	3419.56	81711.0
2019-11-27 12:00:00	ES	Futures	3419.56	3421.46	3419.56	3420.65	58529.0
2019-11-27 13:00:00	ES	Futures	3420.92	3426.08	3420.38	3424.72	88849.0
2019-11-27 14:00:00	ES	Futures	3424.45	3426.08	3423.64	3424.99	46538.0
2019-11-27 15:00:00	ES	Futures	3425.27	3426.62	3423.91	3426.08	144122.0
2019-11-27 16:00:00	ES	Futures	3426.08	3427.98	3424.99	3427.44	60376.0
2019-11-27 18:00:00	ES	Futures	3427.71	3427.98	3414.67	3416.57	22326.0
2019-11-27 19:00:00	ES	Futures	3416.57	3418.48	3414.13	3416.03	12676.0
2019-11-27 20:00:00	ES	Futures	3416.3	3418.48	3412.77	3418.48	13964.0
2019-11-27 21:00:00	ES	Futures	3418.48	3418.75	3416.3	3417.93	5550.0
2019-11-27 22:00:00	ES	Futures	3417.66	3418.75	3417.12	3417.66	3544.0
2019-11-27 23:00:00	ES	Futures	3417.93	3417.93	3416.57	3416.85	2336.0
2019-11-27 00:00:00	NQ	Futures	9775.36	9777.39	9771.0	9772.45	1766.0
2019-11-27 01:00:00	NQ	Futures	9772.16	9775.07	9771.0	9773.9	1048.0
2019-11-27 02:00:00	NQ	Futures	9774.19	9783.78	9774.19	9782.62	2916.0
2019-11-27 03:00:00	NQ	Futures	9782.62	9782.91	9773.9	9781.75	5649.0
2019-11-27 04:00:00	NQ	Futures	9781.75	9793.08	9780.0	9791.62	7156.0
2019-11-27 05:00:00	NQ	Futures	9791.62	9795.69	9787.85	9787.85	4541.0
2019-11-27 06:00:00	NQ	Futures	9787.85	9789.3	9780.29	9780.88	2975.0
2019-11-27 07:00:00	NQ	Futures	9781.46	9785.23	9777.39	9781.46	3811.0
2019-11-27 08:00:00	NQ	Futures	9782.04	9788.14	9775.36	9775.36	7616.0
2019-11-27 09:00:00	NQ	Futures	9775.07	9781.17	9763.45	9778.84	40264.0
2019-11-27 10:00:00	NQ	Futures	9778.84	9795.11	9772.16	9792.79	35422.0
2019-11-27 11:00:00	NQ	Futures	9793.08	9802.95	9789.88	9802.08	24494.0
2019-11-27 12:00:00	NQ	Futures	9802.37	9809.05	9800.92	9802.95	18004.0
2019-11-27 13:00:00	NQ	Futures	9802.95	9814.57	9802.08	9807.6	19195.0
2019-11-27 14:00:00	NQ	Futures	9807.6	9811.67	9805.28	9808.18	11006.0
2019-11-27 15:00:00	NQ	Futures	9808.47	9818.06	9804.99	9817.77	26889.0
2019-11-27 16:00:00	NQ	Futures	9817.48	9828.81	9814.57	9826.19	9655.0
2019-11-27 18:00:00	NQ	Futures	9826.48	9828.23	9784.65	9790.17	9097.0
2019-11-27 19:00:00	NQ	Futures	9790.17	9794.82	9781.17	9787.56	5331.0
2019-11-27 20:00:00	NQ	Futures	9787.85	9796.56	9776.52	9795.98	6903.0
2019-11-27 21:00:00	NQ	Futures	9795.98	9798.89	9788.72	9793.95	3582.0
2019-11-27 22:00:00	NQ	Futures	9793.66	9796.56	9791.33	9793.37	1254.0
2019-11-27 23:00:00	NQ	Futures	9793.66	9794.53	9791.62	9793.95	1127.0
2019-11-27 00:00:00	YM	Futures	30620.8	30628.4	30605.6	30607.7	917.0
2019-11-27 01:00:00	YM	Futures	30606.6	30615.4	30603.4	30607.7	761.0
2019-11-27 02:00:00	YM	Futures	30608.8	30645.8	30608.8	30633.9	1841.0
2019-11-27 03:00:00	YM	Futures	30634.9	30634.9	30608.8	30632.8	3359.0

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

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