PREVIEW / futures_1hour / 2020-06-18

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-18.parquet
  size:    59 KB
  rows:    1,822

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-18 00:00:00	ES	Futures	3447.26	3456.2	3440.28	3452.85	12703.0
2020-06-18 01:00:00	ES	Futures	3453.13	3455.64	3441.96	3449.22	12850.0
2020-06-18 02:00:00	ES	Futures	3448.94	3472.39	3444.47	3462.9	32025.0
2020-06-18 03:00:00	ES	Futures	3463.18	3471.56	3455.64	3465.13	30435.0
2020-06-18 04:00:00	ES	Futures	3465.13	3483.28	3458.99	3478.26	44318.0
2020-06-18 05:00:00	ES	Futures	3478.26	3484.96	3468.2	3471.56	41372.0
2020-06-18 06:00:00	ES	Futures	3471.56	3472.11	3460.39	3465.97	27660.0
2020-06-18 07:00:00	ES	Futures	3465.97	3469.04	3440.84	3441.96	41326.0
2020-06-18 08:00:00	ES	Futures	3442.23	3456.2	3433.02	3448.94	79421.0
2020-06-18 09:00:00	ES	Futures	3448.94	3464.3	3440.84	3455.08	162402.0
2020-06-18 10:00:00	ES	Futures	3455.08	3472.67	3448.66	3471.56	231174.0
2020-06-18 11:00:00	ES	Futures	3471.28	3472.67	3455.36	3457.03	125356.0
2020-06-18 12:00:00	ES	Futures	3456.76	3464.3	3451.45	3462.34	76481.0
2020-06-18 13:00:00	ES	Futures	3462.34	3469.04	3459.55	3467.37	52365.0
2020-06-18 14:00:00	ES	Futures	3467.65	3468.48	3452.29	3452.85	106419.0
2020-06-18 15:00:00	ES	Futures	3452.57	3469.32	3447.54	3465.97	185929.0
2020-06-18 16:00:00	ES	Futures	3465.97	3468.76	3458.99	3461.78	49532.0
2020-06-18 18:00:00	ES	Futures	3458.99	3471.28	3458.99	3470.44	8247.0
2020-06-18 19:00:00	ES	Futures	3470.72	3481.61	3470.44	3479.65	11175.0
2020-06-18 20:00:00	ES	Futures	3479.65	3479.65	3459.55	3465.13	19792.0
2020-06-18 21:00:00	ES	Futures	3464.85	3470.16	3456.76	3462.34	17517.0
2020-06-18 22:00:00	ES	Futures	3462.34	3471.0	3460.39	3469.88	10733.0
2020-06-18 23:00:00	ES	Futures	3469.88	3471.28	3464.3	3468.76	5686.0
2020-06-18 00:00:00	NQ	Futures	11493.4	11524.92	11479.52	11520.01	4717.0
2020-06-18 01:00:00	NQ	Futures	11520.58	11529.55	11483.28	11503.23	4074.0
2020-06-18 02:00:00	NQ	Futures	11502.37	11566.56	11488.2	11547.48	7452.0
2020-06-18 03:00:00	NQ	Futures	11548.06	11565.41	11523.76	11547.48	7702.0
2020-06-18 04:00:00	NQ	Futures	11547.19	11597.79	11531.28	11589.7	11953.0
2020-06-18 05:00:00	NQ	Futures	11588.54	11600.69	11558.76	11569.74	7561.0
2020-06-18 06:00:00	NQ	Futures	11571.19	11571.19	11537.36	11553.55	4922.0
2020-06-18 07:00:00	NQ	Futures	11551.82	11562.51	11494.27	11501.5	7930.0
2020-06-18 08:00:00	NQ	Futures	11501.79	11549.21	11485.01	11535.91	24229.0
2020-06-18 09:00:00	NQ	Futures	11535.62	11553.26	11499.76	11526.08	58472.0
2020-06-18 10:00:00	NQ	Futures	11525.79	11562.23	11479.52	11560.2	65070.0
2020-06-18 11:00:00	NQ	Futures	11559.91	11576.97	11520.29	11527.52	40452.0
2020-06-18 12:00:00	NQ	Futures	11526.95	11546.03	11511.04	11539.67	28556.0
2020-06-18 13:00:00	NQ	Futures	11539.96	11564.25	11531.86	11558.76	17984.0
2020-06-18 14:00:00	NQ	Futures	11558.47	11562.51	11507.28	11509.59	28450.0
2020-06-18 15:00:00	NQ	Futures	11509.31	11572.93	11491.67	11565.41	45298.0
2020-06-18 16:00:00	NQ	Futures	11565.41	11571.48	11541.12	11555.0	7456.0
2020-06-18 18:00:00	NQ	Futures	11549.79	11574.95	11543.72	11573.79	1988.0
2020-06-18 19:00:00	NQ	Futures	11573.79	11598.66	11573.79	11591.14	3083.0
2020-06-18 20:00:00	NQ	Futures	11589.7	11590.85	11553.55	11565.7	6042.0
2020-06-18 21:00:00	NQ	Futures	11565.41	11582.18	11546.03	11563.38	4995.0
2020-06-18 22:00:00	NQ	Futures	11562.51	11581.89	11557.31	11578.71	3568.0
2020-06-18 23:00:00	NQ	Futures	11579.58	11581.89	11563.96	11577.26	2034.0
2020-06-18 00:00:00	YM	Futures	28432.5	28508.5	28363.2	28490.9	4308.0
2020-06-18 01:00:00	YM	Futures	28492.0	28518.4	28388.5	28457.9	4874.0
2020-06-18 02:00:00	YM	Futures	28454.6	28666.0	28408.3	28575.7	7238.0
2020-06-18 03:00:00	YM	Futures	28582.3	28666.0	28505.2	28598.8	4865.0

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

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