PREVIEW / futures_1hour / 2019-04-03

all futures 1-hour files

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

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-03 00:00:00	ES	Futures	3122.01	3123.1	3121.47	3122.56	2538.0
2019-04-03 01:00:00	ES	Futures	3122.56	3123.64	3121.47	3122.83	5626.0
2019-04-03 02:00:00	ES	Futures	3122.56	3125.27	3121.74	3124.18	12334.0
2019-04-03 03:00:00	ES	Futures	3123.91	3126.89	3122.83	3125.54	21250.0
2019-04-03 04:00:00	ES	Futures	3125.81	3127.44	3124.45	3125.27	16919.0
2019-04-03 05:00:00	ES	Futures	3125.27	3126.35	3123.91	3124.18	10279.0
2019-04-03 06:00:00	ES	Futures	3124.18	3125.0	3122.83	3123.64	10259.0
2019-04-03 07:00:00	ES	Futures	3123.37	3127.16	3123.1	3126.35	10315.0
2019-04-03 08:00:00	ES	Futures	3126.35	3129.88	3125.0	3127.44	34238.0
2019-04-03 09:00:00	ES	Futures	3127.44	3129.33	3121.74	3122.28	162025.0
2019-04-03 10:00:00	ES	Futures	3122.01	3128.79	3117.68	3128.25	175713.0
2019-04-03 11:00:00	ES	Futures	3128.25	3133.13	3127.98	3131.5	150801.0
2019-04-03 12:00:00	ES	Futures	3131.5	3133.13	3127.44	3128.79	70031.0
2019-04-03 13:00:00	ES	Futures	3128.79	3130.42	3118.76	3119.57	91014.0
2019-04-03 14:00:00	ES	Futures	3119.3	3122.28	3115.78	3117.68	111462.0
2019-04-03 15:00:00	ES	Futures	3117.68	3122.01	3111.17	3119.3	202120.0
2019-04-03 16:00:00	ES	Futures	3119.57	3123.37	3118.76	3123.1	49265.0
2019-04-03 18:00:00	ES	Futures	3123.91	3124.72	3121.74	3122.28	4585.0
2019-04-03 19:00:00	ES	Futures	3122.28	3123.64	3120.93	3121.47	3946.0
2019-04-03 20:00:00	ES	Futures	3121.47	3123.37	3119.57	3122.56	6044.0
2019-04-03 21:00:00	ES	Futures	3122.83	3126.35	3122.01	3125.81	6955.0
2019-04-03 22:00:00	ES	Futures	3125.54	3126.08	3122.83	3122.83	4766.0
2019-04-03 23:00:00	ES	Futures	3122.83	3123.1	3118.76	3120.66	6105.0
2019-04-03 00:00:00	NQ	Futures	8804.27	8809.8	8802.52	8806.89	1767.0
2019-04-03 01:00:00	NQ	Futures	8806.89	8810.38	8802.52	8808.05	3781.0
2019-04-03 02:00:00	NQ	Futures	8808.34	8813.0	8805.72	8810.38	4817.0
2019-04-03 03:00:00	NQ	Futures	8810.38	8819.7	8806.31	8815.04	8400.0
2019-04-03 04:00:00	NQ	Futures	8815.04	8824.07	8812.13	8814.46	8362.0
2019-04-03 05:00:00	NQ	Futures	8814.75	8817.37	8808.05	8808.93	4033.0
2019-04-03 06:00:00	NQ	Futures	8808.34	8809.22	8803.1	8804.27	4660.0
2019-04-03 07:00:00	NQ	Futures	8804.27	8815.33	8802.81	8812.42	5084.0
2019-04-03 08:00:00	NQ	Futures	8812.42	8822.61	8806.6	8812.71	11044.0
2019-04-03 09:00:00	NQ	Futures	8812.71	8819.7	8797.86	8812.42	61234.0
2019-04-03 10:00:00	NQ	Futures	8811.84	8844.16	8796.7	8843.28	76843.0
2019-04-03 11:00:00	NQ	Futures	8843.57	8869.49	8843.57	8863.66	61695.0
2019-04-03 12:00:00	NQ	Futures	8863.66	8870.07	8846.78	8849.98	35835.0
2019-04-03 13:00:00	NQ	Futures	8849.98	8854.35	8806.89	8810.09	45067.0
2019-04-03 14:00:00	NQ	Futures	8810.09	8823.19	8801.36	8809.51	43743.0
2019-04-03 15:00:00	NQ	Futures	8809.51	8820.86	8787.67	8815.33	58724.0
2019-04-03 16:00:00	NQ	Futures	8815.33	8832.22	8814.17	8829.31	11028.0
2019-04-03 18:00:00	NQ	Futures	8829.31	8833.67	8823.19	8824.94	2173.0
2019-04-03 19:00:00	NQ	Futures	8825.52	8831.05	8820.86	8825.23	2096.0
2019-04-03 20:00:00	NQ	Futures	8825.23	8835.13	8818.83	8831.93	4192.0
2019-04-03 21:00:00	NQ	Futures	8831.93	8844.16	8829.31	8842.12	4781.0
2019-04-03 22:00:00	NQ	Futures	8841.83	8842.41	8831.64	8832.51	3259.0
2019-04-03 23:00:00	NQ	Futures	8832.22	8832.8	8814.17	8821.74	4608.0
2019-04-03 00:00:00	YM	Futures	28538.2	28549.1	28533.9	28543.6	795.0
2019-04-03 01:00:00	YM	Futures	28544.7	28555.6	28534.9	28543.6	1414.0
2019-04-03 02:00:00	YM	Futures	28542.6	28567.6	28534.9	28554.5	2847.0
2019-04-03 03:00:00	YM	Futures	28554.5	28591.5	28549.1	28575.2	4391.0

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

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