PREVIEW / futures_1hour / 2021-04-23

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-23.parquet
  size:    52 KB
  rows:    1,558

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-04-23 00:00:00	ES	Futures	4648.36	4649.48	4645.83	4647.51	3374.0
2021-04-23 01:00:00	ES	Futures	4647.51	4648.92	4643.86	4647.79	6180.0
2021-04-23 02:00:00	ES	Futures	4647.79	4648.64	4638.8	4642.18	12108.0
2021-04-23 03:00:00	ES	Futures	4642.18	4654.54	4641.89	4653.41	23886.0
2021-04-23 04:00:00	ES	Futures	4653.69	4653.98	4648.36	4650.89	11831.0
2021-04-23 05:00:00	ES	Futures	4650.89	4651.17	4646.95	4648.64	14700.0
2021-04-23 06:00:00	ES	Futures	4648.64	4652.01	4647.51	4650.32	12170.0
2021-04-23 07:00:00	ES	Futures	4650.32	4651.73	4645.83	4646.95	12944.0
2021-04-23 08:00:00	ES	Futures	4646.95	4649.48	4640.77	4643.02	26704.0
2021-04-23 09:00:00	ES	Futures	4642.74	4659.6	4642.18	4659.31	174799.0
2021-04-23 10:00:00	ES	Futures	4659.31	4680.39	4658.19	4679.54	259244.0
2021-04-23 11:00:00	ES	Futures	4679.83	4685.44	4675.61	4682.92	172770.0
2021-04-23 12:00:00	ES	Futures	4682.92	4694.44	4682.63	4692.47	98965.0
2021-04-23 13:00:00	ES	Futures	4692.47	4695.56	4689.94	4691.34	78287.0
2021-04-23 14:00:00	ES	Futures	4691.34	4697.53	4688.54	4695.28	109090.0
2021-04-23 15:00:00	ES	Futures	4695.28	4705.39	4687.13	4687.41	328971.0
2021-04-23 16:00:00	ES	Futures	4687.69	4689.38	4681.23	4682.07	65030.0
2021-04-23 00:00:00	NQ	Futures	15953.22	15956.69	15937.87	15946.56	1753.0
2021-04-23 01:00:00	NQ	Futures	15946.85	15949.16	15931.21	15946.56	2750.0
2021-04-23 02:00:00	NQ	Futures	15945.98	15949.74	15907.19	15915.0	5048.0
2021-04-23 03:00:00	NQ	Futures	15917.03	15969.72	15909.21	15964.8	7599.0
2021-04-23 04:00:00	NQ	Futures	15964.51	15967.4	15947.43	15950.9	4297.0
2021-04-23 05:00:00	NQ	Futures	15950.32	15955.82	15939.03	15945.11	3553.0
2021-04-23 06:00:00	NQ	Futures	15944.82	15964.8	15943.37	15953.8	4285.0
2021-04-23 07:00:00	NQ	Futures	15953.8	15959.3	15936.43	15948.01	6814.0
2021-04-23 08:00:00	NQ	Futures	15948.3	15960.45	15936.72	15948.3	10475.0
2021-04-23 09:00:00	NQ	Futures	15948.01	16020.09	15940.77	16012.56	64680.0
2021-04-23 10:00:00	NQ	Futures	16013.14	16065.83	16003.59	16062.94	75381.0
2021-04-23 11:00:00	NQ	Futures	16063.22	16139.65	16051.93	16124.6	65049.0
2021-04-23 12:00:00	NQ	Futures	16124.6	16161.94	16119.97	16154.99	39620.0
2021-04-23 13:00:00	NQ	Futures	16155.28	16169.47	16143.99	16155.28	27296.0
2021-04-23 14:00:00	NQ	Futures	16155.28	16176.42	16140.81	16166.29	30614.0
2021-04-23 15:00:00	NQ	Futures	16166.86	16189.73	16120.54	16124.89	56923.0
2021-04-23 16:00:00	NQ	Futures	16124.02	16126.91	16099.99	16099.99	12699.0
2021-04-23 00:00:00	YM	Futures	37594.7	37608.1	37584.7	37592.5	648.0
2021-04-23 01:00:00	YM	Futures	37593.6	37603.6	37569.1	37593.6	1108.0
2021-04-23 02:00:00	YM	Futures	37594.7	37602.5	37526.8	37556.8	2573.0
2021-04-23 03:00:00	YM	Futures	37556.8	37650.4	37555.7	37640.4	4972.0
2021-04-23 04:00:00	YM	Futures	37641.5	37643.7	37600.3	37625.9	2295.0
2021-04-23 05:00:00	YM	Futures	37625.9	37627.0	37582.5	37599.2	2564.0
2021-04-23 06:00:00	YM	Futures	37599.2	37630.4	37582.5	37615.9	2820.0
2021-04-23 07:00:00	YM	Futures	37615.9	37622.6	37550.2	37555.7	3684.0
2021-04-23 08:00:00	YM	Futures	37554.6	37574.7	37485.6	37498.9	5440.0
2021-04-23 09:00:00	YM	Futures	37496.7	37585.8	37433.2	37584.7	22187.0
2021-04-23 10:00:00	YM	Futures	37584.7	37778.5	37583.6	37774.0	24872.0
2021-04-23 11:00:00	YM	Futures	37776.3	37787.4	37727.3	37729.5	12453.0
2021-04-23 12:00:00	YM	Futures	37730.6	37839.8	37730.6	37813.0	8695.0
2021-04-23 13:00:00	YM	Futures	37814.1	37820.8	37788.5	37797.4	5776.0
2021-04-23 14:00:00	YM	Futures	37798.5	37854.2	37780.7	37836.4	7403.0
2021-04-23 15:00:00	YM	Futures	37836.4	37932.2	37786.3	37804.1	17796.0

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

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