PREVIEW / futures_1hour / 2021-08-12

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-12.parquet
  size:    61 KB
  rows:    1,935

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-08-12 00:00:00	ES	Futures	5003.15	5003.15	5000.62	5001.18	2534.0
2021-08-12 01:00:00	ES	Futures	5001.18	5001.46	4998.08	4998.93	5563.0
2021-08-12 02:00:00	ES	Futures	4998.65	5000.34	4996.11	4997.24	6347.0
2021-08-12 03:00:00	ES	Futures	4997.52	5001.18	4996.68	5000.9	14592.0
2021-08-12 04:00:00	ES	Futures	5000.62	5002.87	4999.21	5002.31	8201.0
2021-08-12 05:00:00	ES	Futures	5002.03	5003.43	5000.62	5003.43	7232.0
2021-08-12 06:00:00	ES	Futures	5003.15	5005.69	5001.74	5004.28	9698.0
2021-08-12 07:00:00	ES	Futures	5004.0	5005.41	5003.15	5003.72	5821.0
2021-08-12 08:00:00	ES	Futures	5004.0	5004.56	4998.37	4999.21	26034.0
2021-08-12 09:00:00	ES	Futures	4999.49	5002.31	4992.17	4995.27	126468.0
2021-08-12 10:00:00	ES	Futures	4995.27	5002.03	4989.92	5002.03	135563.0
2021-08-12 11:00:00	ES	Futures	5001.74	5006.25	4997.8	5003.43	102757.0
2021-08-12 12:00:00	ES	Futures	5003.72	5009.91	5003.43	5008.78	84279.0
2021-08-12 13:00:00	ES	Futures	5008.5	5010.76	5006.25	5009.07	55281.0
2021-08-12 14:00:00	ES	Futures	5009.07	5014.98	5007.94	5014.42	60644.0
2021-08-12 15:00:00	ES	Futures	5014.7	5019.2	5014.42	5017.23	133067.0
2021-08-12 16:00:00	ES	Futures	5017.23	5019.2	5015.54	5018.92	30885.0
2021-08-12 18:00:00	ES	Futures	5018.64	5018.64	5015.54	5016.39	3412.0
2021-08-12 19:00:00	ES	Futures	5016.11	5016.95	5014.7	5014.98	2860.0
2021-08-12 20:00:00	ES	Futures	5014.98	5016.95	5013.29	5015.82	6333.0
2021-08-12 21:00:00	ES	Futures	5015.82	5016.95	5014.13	5016.11	5430.0
2021-08-12 22:00:00	ES	Futures	5015.82	5018.36	5014.7	5014.7	5421.0
2021-08-12 23:00:00	ES	Futures	5014.98	5016.95	5014.98	5016.67	2604.0
2021-08-12 00:00:00	NQ	Futures	17391.88	17392.17	17382.03	17384.64	992.0
2021-08-12 01:00:00	NQ	Futures	17383.77	17385.51	17373.05	17374.5	2001.0
2021-08-12 02:00:00	NQ	Futures	17374.5	17386.38	17363.49	17367.55	2489.0
2021-08-12 03:00:00	NQ	Futures	17367.26	17377.98	17361.18	17375.95	4258.0
2021-08-12 04:00:00	NQ	Futures	17375.66	17395.65	17366.68	17389.57	4951.0
2021-08-12 05:00:00	NQ	Futures	17389.86	17393.91	17378.56	17392.46	3534.0
2021-08-12 06:00:00	NQ	Futures	17392.46	17421.43	17387.54	17409.84	4662.0
2021-08-12 07:00:00	NQ	Futures	17410.13	17417.09	17399.13	17407.82	3852.0
2021-08-12 08:00:00	NQ	Futures	17407.53	17414.48	17365.23	17368.13	13005.0
2021-08-12 09:00:00	NQ	Futures	17368.13	17387.25	17318.88	17351.62	74146.0
2021-08-12 10:00:00	NQ	Futures	17351.91	17443.16	17312.8	17440.55	83807.0
2021-08-12 11:00:00	NQ	Futures	17440.84	17466.04	17419.98	17448.37	44417.0
2021-08-12 12:00:00	NQ	Futures	17448.66	17453.59	17424.33	17430.12	31322.0
2021-08-12 13:00:00	NQ	Futures	17429.83	17447.79	17419.11	17441.42	24365.0
2021-08-12 14:00:00	NQ	Futures	17441.71	17472.41	17438.23	17468.36	25872.0
2021-08-12 15:00:00	NQ	Futures	17468.36	17485.74	17464.59	17469.23	40103.0
2021-08-12 16:00:00	NQ	Futures	17469.23	17472.99	17463.43	17472.99	7240.0
2021-08-12 18:00:00	NQ	Futures	17473.28	17473.57	17460.54	17464.01	1532.0
2021-08-12 19:00:00	NQ	Futures	17464.01	17466.33	17456.77	17459.38	1327.0
2021-08-12 20:00:00	NQ	Futures	17459.96	17468.65	17452.14	17462.28	2897.0
2021-08-12 21:00:00	NQ	Futures	17462.28	17466.04	17455.9	17461.7	2501.0
2021-08-12 22:00:00	NQ	Futures	17461.12	17472.41	17458.22	17459.38	2341.0
2021-08-12 23:00:00	NQ	Futures	17459.67	17466.33	17458.8	17464.3	1303.0
2021-08-12 00:00:00	YM	Futures	39541.8	39541.8	39527.3	39532.8	579.0
2021-08-12 01:00:00	YM	Futures	39532.8	39534.0	39513.9	39521.7	924.0
2021-08-12 02:00:00	YM	Futures	39521.7	39531.7	39487.0	39507.1	1818.0
2021-08-12 03:00:00	YM	Futures	39508.3	39547.4	39503.8	39542.9	2355.0

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

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