PREVIEW / futures_1hour / 2021-03-19

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-19.parquet
  size:    53 KB
  rows:    1,544

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
2021-03-19 00:00:00	ES	Futures	4393.24	4399.14	4391.27	4398.57	7361.0
2021-03-19 01:00:00	ES	Futures	4398.29	4400.26	4391.27	4395.77	7873.0
2021-03-19 02:00:00	ES	Futures	4395.77	4396.61	4381.44	4394.08	17408.0
2021-03-19 03:00:00	ES	Futures	4394.08	4403.35	4393.24	4401.67	17183.0
2021-03-19 04:00:00	ES	Futures	4401.67	4409.53	4400.54	4407.0	32436.0
2021-03-19 05:00:00	ES	Futures	4407.0	4408.13	4402.51	4403.35	15655.0
2021-03-19 06:00:00	ES	Futures	4403.35	4407.0	4396.89	4405.6	23325.0
2021-03-19 07:00:00	ES	Futures	4405.32	4405.6	4392.39	4399.14	26609.0
2021-03-19 08:00:00	ES	Futures	4399.14	4404.19	4396.89	4399.98	40749.0
2021-03-19 09:00:00	ES	Futures	4399.7	4399.98	4357.55	4370.48	403079.0
2021-03-19 10:00:00	ES	Futures	4370.48	4387.06	4355.02	4385.93	309904.0
2021-03-19 11:00:00	ES	Futures	4385.65	4397.45	4368.51	4393.52	186872.0
2021-03-19 12:00:00	ES	Futures	4393.52	4401.1	4390.43	4399.14	134947.0
2021-03-19 13:00:00	ES	Futures	4398.86	4402.79	4390.15	4399.7	113387.0
2021-03-19 14:00:00	ES	Futures	4399.98	4404.48	4389.58	4403.63	125821.0
2021-03-19 15:00:00	ES	Futures	4403.63	4405.04	4379.75	4380.87	325413.0
2021-03-19 16:00:00	ES	Futures	4380.59	4385.09	4378.35	4379.47	106035.0
2021-03-19 00:00:00	NQ	Futures	14791.47	14823.61	14785.68	14817.82	4862.0
2021-03-19 01:00:00	NQ	Futures	14817.82	14830.26	14779.6	14793.79	6226.0
2021-03-19 02:00:00	NQ	Futures	14794.08	14844.74	14721.99	14825.92	15562.0
2021-03-19 03:00:00	NQ	Futures	14826.5	14899.16	14820.42	14890.77	13688.0
2021-03-19 04:00:00	NQ	Futures	14890.48	14935.93	14882.66	14911.61	17514.0
2021-03-19 05:00:00	NQ	Futures	14912.48	14927.53	14892.22	14899.16	7641.0
2021-03-19 06:00:00	NQ	Futures	14899.16	14902.06	14860.66	14891.93	9834.0
2021-03-19 07:00:00	NQ	Futures	14892.22	14897.14	14841.84	14877.74	10133.0
2021-03-19 08:00:00	NQ	Futures	14877.16	14911.61	14863.27	14870.79	16290.0
2021-03-19 09:00:00	NQ	Futures	14870.5	14871.95	14735.02	14792.92	115630.0
2021-03-19 10:00:00	NQ	Futures	14792.34	14871.66	14685.23	14860.66	105674.0
2021-03-19 11:00:00	NQ	Futures	14860.66	14891.64	14772.94	14872.53	70632.0
2021-03-19 12:00:00	NQ	Futures	14872.82	14920.01	14860.66	14913.35	46761.0
2021-03-19 13:00:00	NQ	Futures	14913.35	14927.82	14855.16	14902.64	40230.0
2021-03-19 14:00:00	NQ	Futures	14902.64	14915.67	14851.4	14911.03	38995.0
2021-03-19 15:00:00	NQ	Futures	14911.03	14916.82	14849.66	14865.58	58593.0
2021-03-19 16:00:00	NQ	Futures	14866.45	14877.16	14848.79	14851.69	13882.0
2021-03-19 00:00:00	YM	Futures	36541.0	36577.8	36524.3	36574.5	1507.0
2021-03-19 01:00:00	YM	Futures	36575.6	36596.7	36536.6	36566.7	2090.0
2021-03-19 02:00:00	YM	Futures	36568.9	36568.9	36482.0	36532.1	3981.0
2021-03-19 03:00:00	YM	Futures	36533.2	36587.8	36523.2	36527.7	4243.0
2021-03-19 04:00:00	YM	Futures	36527.7	36591.2	36525.4	36568.9	6960.0
2021-03-19 05:00:00	YM	Futures	36571.1	36576.7	36532.1	36544.4	2587.0
2021-03-19 06:00:00	YM	Futures	36545.5	36587.8	36502.1	36576.7	3698.0
2021-03-19 07:00:00	YM	Futures	36576.7	36581.1	36466.4	36516.5	4353.0
2021-03-19 08:00:00	YM	Futures	36517.6	36543.3	36498.7	36529.9	4665.0
2021-03-19 09:00:00	YM	Futures	36529.9	36529.9	36088.8	36165.7	46875.0
2021-03-19 10:00:00	YM	Futures	36164.6	36282.6	36097.7	36270.4	35320.0
2021-03-19 11:00:00	YM	Futures	36270.4	36355.0	36142.3	36331.6	19333.0
2021-03-19 12:00:00	YM	Futures	36331.6	36361.7	36279.3	36323.8	13224.0
2021-03-19 13:00:00	YM	Futures	36323.8	36351.7	36282.6	36331.6	9671.0
2021-03-19 14:00:00	YM	Futures	36332.8	36381.8	36287.1	36379.5	10277.0
2021-03-19 15:00:00	YM	Futures	36378.4	36390.7	36181.3	36189.1	19283.0

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

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