PREVIEW / futures_1hour / 2020-07-01

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-01.parquet
  size:    59 KB
  rows:    1,821

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-07-01 00:00:00	ES	Futures	3446.14	3447.54	3441.96	3442.51	4702.0
2020-07-01 01:00:00	ES	Futures	3442.79	3443.91	3432.18	3436.65	13733.0
2020-07-01 02:00:00	ES	Futures	3436.37	3445.86	3432.18	3445.03	13012.0
2020-07-01 03:00:00	ES	Futures	3445.03	3453.13	3441.68	3449.22	15645.0
2020-07-01 04:00:00	ES	Futures	3448.94	3452.85	3444.47	3447.26	10666.0
2020-07-01 05:00:00	ES	Futures	3447.54	3455.36	3437.49	3440.0	27082.0
2020-07-01 06:00:00	ES	Futures	3440.28	3447.54	3429.11	3432.74	38148.0
2020-07-01 07:00:00	ES	Futures	3432.46	3433.02	3421.01	3429.11	54651.0
2020-07-01 08:00:00	ES	Futures	3428.83	3456.76	3427.16	3456.48	73442.0
2020-07-01 09:00:00	ES	Futures	3456.2	3471.56	3453.4	3458.99	241186.0
2020-07-01 10:00:00	ES	Futures	3459.27	3475.46	3458.43	3467.93	210756.0
2020-07-01 11:00:00	ES	Futures	3468.2	3469.32	3450.61	3464.3	155388.0
2020-07-01 12:00:00	ES	Futures	3464.3	3477.7	3462.34	3470.16	128692.0
2020-07-01 13:00:00	ES	Futures	3470.16	3473.23	3464.57	3469.88	80249.0
2020-07-01 14:00:00	ES	Futures	3469.6	3475.74	3464.85	3471.28	98575.0
2020-07-01 15:00:00	ES	Futures	3471.28	3482.45	3466.53	3467.93	220722.0
2020-07-01 16:00:00	ES	Futures	3467.93	3469.6	3462.62	3463.46	50340.0
2020-07-01 18:00:00	ES	Futures	3464.57	3469.04	3460.94	3468.48	9919.0
2020-07-01 19:00:00	ES	Futures	3468.76	3470.16	3463.18	3465.41	7862.0
2020-07-01 20:00:00	ES	Futures	3464.85	3468.2	3458.71	3461.22	14279.0
2020-07-01 21:00:00	ES	Futures	3461.22	3468.76	3457.59	3464.85	14181.0
2020-07-01 22:00:00	ES	Futures	3465.41	3473.51	3464.3	3472.95	8999.0
2020-07-01 23:00:00	ES	Futures	3472.95	3474.91	3468.48	3469.6	8207.0
2020-07-01 00:00:00	NQ	Futures	11729.37	11734.0	11713.18	11717.23	1419.0
2020-07-01 01:00:00	NQ	Futures	11716.94	11721.27	11688.31	11701.61	4023.0
2020-07-01 02:00:00	NQ	Futures	11700.74	11730.24	11687.44	11725.61	4325.0
2020-07-01 03:00:00	NQ	Futures	11725.9	11749.61	11720.12	11731.68	4662.0
2020-07-01 04:00:00	NQ	Futures	11730.82	11743.54	11714.04	11724.45	4039.0
2020-07-01 05:00:00	NQ	Futures	11724.17	11745.56	11696.4	11703.92	7405.0
2020-07-01 06:00:00	NQ	Futures	11703.63	11727.92	11676.16	11687.15	9409.0
2020-07-01 07:00:00	NQ	Futures	11686.86	11692.64	11655.05	11668.06	13004.0
2020-07-01 08:00:00	NQ	Futures	11668.35	11744.12	11664.88	11739.2	19069.0
2020-07-01 09:00:00	NQ	Futures	11738.62	11790.68	11712.31	11740.65	73258.0
2020-07-01 10:00:00	NQ	Futures	11740.36	11826.53	11730.82	11819.88	58816.0
2020-07-01 11:00:00	NQ	Futures	11819.88	11842.44	11800.51	11832.9	46193.0
2020-07-01 12:00:00	NQ	Futures	11832.9	11876.56	11827.69	11858.92	32714.0
2020-07-01 13:00:00	NQ	Futures	11858.92	11873.67	11829.14	11866.73	23524.0
2020-07-01 14:00:00	NQ	Futures	11867.31	11885.53	11845.33	11872.51	26484.0
2020-07-01 15:00:00	NQ	Futures	11872.8	11925.72	11868.47	11873.67	44542.0
2020-07-01 16:00:00	NQ	Futures	11873.67	11881.48	11858.63	11862.68	10444.0
2020-07-01 18:00:00	NQ	Futures	11866.15	11884.08	11852.27	11882.92	2510.0
2020-07-01 19:00:00	NQ	Futures	11882.35	11890.15	11872.22	11878.3	2197.0
2020-07-01 20:00:00	NQ	Futures	11878.3	11887.26	11859.5	11873.38	3139.0
2020-07-01 21:00:00	NQ	Futures	11871.94	11897.96	11860.37	11886.11	4035.0
2020-07-01 22:00:00	NQ	Futures	11886.39	11909.53	11883.21	11908.37	2412.0
2020-07-01 23:00:00	NQ	Futures	11908.37	11913.29	11897.96	11902.88	2310.0
2020-07-01 00:00:00	YM	Futures	28211.2	28227.7	28172.7	28180.4	1065.0
2020-07-01 01:00:00	YM	Futures	28179.3	28194.7	28091.2	28133.0	2857.0
2020-07-01 02:00:00	YM	Futures	28129.7	28206.8	28085.7	28198.0	2970.0
2020-07-01 03:00:00	YM	Futures	28198.0	28288.3	28163.9	28245.3	3766.0

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

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