PREVIEW / futures_1hour / 2021-05-18

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-18.parquet
  size:    63 KB
  rows:    1,964

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-05-18 00:00:00	ES	Futures	4685.44	4685.73	4681.51	4684.6	4414.0
2021-05-18 01:00:00	ES	Futures	4684.6	4688.82	4683.48	4687.69	7775.0
2021-05-18 02:00:00	ES	Futures	4687.97	4697.25	4687.13	4693.59	16376.0
2021-05-18 03:00:00	ES	Futures	4693.87	4696.12	4689.66	4691.63	17849.0
2021-05-18 04:00:00	ES	Futures	4691.63	4691.91	4686.57	4687.13	10541.0
2021-05-18 05:00:00	ES	Futures	4687.41	4690.5	4685.44	4686.29	14168.0
2021-05-18 06:00:00	ES	Futures	4686.57	4690.5	4684.6	4686.29	8879.0
2021-05-18 07:00:00	ES	Futures	4686.01	4687.69	4678.7	4679.83	18256.0
2021-05-18 08:00:00	ES	Futures	4680.11	4684.04	4675.33	4677.02	24560.0
2021-05-18 09:00:00	ES	Futures	4677.02	4679.26	4665.5	4668.59	181061.0
2021-05-18 10:00:00	ES	Futures	4668.31	4678.42	4661.28	4675.33	181807.0
2021-05-18 11:00:00	ES	Futures	4675.33	4676.73	4665.78	4666.06	104991.0
2021-05-18 12:00:00	ES	Futures	4666.06	4673.08	4664.65	4670.27	68741.0
2021-05-18 13:00:00	ES	Futures	4670.55	4673.92	4666.9	4666.9	73360.0
2021-05-18 14:00:00	ES	Futures	4666.9	4668.59	4646.11	4655.94	155401.0
2021-05-18 15:00:00	ES	Futures	4655.94	4662.97	4630.94	4633.75	232591.0
2021-05-18 16:00:00	ES	Futures	4633.47	4637.4	4620.82	4624.47	79909.0
2021-05-18 18:00:00	ES	Futures	4623.63	4630.66	4622.23	4627.56	9188.0
2021-05-18 19:00:00	ES	Futures	4627.85	4633.75	4618.29	4618.29	11664.0
2021-05-18 20:00:00	ES	Futures	4618.85	4629.81	4613.24	4626.44	20616.0
2021-05-18 21:00:00	ES	Futures	4626.72	4632.34	4621.66	4624.76	13991.0
2021-05-18 22:00:00	ES	Futures	4624.19	4624.76	4611.55	4614.36	13102.0
2021-05-18 23:00:00	ES	Futures	4614.08	4620.26	4612.39	4618.85	8438.0
2021-05-18 00:00:00	NQ	Futures	15462.81	15464.84	15441.97	15458.47	2107.0
2021-05-18 01:00:00	NQ	Futures	15458.76	15499.0	15450.07	15492.05	5278.0
2021-05-18 02:00:00	NQ	Futures	15492.63	15545.32	15487.71	15536.92	7161.0
2021-05-18 03:00:00	NQ	Futures	15537.79	15554.29	15526.21	15529.4	8449.0
2021-05-18 04:00:00	NQ	Futures	15530.26	15531.42	15512.03	15516.66	5891.0
2021-05-18 05:00:00	NQ	Futures	15516.66	15535.76	15509.42	15522.74	5076.0
2021-05-18 06:00:00	NQ	Futures	15523.61	15533.74	15502.76	15513.47	4641.0
2021-05-18 07:00:00	NQ	Futures	15513.18	15514.05	15477.58	15484.52	6788.0
2021-05-18 08:00:00	NQ	Futures	15485.1	15507.39	15463.39	15477.29	10440.0
2021-05-18 09:00:00	NQ	Futures	15476.71	15479.31	15401.15	15432.7	68735.0
2021-05-18 10:00:00	NQ	Futures	15432.99	15512.89	15413.31	15497.84	66774.0
2021-05-18 11:00:00	NQ	Futures	15498.13	15507.39	15433.28	15434.73	41355.0
2021-05-18 12:00:00	NQ	Futures	15435.02	15488.29	15431.55	15467.73	28350.0
2021-05-18 13:00:00	NQ	Futures	15468.02	15480.76	15432.13	15437.63	26793.0
2021-05-18 14:00:00	NQ	Futures	15437.34	15445.73	15331.67	15365.25	53110.0
2021-05-18 15:00:00	NQ	Futures	15365.54	15415.62	15289.69	15300.69	58392.0
2021-05-18 16:00:00	NQ	Futures	15300.69	15312.85	15260.45	15272.32	14120.0
2021-05-18 18:00:00	NQ	Futures	15264.51	15300.12	15263.93	15289.98	4302.0
2021-05-18 19:00:00	NQ	Futures	15290.56	15311.98	15246.56	15250.61	5416.0
2021-05-18 20:00:00	NQ	Futures	15253.22	15301.27	15234.98	15284.48	8261.0
2021-05-18 21:00:00	NQ	Futures	15284.77	15304.75	15263.35	15274.35	6389.0
2021-05-18 22:00:00	NQ	Futures	15275.51	15275.51	15212.98	15222.53	7380.0
2021-05-18 23:00:00	NQ	Futures	15222.24	15249.45	15216.16	15244.53	4702.0
2021-05-18 00:00:00	YM	Futures	38280.8	38283.1	38249.6	38265.2	798.0
2021-05-18 01:00:00	YM	Futures	38265.2	38288.6	38261.9	38278.6	1042.0
2021-05-18 02:00:00	YM	Futures	38280.8	38341.0	38275.3	38304.2	2640.0
2021-05-18 03:00:00	YM	Futures	38306.4	38332.1	38256.3	38284.2	3127.0

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

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