PREVIEW / futures_1hour / 2021-06-24

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-24.parquet
  size:    60 KB
  rows:    1,882

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-24 00:00:00	ES	Futures	4778.45	4778.73	4776.76	4777.04	1577.0
2021-06-24 01:00:00	ES	Futures	4777.32	4777.89	4774.51	4775.63	3655.0
2021-06-24 02:00:00	ES	Futures	4775.63	4778.45	4774.79	4776.76	6473.0
2021-06-24 03:00:00	ES	Futures	4777.04	4781.27	4775.35	4780.42	18551.0
2021-06-24 04:00:00	ES	Futures	4780.14	4788.87	4779.86	4788.02	22175.0
2021-06-24 05:00:00	ES	Futures	4788.31	4791.68	4787.74	4788.87	15584.0
2021-06-24 06:00:00	ES	Futures	4789.15	4791.97	4787.46	4788.87	9631.0
2021-06-24 07:00:00	ES	Futures	4789.15	4790.84	4787.46	4789.15	15475.0
2021-06-24 08:00:00	ES	Futures	4789.15	4791.12	4784.65	4787.74	23925.0
2021-06-24 09:00:00	ES	Futures	4788.02	4796.19	4786.62	4791.68	127753.0
2021-06-24 10:00:00	ES	Futures	4791.97	4798.72	4789.71	4792.81	133592.0
2021-06-24 11:00:00	ES	Futures	4793.09	4795.06	4788.31	4790.28	67665.0
2021-06-24 12:00:00	ES	Futures	4790.28	4796.75	4790.0	4795.35	63169.0
2021-06-24 13:00:00	ES	Futures	4795.35	4799.01	4790.28	4794.5	74886.0
2021-06-24 14:00:00	ES	Futures	4794.5	4799.01	4793.94	4797.32	56075.0
2021-06-24 15:00:00	ES	Futures	4797.03	4797.6	4791.4	4793.66	133715.0
2021-06-24 16:00:00	ES	Futures	4793.66	4802.38	4793.09	4800.7	42467.0
2021-06-24 18:00:00	ES	Futures	4800.41	4800.98	4797.88	4800.13	4361.0
2021-06-24 19:00:00	ES	Futures	4800.13	4800.13	4796.75	4797.6	3739.0
2021-06-24 20:00:00	ES	Futures	4797.88	4799.57	4795.91	4797.6	5738.0
2021-06-24 21:00:00	ES	Futures	4797.88	4799.85	4795.35	4797.88	7605.0
2021-06-24 22:00:00	ES	Futures	4798.16	4800.13	4797.6	4799.57	4522.0
2021-06-24 23:00:00	ES	Futures	4799.57	4802.95	4798.72	4802.38	4595.0
2021-06-24 00:00:00	NQ	Futures	16575.27	16576.72	16568.9	16571.8	993.0
2021-06-24 01:00:00	NQ	Futures	16572.09	16575.56	16563.68	16569.77	1750.0
2021-06-24 02:00:00	NQ	Futures	16568.9	16573.82	16563.97	16568.03	2831.0
2021-06-24 03:00:00	NQ	Futures	16568.03	16585.7	16564.55	16579.33	6050.0
2021-06-24 04:00:00	NQ	Futures	16579.04	16627.99	16576.72	16624.52	10906.0
2021-06-24 05:00:00	NQ	Futures	16625.68	16637.84	16619.59	16624.23	5077.0
2021-06-24 06:00:00	NQ	Futures	16623.94	16631.18	16613.51	16616.7	4127.0
2021-06-24 07:00:00	NQ	Futures	16616.7	16626.84	16612.06	16624.23	5667.0
2021-06-24 08:00:00	NQ	Futures	16623.65	16636.97	16612.06	16622.78	9548.0
2021-06-24 09:00:00	NQ	Futures	16622.78	16669.71	16618.72	16658.41	59134.0
2021-06-24 10:00:00	NQ	Futures	16658.7	16699.26	16652.04	16672.6	61915.0
2021-06-24 11:00:00	NQ	Futures	16672.6	16686.8	16660.73	16680.72	32727.0
2021-06-24 12:00:00	NQ	Futures	16680.43	16711.13	16641.61	16650.88	43813.0
2021-06-24 13:00:00	NQ	Futures	16650.59	16667.1	16601.34	16632.63	50351.0
2021-06-24 14:00:00	NQ	Futures	16632.63	16662.47	16629.73	16649.72	31522.0
2021-06-24 15:00:00	NQ	Futures	16649.43	16653.49	16606.85	16632.63	55557.0
2021-06-24 16:00:00	NQ	Futures	16632.34	16641.32	16626.26	16638.13	9371.0
2021-06-24 18:00:00	NQ	Futures	16645.95	16647.4	16628.57	16644.51	2241.0
2021-06-24 19:00:00	NQ	Futures	16645.09	16645.95	16621.33	16623.94	1796.0
2021-06-24 20:00:00	NQ	Futures	16624.52	16632.63	16617.28	16625.97	2702.0
2021-06-24 21:00:00	NQ	Futures	16625.39	16631.76	16606.85	16623.36	3572.0
2021-06-24 22:00:00	NQ	Futures	16623.94	16640.45	16620.17	16636.1	2433.0
2021-06-24 23:00:00	NQ	Futures	16636.1	16656.09	16632.63	16655.22	3524.0
2021-06-24 00:00:00	YM	Futures	37833.5	37833.5	37814.5	37815.6	529.0
2021-06-24 01:00:00	YM	Futures	37816.7	37820.1	37788.8	37796.6	1038.0
2021-06-24 02:00:00	YM	Futures	37794.4	37843.6	37791.0	37825.7	1295.0
2021-06-24 03:00:00	YM	Futures	37825.7	37863.7	37803.3	37842.4	2870.0

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

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