PREVIEW / futures_1hour / 2020-01-14

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-14.parquet
  size:    58 KB
  rows:    1,859

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-01-14 00:00:00	ES	Futures	3565.4	3567.0	3563.5	3564.3	5661.0
2020-01-14 01:00:00	ES	Futures	3564.3	3566.5	3563.8	3566.0	4936.0
2020-01-14 02:00:00	ES	Futures	3566.0	3566.8	3561.1	3561.4	10477.0
2020-01-14 03:00:00	ES	Futures	3561.4	3561.9	3550.2	3558.6	48554.0
2020-01-14 04:00:00	ES	Futures	3558.6	3568.9	3557.6	3567.3	32126.0
2020-01-14 05:00:00	ES	Futures	3567.0	3568.1	3559.2	3562.2	23661.0
2020-01-14 06:00:00	ES	Futures	3561.9	3563.5	3556.7	3563.0	25312.0
2020-01-14 07:00:00	ES	Futures	3563.0	3565.1	3561.6	3563.0	17767.0
2020-01-14 08:00:00	ES	Futures	3562.7	3565.7	3560.0	3564.6	36734.0
2020-01-14 09:00:00	ES	Futures	3564.6	3564.9	3554.6	3555.7	229691.0
2020-01-14 10:00:00	ES	Futures	3555.7	3562.7	3554.3	3560.3	190587.0
2020-01-14 11:00:00	ES	Futures	3560.0	3564.9	3559.5	3564.9	112565.0
2020-01-14 12:00:00	ES	Futures	3564.9	3569.5	3563.8	3568.1	76543.0
2020-01-14 13:00:00	ES	Futures	3567.9	3571.7	3558.1	3560.8	255730.0
2020-01-14 14:00:00	ES	Futures	3560.8	3566.0	3552.4	3561.1	213651.0
2020-01-14 15:00:00	ES	Futures	3560.8	3562.4	3554.0	3558.9	237442.0
2020-01-14 16:00:00	ES	Futures	3558.6	3564.6	3558.4	3563.8	56060.0
2020-01-14 18:00:00	ES	Futures	3563.8	3564.3	3553.8	3554.3	17490.0
2020-01-14 19:00:00	ES	Futures	3554.3	3558.1	3553.0	3556.2	11930.0
2020-01-14 20:00:00	ES	Futures	3556.2	3562.2	3555.7	3559.7	13002.0
2020-01-14 21:00:00	ES	Futures	3559.5	3560.3	3554.0	3555.1	12692.0
2020-01-14 22:00:00	ES	Futures	3555.1	3556.2	3553.5	3555.9	6915.0
2020-01-14 23:00:00	ES	Futures	3555.7	3556.5	3554.6	3556.2	4456.0
2020-01-14 00:00:00	NQ	Futures	10510.29	10518.39	10504.8	10507.69	3727.0
2020-01-14 01:00:00	NQ	Futures	10507.4	10513.76	10503.35	10512.61	2939.0
2020-01-14 02:00:00	NQ	Futures	10512.32	10514.92	10493.23	10494.39	6479.0
2020-01-14 03:00:00	NQ	Futures	10494.1	10494.1	10457.37	10489.18	19994.0
2020-01-14 04:00:00	NQ	Futures	10488.89	10519.55	10486.29	10513.47	12949.0
2020-01-14 05:00:00	NQ	Futures	10513.76	10522.15	10485.13	10498.15	9580.0
2020-01-14 06:00:00	NQ	Futures	10497.86	10504.8	10480.8	10495.25	12761.0
2020-01-14 07:00:00	NQ	Futures	10494.97	10507.69	10490.34	10501.33	9583.0
2020-01-14 08:00:00	NQ	Futures	10501.33	10515.21	10496.99	10510.87	14265.0
2020-01-14 09:00:00	NQ	Futures	10511.16	10514.34	10452.17	10457.95	78478.0
2020-01-14 10:00:00	NQ	Futures	10457.66	10502.48	10451.01	10479.64	73523.0
2020-01-14 11:00:00	NQ	Futures	10479.64	10499.3	10475.01	10498.72	38279.0
2020-01-14 12:00:00	NQ	Futures	10499.01	10513.76	10494.68	10502.77	25023.0
2020-01-14 13:00:00	NQ	Futures	10503.06	10520.12	10471.54	10475.59	68155.0
2020-01-14 14:00:00	NQ	Futures	10475.59	10500.46	10450.72	10480.22	68412.0
2020-01-14 15:00:00	NQ	Futures	10479.93	10486.0	10452.75	10468.65	61883.0
2020-01-14 16:00:00	NQ	Futures	10468.65	10484.56	10466.05	10483.11	9825.0
2020-01-14 18:00:00	NQ	Futures	10481.95	10484.56	10444.36	10445.81	7546.0
2020-01-14 19:00:00	NQ	Futures	10446.38	10461.71	10440.02	10451.88	7445.0
2020-01-14 20:00:00	NQ	Futures	10451.59	10476.17	10451.01	10466.63	6236.0
2020-01-14 21:00:00	NQ	Futures	10466.34	10469.23	10444.65	10449.57	6520.0
2020-01-14 22:00:00	NQ	Futures	10449.28	10455.35	10442.91	10452.46	4072.0
2020-01-14 23:00:00	NQ	Futures	10452.17	10456.51	10448.41	10454.77	3249.0
2020-01-14 00:00:00	YM	Futures	31433.1	31446.1	31416.8	31423.3	1235.0
2020-01-14 01:00:00	YM	Futures	31423.3	31442.9	31417.8	31441.8	1364.0
2020-01-14 02:00:00	YM	Futures	31440.7	31446.1	31393.9	31397.2	2362.0
2020-01-14 03:00:00	YM	Futures	31397.2	31400.4	31287.2	31362.3	11275.0

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

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