PREVIEW / futures_1hour / 2023-03-21

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-21.parquet
  size:    69 KB
  rows:    2,056

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
2023-03-21 00:00:00	ES	Futures	4424.62	4424.9	4421.57	4422.12	2720.0
2023-03-21 01:00:00	ES	Futures	4422.12	4425.45	4420.74	4423.23	3296.0
2023-03-21 02:00:00	ES	Futures	4423.51	4428.78	4421.57	4427.67	5178.0
2023-03-21 03:00:00	ES	Futures	4427.67	4436.54	4424.62	4431.55	13228.0
2023-03-21 04:00:00	ES	Futures	4431.55	4436.54	4426.28	4433.22	25421.0
2023-03-21 05:00:00	ES	Futures	4433.22	4444.59	4431.28	4443.48	23254.0
2023-03-21 06:00:00	ES	Futures	4443.48	4453.19	4441.81	4446.53	29936.0
2023-03-21 07:00:00	ES	Futures	4446.53	4459.01	4443.76	4457.62	31324.0
2023-03-21 08:00:00	ES	Futures	4457.35	4459.57	4453.46	4456.51	28629.0
2023-03-21 09:00:00	ES	Futures	4456.51	4468.44	4455.13	4467.33	159753.0
2023-03-21 10:00:00	ES	Futures	4467.33	4472.6	4444.59	4449.03	265773.0
2023-03-21 11:00:00	ES	Futures	4449.03	4461.23	4441.54	4445.14	175191.0
2023-03-21 12:00:00	ES	Futures	4445.42	4456.79	4442.37	4451.24	111255.0
2023-03-21 13:00:00	ES	Futures	4451.52	4462.62	4448.19	4449.86	91193.0
2023-03-21 14:00:00	ES	Futures	4449.86	4468.72	4449.58	4465.67	103838.0
2023-03-21 15:00:00	ES	Futures	4465.67	4485.64	4465.11	4480.37	260966.0
2023-03-21 16:00:00	ES	Futures	4480.09	4483.69	4478.98	4480.92	59951.0
2023-03-21 18:00:00	ES	Futures	4480.64	4480.64	4476.48	4478.98	3926.0
2023-03-21 19:00:00	ES	Futures	4479.26	4480.64	4477.59	4479.53	4295.0
2023-03-21 20:00:00	ES	Futures	4479.26	4479.81	4473.99	4475.93	7875.0
2023-03-21 21:00:00	ES	Futures	4476.48	4481.48	4474.26	4480.92	7302.0
2023-03-21 22:00:00	ES	Futures	4480.64	4480.92	4475.93	4477.04	4734.0
2023-03-21 23:00:00	ES	Futures	4477.32	4479.26	4475.93	4478.98	4578.0
2023-03-21 00:00:00	NQ	Futures	14297.26	14301.49	14287.69	14300.08	1590.0
2023-03-21 01:00:00	NQ	Futures	14299.8	14311.34	14292.76	14300.92	2263.0
2023-03-21 02:00:00	NQ	Futures	14301.49	14316.41	14294.73	14314.44	2702.0
2023-03-21 03:00:00	NQ	Futures	14313.59	14350.48	14300.92	14329.92	7208.0
2023-03-21 04:00:00	NQ	Futures	14330.49	14340.9	14310.5	14314.72	10520.0
2023-03-21 05:00:00	NQ	Futures	14315.28	14323.45	14295.85	14323.17	8621.0
2023-03-21 06:00:00	NQ	Futures	14322.6	14357.51	14314.72	14332.74	11969.0
2023-03-21 07:00:00	NQ	Futures	14332.74	14406.5	14329.36	14395.52	15724.0
2023-03-21 08:00:00	NQ	Futures	14395.52	14403.41	14363.71	14374.13	13335.0
2023-03-21 09:00:00	NQ	Futures	14374.13	14435.79	14371.31	14432.41	59675.0
2023-03-21 10:00:00	NQ	Futures	14432.41	14457.47	14317.82	14338.93	95783.0
2023-03-21 11:00:00	NQ	Futures	14339.21	14391.3	14316.97	14339.78	65983.0
2023-03-21 12:00:00	NQ	Futures	14340.06	14403.13	14331.89	14392.43	47902.0
2023-03-21 13:00:00	NQ	Futures	14392.71	14438.04	14383.42	14396.37	45837.0
2023-03-21 14:00:00	NQ	Futures	14396.93	14470.42	14394.96	14460.56	43283.0
2023-03-21 15:00:00	NQ	Futures	14460.56	14526.16	14458.87	14502.51	88551.0
2023-03-21 16:00:00	NQ	Futures	14502.23	14512.37	14496.04	14501.39	13963.0
2023-03-21 18:00:00	NQ	Futures	14498.01	14499.98	14486.18	14490.97	1950.0
2023-03-21 19:00:00	NQ	Futures	14490.97	14500.82	14486.47	14492.94	1922.0
2023-03-21 20:00:00	NQ	Futures	14492.38	14496.04	14479.71	14491.25	3090.0
2023-03-21 21:00:00	NQ	Futures	14491.53	14512.93	14487.03	14510.68	3170.0
2023-03-21 22:00:00	NQ	Futures	14510.96	14511.24	14492.66	14500.26	2264.0
2023-03-21 23:00:00	NQ	Futures	14499.98	14502.51	14494.35	14500.26	1375.0
2023-03-21 00:00:00	YM	Futures	35919.2	35920.3	35888.3	35888.3	490.0
2023-03-21 01:00:00	YM	Futures	35888.3	35908.2	35876.1	35890.5	564.0
2023-03-21 02:00:00	YM	Futures	35890.5	35928.0	35877.2	35923.6	939.0
2023-03-21 03:00:00	YM	Futures	35923.6	35982.2	35911.5	35942.4	2532.0

> showing 50 of 2,056 rows — these rows as CSV

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