PREVIEW / futures_1hour / 2020-06-10

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-10.parquet
  size:    57 KB
  rows:    1,720

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
2020-06-10 00:00:00	ES	Futures	3537.2	3537.75	3533.08	3536.93	6152.0
2020-06-10 01:00:00	ES	Futures	3536.93	3540.22	3535.55	3537.2	9817.0
2020-06-10 02:00:00	ES	Futures	3537.2	3539.67	3526.5	3528.69	18269.0
2020-06-10 03:00:00	ES	Futures	3528.69	3539.4	3527.05	3536.1	27588.0
2020-06-10 04:00:00	ES	Futures	3535.83	3537.2	3524.85	3526.22	21546.0
2020-06-10 05:00:00	ES	Futures	3526.22	3526.22	3511.13	3516.34	38284.0
2020-06-10 06:00:00	ES	Futures	3516.62	3522.11	3504.82	3519.64	35495.0
2020-06-10 07:00:00	ES	Futures	3519.36	3529.79	3516.34	3528.69	32203.0
2020-06-10 08:00:00	ES	Futures	3528.42	3533.08	3526.5	3531.16	56020.0
2020-06-10 09:00:00	ES	Futures	3531.16	3533.36	3505.37	3512.78	199525.0
2020-06-10 10:00:00	ES	Futures	3512.78	3516.34	3490.28	3495.22	277874.0
2020-06-10 11:00:00	ES	Futures	3495.49	3511.41	3493.84	3506.74	169715.0
2020-06-10 12:00:00	ES	Futures	3507.01	3515.25	3502.9	3512.23	88407.0
2020-06-10 13:00:00	ES	Futures	3512.23	3515.25	3507.29	3508.66	77478.0
2020-06-10 14:00:00	ES	Futures	3508.66	3535.83	3497.41	3508.66	360241.0
2020-06-10 15:00:00	ES	Futures	3508.66	3525.68	3496.59	3499.33	332257.0
2020-06-10 16:00:00	ES	Futures	3499.33	3501.8	3490.82	3494.94	74240.0
2020-06-10 18:00:00	ES	Futures	3494.67	3499.88	3477.38	3480.4	23341.0
2020-06-10 19:00:00	ES	Futures	3480.12	3485.06	3470.79	3473.81	20585.0
2020-06-10 20:00:00	ES	Futures	3473.81	3487.26	3472.16	3483.14	22024.0
2020-06-10 21:00:00	ES	Futures	3483.42	3491.37	3481.49	3483.69	18012.0
2020-06-10 22:00:00	ES	Futures	3483.69	3486.16	3477.38	3479.02	9411.0
2020-06-10 23:00:00	ES	Futures	3479.02	3479.57	3461.46	3462.83	19816.0
2020-06-10 00:00:00	NQ	Futures	11435.34	11437.05	11422.77	11433.34	2635.0
2020-06-10 01:00:00	NQ	Futures	11433.05	11438.19	11428.48	11432.48	2546.0
2020-06-10 02:00:00	NQ	Futures	11432.77	11443.34	11411.91	11413.63	5418.0
2020-06-10 03:00:00	NQ	Futures	11414.2	11434.48	11409.63	11431.91	6514.0
2020-06-10 04:00:00	NQ	Futures	11431.34	11441.05	11420.2	11426.2	5110.0
2020-06-10 05:00:00	NQ	Futures	11426.2	11426.2	11391.35	11411.91	8459.0
2020-06-10 06:00:00	NQ	Futures	11412.2	11413.34	11378.21	11405.63	7869.0
2020-06-10 07:00:00	NQ	Futures	11405.35	11464.76	11404.2	11458.76	10481.0
2020-06-10 08:00:00	NQ	Futures	11458.76	11479.61	11452.48	11476.47	15391.0
2020-06-10 09:00:00	NQ	Futures	11476.18	11501.03	11452.48	11492.18	69073.0
2020-06-10 10:00:00	NQ	Futures	11491.89	11514.46	11445.91	11457.33	82508.0
2020-06-10 11:00:00	NQ	Futures	11457.33	11510.46	11451.33	11484.47	53795.0
2020-06-10 12:00:00	NQ	Futures	11484.75	11509.32	11458.76	11497.61	33820.0
2020-06-10 13:00:00	NQ	Futures	11498.46	11513.32	11481.33	11488.75	32383.0
2020-06-10 14:00:00	NQ	Futures	11488.18	11591.87	11460.76	11535.31	91507.0
2020-06-10 15:00:00	NQ	Futures	11536.17	11603.29	11501.61	11528.74	86773.0
2020-06-10 16:00:00	NQ	Futures	11528.46	11541.6	11505.6	11526.46	12621.0
2020-06-10 18:00:00	NQ	Futures	11524.17	11547.88	11477.9	11478.18	6650.0
2020-06-10 19:00:00	NQ	Futures	11477.9	11495.89	11461.62	11474.76	5352.0
2020-06-10 20:00:00	NQ	Futures	11475.33	11513.32	11468.76	11507.03	5426.0
2020-06-10 21:00:00	NQ	Futures	11507.6	11534.74	11507.32	11516.17	6382.0
2020-06-10 22:00:00	NQ	Futures	11516.17	11527.03	11501.89	11507.89	3460.0
2020-06-10 23:00:00	NQ	Futures	11506.75	11508.46	11452.76	11456.19	6313.0
2020-06-10 00:00:00	YM	Futures	30035.8	30035.8	30007.2	30032.5	6.0
2020-06-10 01:00:00	YM	Futures	30045.7	30083.1	30044.6	30061.1	7.0
2020-06-10 02:00:00	YM	Futures	30006.1	30006.1	29947.7	29968.6	12.0
2020-06-10 03:00:00	YM	Futures	29984.0	30044.6	29984.0	30022.6	10.0

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

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