PREVIEW / futures_1hour / 2020-06-24

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-24.parquet
  size:    61 KB
  rows:    1,844

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-24 00:00:00	ES	Futures	3484.12	3494.45	3482.73	3489.71	9198.0
2020-06-24 01:00:00	ES	Futures	3489.99	3491.66	3483.84	3483.84	8794.0
2020-06-24 02:00:00	ES	Futures	3483.84	3487.75	3477.98	3485.52	12435.0
2020-06-24 03:00:00	ES	Futures	3485.52	3490.26	3464.85	3469.04	36866.0
2020-06-24 04:00:00	ES	Futures	3469.04	3470.44	3447.26	3459.83	45450.0
2020-06-24 05:00:00	ES	Futures	3459.83	3463.74	3441.4	3450.61	45771.0
2020-06-24 06:00:00	ES	Futures	3450.61	3457.87	3447.54	3457.03	31105.0
2020-06-24 07:00:00	ES	Futures	3457.31	3462.34	3454.8	3457.59	20606.0
2020-06-24 08:00:00	ES	Futures	3457.59	3468.2	3456.2	3466.81	38575.0
2020-06-24 09:00:00	ES	Futures	3466.81	3469.04	3435.25	3436.37	228575.0
2020-06-24 10:00:00	ES	Futures	3436.65	3443.35	3418.5	3422.13	348081.0
2020-06-24 11:00:00	ES	Futures	3421.85	3426.04	3372.98	3387.78	427313.0
2020-06-24 12:00:00	ES	Futures	3387.78	3409.0	3383.87	3407.89	194588.0
2020-06-24 13:00:00	ES	Futures	3407.89	3410.96	3383.04	3392.25	174709.0
2020-06-24 14:00:00	ES	Futures	3392.53	3403.42	3380.24	3390.85	204572.0
2020-06-24 15:00:00	ES	Futures	3390.57	3413.19	3390.02	3395.88	357297.0
2020-06-24 16:00:00	ES	Futures	3395.6	3407.61	3395.6	3406.77	79696.0
2020-06-24 18:00:00	ES	Futures	3403.14	3409.28	3396.16	3398.11	15655.0
2020-06-24 19:00:00	ES	Futures	3398.39	3398.95	3392.25	3392.53	14298.0
2020-06-24 20:00:00	ES	Futures	3392.53	3412.36	3388.9	3409.28	24288.0
2020-06-24 21:00:00	ES	Futures	3409.28	3414.03	3381.36	3382.48	26500.0
2020-06-24 22:00:00	ES	Futures	3382.76	3390.85	3373.54	3389.18	23772.0
2020-06-24 23:00:00	ES	Futures	3389.74	3392.53	3379.13	3390.57	14303.0
2020-06-24 00:00:00	NQ	Futures	11815.84	11847.07	11810.34	11835.21	4561.0
2020-06-24 01:00:00	NQ	Futures	11835.79	11839.84	11820.17	11823.64	3837.0
2020-06-24 02:00:00	NQ	Futures	11823.93	11830.0	11804.27	11826.53	5125.0
2020-06-24 03:00:00	NQ	Futures	11826.53	11835.5	11745.28	11766.67	12384.0
2020-06-24 04:00:00	NQ	Futures	11768.99	11772.46	11712.89	11749.32	12071.0
2020-06-24 05:00:00	NQ	Futures	11749.9	11759.73	11689.75	11725.9	12470.0
2020-06-24 06:00:00	NQ	Futures	11726.19	11747.88	11718.67	11740.36	7880.0
2020-06-24 07:00:00	NQ	Futures	11740.65	11758.58	11736.6	11747.01	7087.0
2020-06-24 08:00:00	NQ	Futures	11747.59	11779.98	11746.72	11777.09	11770.0
2020-06-24 09:00:00	NQ	Futures	11777.09	11823.35	11668.93	11678.76	72358.0
2020-06-24 10:00:00	NQ	Futures	11678.48	11713.75	11631.63	11651.58	94835.0
2020-06-24 11:00:00	NQ	Futures	11651.58	11662.86	11482.99	11532.44	105623.0
2020-06-24 12:00:00	NQ	Futures	11531.86	11600.98	11509.31	11597.79	60917.0
2020-06-24 13:00:00	NQ	Futures	11597.51	11613.41	11523.19	11553.55	53793.0
2020-06-24 14:00:00	NQ	Futures	11553.84	11585.65	11495.71	11535.91	61887.0
2020-06-24 15:00:00	NQ	Futures	11535.62	11610.23	11534.46	11558.76	81544.0
2020-06-24 16:00:00	NQ	Futures	11558.47	11586.81	11557.6	11584.78	13939.0
2020-06-24 18:00:00	NQ	Futures	11573.21	11592.59	11549.79	11558.18	3749.0
2020-06-24 19:00:00	NQ	Futures	11558.47	11563.38	11536.2	11536.78	2888.0
2020-06-24 20:00:00	NQ	Futures	11537.36	11601.84	11525.5	11594.61	6749.0
2020-06-24 21:00:00	NQ	Futures	11593.75	11603.87	11523.19	11527.23	6803.0
2020-06-24 22:00:00	NQ	Futures	11526.66	11548.92	11498.9	11545.74	6651.0
2020-06-24 23:00:00	NQ	Futures	11545.74	11557.89	11522.61	11550.08	3869.0
2020-06-24 00:00:00	YM	Futures	28653.9	28777.2	28646.2	28716.6	3629.0
2020-06-24 01:00:00	YM	Futures	28719.9	28727.6	28655.0	28657.2	3351.0
2020-06-24 02:00:00	YM	Futures	28659.4	28706.7	28607.6	28677.0	4664.0
2020-06-24 03:00:00	YM	Futures	28677.0	28726.5	28476.6	28523.9	10460.0

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

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