PREVIEW / futures_1hour / 2021-06-17

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-17.parquet
  size:    65 KB
  rows:    1,963

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
2021-06-17 00:00:00	ES	Futures	4729.17	4731.99	4727.48	4731.43	3668.0
2021-06-17 01:00:00	ES	Futures	4731.14	4733.4	4729.74	4730.02	6746.0
2021-06-17 02:00:00	ES	Futures	4729.74	4731.14	4721.57	4726.36	18225.0
2021-06-17 03:00:00	ES	Futures	4726.08	4731.99	4723.54	4724.67	25455.0
2021-06-17 04:00:00	ES	Futures	4724.39	4731.99	4720.73	4723.26	20178.0
2021-06-17 05:00:00	ES	Futures	4722.98	4731.14	4722.7	4730.3	16297.0
2021-06-17 06:00:00	ES	Futures	4730.3	4732.27	4725.51	4729.74	19114.0
2021-06-17 07:00:00	ES	Futures	4729.45	4738.18	4728.05	4728.33	27968.0
2021-06-17 08:00:00	ES	Futures	4728.33	4732.83	4722.7	4730.02	40893.0
2021-06-17 09:00:00	ES	Futures	4730.02	4754.8	4729.74	4742.41	211896.0
2021-06-17 10:00:00	ES	Futures	4742.69	4755.08	4734.24	4742.97	226726.0
2021-06-17 11:00:00	ES	Futures	4742.97	4751.7	4734.81	4736.49	177504.0
2021-06-17 12:00:00	ES	Futures	4736.21	4737.9	4714.25	4734.52	237674.0
2021-06-17 13:00:00	ES	Futures	4734.24	4751.14	4733.68	4746.63	144842.0
2021-06-17 14:00:00	ES	Futures	4746.63	4748.6	4740.16	4742.41	98414.0
2021-06-17 15:00:00	ES	Futures	4742.41	4756.21	4739.87	4744.66	199739.0
2021-06-17 16:00:00	ES	Futures	4744.94	4748.88	4743.82	4748.04	41589.0
2021-06-17 18:00:00	ES	Futures	4748.6	4751.98	4746.63	4751.98	4827.0
2021-06-17 19:00:00	ES	Futures	4751.7	4751.98	4746.91	4747.76	4295.0
2021-06-17 20:00:00	ES	Futures	4748.04	4750.86	4744.1	4749.17	9107.0
2021-06-17 21:00:00	ES	Futures	4749.45	4753.11	4747.48	4751.42	7187.0
2021-06-17 22:00:00	ES	Futures	4751.14	4752.54	4750.01	4750.86	4305.0
2021-06-17 23:00:00	ES	Futures	4750.57	4752.26	4750.01	4750.01	3221.0
2021-06-17 00:00:00	NQ	Futures	16110.04	16122.5	16101.93	16119.02	2080.0
2021-06-17 01:00:00	NQ	Futures	16117.87	16134.38	16114.68	16117.87	3137.0
2021-06-17 02:00:00	NQ	Futures	16119.31	16122.21	16084.84	16106.28	7885.0
2021-06-17 03:00:00	NQ	Futures	16106.86	16120.76	16086.58	16092.95	8398.0
2021-06-17 04:00:00	NQ	Futures	16092.95	16118.15	16068.62	16083.97	9070.0
2021-06-17 05:00:00	NQ	Futures	16084.55	16116.42	16080.21	16113.23	5843.0
2021-06-17 06:00:00	NQ	Futures	16114.39	16125.98	16085.71	16109.46	6151.0
2021-06-17 07:00:00	NQ	Futures	16109.46	16144.81	16107.44	16108.89	10218.0
2021-06-17 08:00:00	NQ	Futures	16108.6	16134.38	16088.03	16120.18	12835.0
2021-06-17 09:00:00	NQ	Futures	16120.76	16260.97	16111.2	16250.83	78768.0
2021-06-17 10:00:00	NQ	Futures	16251.12	16371.05	16239.82	16341.79	103689.0
2021-06-17 11:00:00	NQ	Futures	16342.08	16444.05	16336.0	16386.11	84953.0
2021-06-17 12:00:00	NQ	Futures	16386.11	16399.15	16291.67	16344.69	82992.0
2021-06-17 13:00:00	NQ	Futures	16344.98	16439.99	16344.11	16415.37	54185.0
2021-06-17 14:00:00	NQ	Futures	16415.66	16432.46	16397.7	16412.18	36333.0
2021-06-17 15:00:00	NQ	Futures	16411.89	16452.74	16394.8	16403.2	68873.0
2021-06-17 16:00:00	NQ	Futures	16402.91	16434.78	16398.57	16427.24	12789.0
2021-06-17 18:00:00	NQ	Futures	16430.72	16442.31	16419.13	16440.28	2402.0
2021-06-17 19:00:00	NQ	Futures	16440.28	16441.44	16422.61	16426.38	2956.0
2021-06-17 20:00:00	NQ	Futures	16426.38	16435.07	16411.02	16429.85	4416.0
2021-06-17 21:00:00	NQ	Futures	16430.43	16456.21	16422.9	16446.65	4545.0
2021-06-17 22:00:00	NQ	Futures	16446.36	16450.13	16436.8	16443.47	2379.0
2021-06-17 23:00:00	NQ	Futures	16443.18	16452.45	16440.28	16443.47	1534.0
2021-06-17 00:00:00	YM	Futures	37765.4	37787.7	37755.3	37782.1	750.0
2021-06-17 01:00:00	YM	Futures	37782.1	37791.0	37756.4	37759.8	1463.0
2021-06-17 02:00:00	YM	Futures	37757.5	37766.5	37688.3	37719.5	2872.0
2021-06-17 03:00:00	YM	Futures	37718.4	37776.5	37707.3	37718.4	3562.0

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

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