PREVIEW / futures_1hour / 2020-01-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	3548.3	3549.7	3548.1	3548.6	2742.0
2020-01-13 01:00:00	ES	Futures	3548.9	3550.0	3548.1	3548.3	3314.0
2020-01-13 02:00:00	ES	Futures	3548.3	3549.7	3547.3	3547.8	5604.0
2020-01-13 03:00:00	ES	Futures	3547.8	3551.9	3547.8	3551.1	16550.0
2020-01-13 04:00:00	ES	Futures	3551.1	3553.5	3549.2	3553.2	17169.0
2020-01-13 05:00:00	ES	Futures	3553.2	3553.5	3551.3	3553.2	9255.0
2020-01-13 06:00:00	ES	Futures	3553.0	3553.2	3546.2	3546.4	15314.0
2020-01-13 07:00:00	ES	Futures	3546.4	3550.5	3545.9	3549.2	16754.0
2020-01-13 08:00:00	ES	Futures	3549.2	3552.7	3548.1	3549.4	21017.0
2020-01-13 09:00:00	ES	Futures	3549.4	3551.1	3542.4	3550.5	165829.0
2020-01-13 10:00:00	ES	Futures	3550.2	3553.2	3546.4	3552.4	125352.0
2020-01-13 11:00:00	ES	Futures	3552.7	3557.3	3551.3	3557.3	130021.0
2020-01-13 12:00:00	ES	Futures	3557.3	3560.3	3557.0	3557.6	77425.0
2020-01-13 13:00:00	ES	Futures	3557.8	3559.5	3556.2	3557.0	50081.0
2020-01-13 14:00:00	ES	Futures	3557.0	3560.8	3555.7	3560.3	58438.0
2020-01-13 15:00:00	ES	Futures	3560.3	3564.9	3558.1	3564.6	140803.0
2020-01-13 16:00:00	ES	Futures	3564.6	3567.3	3563.5	3565.1	66147.0
2020-01-13 18:00:00	ES	Futures	3565.4	3570.8	3564.9	3570.6	11792.0
2020-01-13 19:00:00	ES	Futures	3570.6	3573.5	3569.8	3571.4	15240.0
2020-01-13 20:00:00	ES	Futures	3571.4	3571.9	3568.7	3569.2	11670.0
2020-01-13 21:00:00	ES	Futures	3569.5	3570.3	3567.6	3567.6	7451.0
2020-01-13 22:00:00	ES	Futures	3567.6	3567.9	3563.5	3565.1	10646.0
2020-01-13 23:00:00	ES	Futures	3565.1	3566.2	3564.6	3565.4	4096.0
2020-01-13 00:00:00	NQ	Futures	10421.8	10429.9	10421.23	10425.56	2151.0
2020-01-13 01:00:00	NQ	Futures	10425.85	10430.19	10419.2	10420.36	3189.0
2020-01-13 02:00:00	NQ	Futures	10420.36	10426.14	10417.18	10420.65	3001.0
2020-01-13 03:00:00	NQ	Futures	10420.65	10436.26	10420.36	10430.19	9370.0
2020-01-13 04:00:00	NQ	Futures	10430.19	10440.02	10424.12	10439.73	9740.0
2020-01-13 05:00:00	NQ	Futures	10440.02	10441.76	10433.37	10439.44	5386.0
2020-01-13 06:00:00	NQ	Futures	10440.02	10440.02	10418.62	10419.2	6635.0
2020-01-13 07:00:00	NQ	Futures	10419.49	10429.03	10417.47	10424.99	6941.0
2020-01-13 08:00:00	NQ	Futures	10424.99	10438.58	10424.12	10428.46	10267.0
2020-01-13 09:00:00	NQ	Futures	10428.74	10453.9	10414.58	10448.41	70786.0
2020-01-13 10:00:00	NQ	Futures	10448.7	10454.77	10433.08	10451.01	54776.0
2020-01-13 11:00:00	NQ	Futures	10451.3	10478.19	10446.1	10476.46	53105.0
2020-01-13 12:00:00	NQ	Futures	10476.46	10489.76	10476.46	10484.27	32376.0
2020-01-13 13:00:00	NQ	Futures	10484.27	10494.1	10481.09	10485.71	18367.0
2020-01-13 14:00:00	NQ	Futures	10485.71	10499.59	10481.37	10493.52	22588.0
2020-01-13 15:00:00	NQ	Futures	10493.52	10510.58	10485.71	10508.85	31194.0
2020-01-13 16:00:00	NQ	Futures	10508.85	10520.7	10503.93	10514.63	11158.0
2020-01-13 18:00:00	NQ	Futures	10511.74	10534.87	10511.45	10531.69	5916.0
2020-01-13 19:00:00	NQ	Futures	10531.69	10542.97	10529.67	10535.74	7032.0
2020-01-13 20:00:00	NQ	Futures	10535.74	10537.18	10523.59	10529.09	5904.0
2020-01-13 21:00:00	NQ	Futures	10529.09	10531.69	10520.41	10522.15	4820.0
2020-01-13 22:00:00	NQ	Futures	10522.15	10523.3	10501.91	10511.16	7568.0
2020-01-13 23:00:00	NQ	Futures	10510.87	10513.18	10506.24	10510.29	2896.0
2020-01-13 00:00:00	YM	Futures	31411.3	31428.7	31411.3	31421.1	721.0
2020-01-13 01:00:00	YM	Futures	31422.2	31432.0	31418.9	31420.0	874.0
2020-01-13 02:00:00	YM	Futures	31420.0	31432.0	31410.2	31415.7	1536.0
2020-01-13 03:00:00	YM	Futures	31417.8	31457.0	31412.4	31442.9	3838.0

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

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