PREVIEW / futures_1hour / 2020-06-16

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-16.parquet
  size:    60 KB
  rows:    1,835

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-16 00:00:00	ES	Futures	3469.88	3471.56	3462.62	3466.25	9956.0
2020-06-16 01:00:00	ES	Futures	3466.53	3476.86	3465.41	3465.69	15222.0
2020-06-16 02:00:00	ES	Futures	3465.97	3465.97	3446.42	3451.45	39028.0
2020-06-16 03:00:00	ES	Futures	3451.73	3463.46	3442.51	3448.1	47117.0
2020-06-16 04:00:00	ES	Futures	3448.1	3460.39	3440.28	3458.43	40385.0
2020-06-16 05:00:00	ES	Futures	3458.71	3462.34	3453.4	3458.99	29607.0
2020-06-16 06:00:00	ES	Futures	3458.99	3470.72	3455.36	3465.41	34426.0
2020-06-16 07:00:00	ES	Futures	3465.41	3469.88	3458.15	3469.32	30844.0
2020-06-16 08:00:00	ES	Futures	3469.04	3525.45	3468.48	3517.07	133197.0
2020-06-16 09:00:00	ES	Futures	3516.79	3519.31	3489.15	3497.53	223626.0
2020-06-16 10:00:00	ES	Futures	3497.8	3510.37	3436.37	3441.12	379676.0
2020-06-16 11:00:00	ES	Futures	3440.56	3487.75	3421.29	3472.39	350486.0
2020-06-16 12:00:00	ES	Futures	3472.39	3493.62	3460.11	3486.08	161216.0
2020-06-16 13:00:00	ES	Futures	3486.36	3493.34	3471.0	3477.7	114346.0
2020-06-16 14:00:00	ES	Futures	3477.7	3496.13	3471.28	3481.89	176217.0
2020-06-16 15:00:00	ES	Futures	3481.89	3484.68	3453.68	3480.21	304495.0
2020-06-16 16:00:00	ES	Futures	3480.21	3484.68	3474.91	3480.49	72184.0
2020-06-16 18:00:00	ES	Futures	3475.74	3479.65	3462.06	3478.54	15567.0
2020-06-16 19:00:00	ES	Futures	3478.54	3492.5	3478.26	3490.54	11618.0
2020-06-16 20:00:00	ES	Futures	3490.26	3490.82	3469.88	3484.12	24994.0
2020-06-16 21:00:00	ES	Futures	3484.4	3489.71	3466.81	3474.63	20286.0
2020-06-16 22:00:00	ES	Futures	3474.91	3479.65	3458.71	3467.65	21742.0
2020-06-16 23:00:00	ES	Futures	3467.93	3475.19	3464.3	3472.67	10407.0
2020-06-16 00:00:00	NQ	Futures	11472.0	11474.6	11443.37	11452.05	2586.0
2020-06-16 01:00:00	NQ	Futures	11452.92	11485.01	11452.92	11455.23	2290.0
2020-06-16 02:00:00	NQ	Futures	11455.52	11456.68	11402.6	11419.95	6083.0
2020-06-16 03:00:00	NQ	Futures	11421.11	11464.48	11394.79	11412.72	8744.0
2020-06-16 04:00:00	NQ	Futures	11411.85	11452.63	11395.95	11449.16	6224.0
2020-06-16 05:00:00	NQ	Futures	11450.02	11462.46	11434.41	11449.45	3768.0
2020-06-16 06:00:00	NQ	Futures	11449.45	11482.7	11439.04	11463.33	3448.0
2020-06-16 07:00:00	NQ	Futures	11463.62	11478.94	11436.43	11476.63	4271.0
2020-06-16 08:00:00	NQ	Futures	11475.18	11565.98	11472.87	11554.71	23289.0
2020-06-16 09:00:00	NQ	Futures	11554.42	11563.38	11498.32	11538.22	60288.0
2020-06-16 10:00:00	NQ	Futures	11538.8	11569.17	11362.4	11371.37	93414.0
2020-06-16 11:00:00	NQ	Futures	11370.79	11517.4	11320.18	11482.41	100292.0
2020-06-16 12:00:00	NQ	Futures	11483.28	11528.1	11432.96	11509.02	56466.0
2020-06-16 13:00:00	NQ	Futures	11508.73	11528.97	11467.66	11487.04	32148.0
2020-06-16 14:00:00	NQ	Futures	11487.33	11533.89	11458.41	11484.15	45007.0
2020-06-16 15:00:00	NQ	Futures	11484.15	11503.52	11409.54	11500.05	53868.0
2020-06-16 16:00:00	NQ	Futures	11501.21	11525.79	11493.4	11520.01	9276.0
2020-06-16 18:00:00	NQ	Futures	11511.04	11522.03	11471.71	11519.43	3249.0
2020-06-16 19:00:00	NQ	Futures	11518.56	11554.13	11518.56	11548.63	3565.0
2020-06-16 20:00:00	NQ	Futures	11548.63	11550.37	11488.77	11534.75	5428.0
2020-06-16 21:00:00	NQ	Futures	11536.49	11548.06	11482.12	11507.28	4078.0
2020-06-16 22:00:00	NQ	Futures	11506.41	11525.5	11469.11	11497.16	3804.0
2020-06-16 23:00:00	NQ	Futures	11497.74	11516.54	11487.33	11508.44	2005.0
2020-06-16 00:00:00	YM	Futures	28806.9	28822.3	28753.0	28783.8	3049.0
2020-06-16 01:00:00	YM	Futures	28787.1	28889.5	28781.6	28786.0	3913.0
2020-06-16 02:00:00	YM	Futures	28787.1	28791.5	28588.9	28644.0	7942.0
2020-06-16 03:00:00	YM	Futures	28644.0	28742.0	28536.0	28588.9	9217.0

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

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