PREVIEW / futures_1hour / 2020-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-14.parquet
  size:    57 KB
  rows:    1,825

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-09-14 00:00:00	ES	Futures	3768.39	3769.23	3765.59	3765.87	3501.0
2020-09-14 01:00:00	ES	Futures	3765.87	3774.55	3763.35	3770.91	6946.0
2020-09-14 02:00:00	ES	Futures	3771.19	3777.91	3769.23	3776.79	10509.0
2020-09-14 03:00:00	ES	Futures	3777.07	3780.72	3774.27	3775.67	19629.0
2020-09-14 04:00:00	ES	Futures	3775.95	3781.28	3766.43	3767.27	23520.0
2020-09-14 05:00:00	ES	Futures	3767.55	3771.47	3757.47	3760.27	22340.0
2020-09-14 06:00:00	ES	Futures	3760.27	3768.39	3758.59	3768.11	16569.0
2020-09-14 07:00:00	ES	Futures	3768.11	3772.31	3765.31	3765.87	13333.0
2020-09-14 08:00:00	ES	Futures	3766.15	3769.51	3762.51	3765.59	21482.0
2020-09-14 09:00:00	ES	Futures	3765.59	3786.04	3762.51	3784.92	185411.0
2020-09-14 10:00:00	ES	Futures	3785.2	3800.88	3782.68	3793.32	222435.0
2020-09-14 11:00:00	ES	Futures	3793.32	3799.48	3788.0	3794.44	106805.0
2020-09-14 12:00:00	ES	Futures	3794.44	3797.8	3788.28	3792.2	76912.0
2020-09-14 13:00:00	ES	Futures	3792.2	3795.28	3775.39	3784.64	115522.0
2020-09-14 14:00:00	ES	Futures	3784.64	3790.24	3773.15	3782.12	122376.0
2020-09-14 15:00:00	ES	Futures	3782.4	3794.72	3769.51	3779.03	236601.0
2020-09-14 16:00:00	ES	Futures	3779.32	3786.04	3772.87	3773.99	49913.0
2020-09-14 18:00:00	ES	Futures	3775.39	3784.36	3774.27	3783.8	5529.0
2020-09-14 19:00:00	ES	Futures	3784.08	3784.36	3776.79	3781.84	4609.0
2020-09-14 20:00:00	ES	Futures	3781.84	3783.52	3771.47	3774.83	9774.0
2020-09-14 21:00:00	ES	Futures	3774.83	3782.68	3772.03	3781.84	9686.0
2020-09-14 22:00:00	ES	Futures	3781.84	3785.48	3780.72	3783.24	6108.0
2020-09-14 23:00:00	ES	Futures	3783.52	3786.32	3782.96	3784.92	3691.0
2020-09-14 00:00:00	NQ	Futures	12981.8	12992.51	12969.65	12976.59	2513.0
2020-09-14 01:00:00	NQ	Futures	12976.88	13016.83	12960.09	13006.7	3920.0
2020-09-14 02:00:00	NQ	Futures	13006.99	13027.54	12998.88	13020.59	4276.0
2020-09-14 03:00:00	NQ	Futures	13020.01	13038.83	13008.43	13012.78	5355.0
2020-09-14 04:00:00	NQ	Futures	13012.78	13044.33	12958.65	12970.22	6955.0
2020-09-14 05:00:00	NQ	Futures	12970.8	12987.01	12934.04	12942.72	5438.0
2020-09-14 06:00:00	NQ	Futures	12943.59	13016.25	12942.44	13013.64	5565.0
2020-09-14 07:00:00	NQ	Futures	13012.78	13012.78	12957.49	12957.78	5678.0
2020-09-14 08:00:00	NQ	Futures	12958.65	12987.88	12938.96	12960.09	13675.0
2020-09-14 09:00:00	NQ	Futures	12959.8	13089.2	12952.28	13066.62	64168.0
2020-09-14 10:00:00	NQ	Futures	13067.2	13141.01	13048.09	13120.17	54966.0
2020-09-14 11:00:00	NQ	Futures	13119.88	13132.62	13070.38	13112.93	43271.0
2020-09-14 12:00:00	NQ	Futures	13112.93	13133.48	13032.75	13054.75	37249.0
2020-09-14 13:00:00	NQ	Futures	13054.75	13071.25	12938.09	13017.12	50616.0
2020-09-14 14:00:00	NQ	Futures	13016.83	13059.09	12983.83	13024.93	47792.0
2020-09-14 15:00:00	NQ	Futures	13025.51	13097.3	12995.99	13039.41	57570.0
2020-09-14 16:00:00	NQ	Futures	13039.7	13066.33	13028.12	13038.25	8486.0
2020-09-14 18:00:00	NQ	Futures	13042.88	13088.91	13042.88	13083.99	2536.0
2020-09-14 19:00:00	NQ	Futures	13083.99	13085.14	13048.09	13066.04	1899.0
2020-09-14 20:00:00	NQ	Futures	13066.62	13077.33	13006.41	13025.22	4500.0
2020-09-14 21:00:00	NQ	Futures	13026.96	13057.93	13006.7	13055.33	4122.0
2020-09-14 22:00:00	NQ	Futures	13055.91	13070.38	13051.56	13065.17	2871.0
2020-09-14 23:00:00	NQ	Futures	13066.04	13077.91	13063.43	13070.96	1383.0
2020-09-14 00:00:00	YM	Futures	30720.7	30724.1	30696.4	30698.6	728.0
2020-09-14 01:00:00	YM	Futures	30700.8	30765.0	30682.0	30736.2	1211.0
2020-09-14 02:00:00	YM	Futures	30736.2	30790.4	30718.5	30780.4	1591.0
2020-09-14 03:00:00	YM	Futures	30780.4	30813.6	30748.4	30752.8	2998.0

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

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