PREVIEW / futures_1hour / 2020-02-05

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-05.parquet
  size:    62 KB
  rows:    1,900

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-02-05 00:00:00	ES	Futures	3571.9	3572.5	3565.1	3567.0	11881.0
2020-02-05 01:00:00	ES	Futures	3567.0	3571.7	3566.5	3569.8	10341.0
2020-02-05 02:00:00	ES	Futures	3569.5	3571.7	3567.0	3568.1	10528.0
2020-02-05 03:00:00	ES	Futures	3568.1	3597.9	3567.3	3593.1	117852.0
2020-02-05 04:00:00	ES	Futures	3593.1	3610.9	3590.9	3608.2	88056.0
2020-02-05 05:00:00	ES	Futures	3608.2	3610.1	3602.5	3604.2	50594.0
2020-02-05 06:00:00	ES	Futures	3603.9	3608.0	3598.5	3599.6	67855.0
2020-02-05 07:00:00	ES	Futures	3599.6	3605.0	3598.2	3600.1	40136.0
2020-02-05 08:00:00	ES	Futures	3600.4	3608.2	3599.8	3607.4	60065.0
2020-02-05 09:00:00	ES	Futures	3607.7	3608.8	3596.0	3604.2	247210.0
2020-02-05 10:00:00	ES	Futures	3603.9	3608.0	3589.8	3599.6	354644.0
2020-02-05 11:00:00	ES	Futures	3599.8	3604.4	3595.0	3604.2	175802.0
2020-02-05 12:00:00	ES	Futures	3604.4	3607.2	3602.8	3603.6	86165.0
2020-02-05 13:00:00	ES	Futures	3603.6	3607.2	3600.1	3605.3	91351.0
2020-02-05 14:00:00	ES	Futures	3605.3	3612.3	3601.7	3611.5	104799.0
2020-02-05 15:00:00	ES	Futures	3611.5	3616.1	3606.3	3613.4	273292.0
2020-02-05 16:00:00	ES	Futures	3613.4	3618.3	3609.9	3615.6	107783.0
2020-02-05 18:00:00	ES	Futures	3617.2	3619.9	3613.7	3614.5	12444.0
2020-02-05 19:00:00	ES	Futures	3614.2	3616.9	3612.3	3615.6	15807.0
2020-02-05 20:00:00	ES	Futures	3615.3	3628.0	3614.5	3621.5	40373.0
2020-02-05 21:00:00	ES	Futures	3621.8	3628.3	3621.5	3627.7	15927.0
2020-02-05 22:00:00	ES	Futures	3627.7	3630.5	3624.8	3627.2	12133.0
2020-02-05 23:00:00	ES	Futures	3627.2	3634.3	3625.6	3634.3	30091.0
2020-02-05 00:00:00	NQ	Futures	10809.01	10812.48	10781.54	10789.92	6860.0
2020-02-05 01:00:00	NQ	Futures	10789.92	10803.22	10787.32	10799.18	5406.0
2020-02-05 02:00:00	NQ	Futures	10799.18	10808.43	10791.08	10795.42	6524.0
2020-02-05 03:00:00	NQ	Futures	10795.99	10895.76	10791.95	10873.49	36705.0
2020-02-05 04:00:00	NQ	Futures	10872.92	10944.63	10862.5	10936.53	32292.0
2020-02-05 05:00:00	NQ	Futures	10936.53	10940.0	10910.51	10920.05	17030.0
2020-02-05 06:00:00	NQ	Futures	10919.76	10935.38	10896.05	10903.86	18951.0
2020-02-05 07:00:00	NQ	Futures	10903.57	10925.54	10898.94	10909.35	14046.0
2020-02-05 08:00:00	NQ	Futures	10909.64	10945.5	10906.75	10942.03	19370.0
2020-02-05 09:00:00	NQ	Futures	10941.45	10942.03	10841.11	10869.16	105699.0
2020-02-05 10:00:00	NQ	Futures	10869.16	10882.17	10777.78	10813.63	126045.0
2020-02-05 11:00:00	NQ	Futures	10813.35	10833.3	10789.05	10830.41	75313.0
2020-02-05 12:00:00	NQ	Futures	10830.12	10842.55	10817.1	10820.57	41660.0
2020-02-05 13:00:00	NQ	Futures	10820.86	10828.67	10797.44	10821.15	41741.0
2020-02-05 14:00:00	NQ	Futures	10821.15	10857.59	10805.83	10854.41	38857.0
2020-02-05 15:00:00	NQ	Futures	10854.99	10874.65	10823.18	10844.87	70003.0
2020-02-05 16:00:00	NQ	Futures	10844.87	10868.0	10833.88	10859.32	14273.0
2020-02-05 18:00:00	NQ	Futures	10861.35	10869.16	10848.91	10851.23	4475.0
2020-02-05 19:00:00	NQ	Futures	10850.94	10864.53	10844.0	10857.88	7365.0
2020-02-05 20:00:00	NQ	Futures	10857.59	10903.57	10854.12	10883.9	15106.0
2020-02-05 21:00:00	NQ	Futures	10884.19	10905.01	10884.19	10903.57	7044.0
2020-02-05 22:00:00	NQ	Futures	10903.86	10910.8	10891.42	10899.81	5409.0
2020-02-05 23:00:00	NQ	Futures	10899.81	10927.57	10893.45	10926.41	9588.0
2020-02-05 00:00:00	YM	Futures	31309.0	31316.6	31249.1	31267.6	2945.0
2020-02-05 01:00:00	YM	Futures	31267.6	31307.9	31262.1	31286.1	2100.0
2020-02-05 02:00:00	YM	Futures	31286.1	31303.5	31263.2	31267.6	2208.0
2020-02-05 03:00:00	YM	Futures	31268.7	31562.6	31260.0	31518.0	17481.0

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

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