PREVIEW / futures_1hour / 2020-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-27.parquet
  size:    61 KB
  rows:    1,915

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-27 00:00:00	ES	Futures	3536.2	3537.2	3532.6	3532.9	10932.0
2020-01-27 01:00:00	ES	Futures	3533.2	3536.2	3531.8	3534.3	10277.0
2020-01-27 02:00:00	ES	Futures	3534.3	3537.2	3531.8	3534.8	22350.0
2020-01-27 03:00:00	ES	Futures	3534.8	3540.8	3530.5	3535.6	49675.0
2020-01-27 04:00:00	ES	Futures	3535.9	3536.2	3522.1	3526.4	55650.0
2020-01-27 05:00:00	ES	Futures	3526.1	3526.1	3511.2	3511.2	67121.0
2020-01-27 06:00:00	ES	Futures	3511.2	3521.2	3507.4	3518.0	64021.0
2020-01-27 07:00:00	ES	Futures	3518.3	3526.1	3516.6	3518.0	62890.0
2020-01-27 08:00:00	ES	Futures	3518.0	3519.4	3512.8	3515.3	68115.0
2020-01-27 09:00:00	ES	Futures	3515.0	3526.7	3504.4	3524.2	404439.0
2020-01-27 10:00:00	ES	Futures	3524.2	3525.9	3511.5	3517.5	346641.0
2020-01-27 11:00:00	ES	Futures	3517.5	3523.7	3511.5	3521.2	240169.0
2020-01-27 12:00:00	ES	Futures	3521.0	3531.3	3518.8	3526.4	176724.0
2020-01-27 13:00:00	ES	Futures	3526.7	3530.7	3523.7	3525.6	125910.0
2020-01-27 14:00:00	ES	Futures	3525.9	3529.6	3517.7	3521.2	153415.0
2020-01-27 15:00:00	ES	Futures	3521.5	3525.0	3513.1	3513.4	349109.0
2020-01-27 16:00:00	ES	Futures	3513.4	3515.0	3509.3	3512.8	99569.0
2020-01-27 18:00:00	ES	Futures	3511.5	3521.8	3510.7	3519.6	16925.0
2020-01-27 19:00:00	ES	Futures	3519.9	3522.3	3516.9	3518.3	19981.0
2020-01-27 20:00:00	ES	Futures	3518.3	3526.9	3517.7	3522.9	24908.0
2020-01-27 21:00:00	ES	Futures	3522.9	3523.7	3518.0	3522.6	15783.0
2020-01-27 22:00:00	ES	Futures	3522.9	3522.9	3519.6	3522.6	6911.0
2020-01-27 23:00:00	ES	Futures	3522.3	3529.4	3522.1	3528.3	16827.0
2020-01-27 00:00:00	NQ	Futures	10444.07	10451.01	10431.35	10438.29	7426.0
2020-01-27 01:00:00	NQ	Futures	10437.71	10448.41	10432.79	10445.52	5719.0
2020-01-27 02:00:00	NQ	Futures	10445.52	10459.11	10435.4	10447.25	9498.0
2020-01-27 03:00:00	NQ	Futures	10447.25	10472.7	10434.82	10455.93	17905.0
2020-01-27 04:00:00	NQ	Futures	10456.22	10456.79	10401.27	10415.73	21134.0
2020-01-27 05:00:00	NQ	Futures	10415.44	10415.44	10360.21	10362.81	27757.0
2020-01-27 06:00:00	NQ	Futures	10363.1	10395.78	10343.73	10379.59	26039.0
2020-01-27 07:00:00	NQ	Futures	10379.87	10408.79	10377.27	10385.66	21787.0
2020-01-27 08:00:00	NQ	Futures	10385.95	10397.8	10373.22	10383.92	24044.0
2020-01-27 09:00:00	NQ	Futures	10383.34	10399.25	10324.06	10391.73	110306.0
2020-01-27 10:00:00	NQ	Futures	10391.44	10403.59	10347.78	10367.73	94975.0
2020-01-27 11:00:00	NQ	Futures	10367.44	10390.28	10345.17	10383.34	77112.0
2020-01-27 12:00:00	NQ	Futures	10383.06	10423.25	10370.91	10405.32	66939.0
2020-01-27 13:00:00	NQ	Futures	10405.32	10420.07	10394.91	10404.45	41798.0
2020-01-27 14:00:00	NQ	Futures	10404.45	10422.38	10370.04	10384.5	54140.0
2020-01-27 15:00:00	NQ	Futures	10384.21	10396.07	10357.61	10365.13	74458.0
2020-01-27 16:00:00	NQ	Futures	10364.84	10369.18	10352.11	10364.26	14461.0
2020-01-27 18:00:00	NQ	Futures	10355.29	10392.89	10355.29	10385.37	6210.0
2020-01-27 19:00:00	NQ	Futures	10385.95	10393.47	10369.46	10374.38	7028.0
2020-01-27 20:00:00	NQ	Futures	10374.67	10409.66	10371.78	10396.36	11556.0
2020-01-27 21:00:00	NQ	Futures	10396.65	10399.25	10380.45	10395.78	8750.0
2020-01-27 22:00:00	NQ	Futures	10395.78	10396.94	10387.1	10396.65	3642.0
2020-01-27 23:00:00	NQ	Futures	10396.65	10425.56	10395.49	10419.78	7664.0
2020-01-27 00:00:00	YM	Futures	31218.6	31231.7	31189.2	31193.6	3244.0
2020-01-27 01:00:00	YM	Futures	31193.6	31220.8	31183.8	31203.4	2855.0
2020-01-27 02:00:00	YM	Futures	31203.4	31226.2	31171.8	31191.4	5785.0
2020-01-27 03:00:00	YM	Futures	31192.5	31240.4	31152.2	31187.0	11193.0

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

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