PREVIEW / futures_1hour / 2021-03-17

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-17.parquet
  size:    64 KB
  rows:    1,927

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-17 00:00:00	ES	Futures	4439.32	4439.88	4437.35	4439.6	2625.0
2021-03-17 01:00:00	ES	Futures	4439.6	4444.37	4437.07	4443.25	4977.0
2021-03-17 02:00:00	ES	Futures	4443.53	4444.93	4439.88	4442.13	4489.0
2021-03-17 03:00:00	ES	Futures	4442.13	4443.53	4437.91	4440.44	4539.0
2021-03-17 04:00:00	ES	Futures	4440.44	4444.09	4437.63	4440.44	11130.0
2021-03-17 05:00:00	ES	Futures	4440.72	4442.97	4437.91	4439.6	9199.0
2021-03-17 06:00:00	ES	Futures	4439.6	4443.25	4437.63	4437.91	8812.0
2021-03-17 07:00:00	ES	Futures	4437.91	4438.19	4423.02	4425.83	30624.0
2021-03-17 08:00:00	ES	Futures	4425.55	4429.76	4422.46	4428.36	40551.0
2021-03-17 09:00:00	ES	Futures	4428.36	4429.2	4417.12	4425.83	173483.0
2021-03-17 10:00:00	ES	Futures	4425.83	4430.32	4412.62	4415.15	237389.0
2021-03-17 11:00:00	ES	Futures	4414.87	4423.86	4411.22	4421.05	140366.0
2021-03-17 12:00:00	ES	Futures	4421.05	4427.23	4417.12	4418.24	106603.0
2021-03-17 13:00:00	ES	Futures	4418.24	4423.3	4415.15	4418.52	90777.0
2021-03-17 14:00:00	ES	Futures	4418.8	4461.79	4418.8	4460.11	387537.0
2021-03-17 15:00:00	ES	Futures	4460.11	4465.73	4446.06	4455.05	308764.0
2021-03-17 16:00:00	ES	Futures	4455.05	4457.86	4450.84	4451.96	56324.0
2021-03-17 18:00:00	ES	Futures	4452.8	4461.23	4452.24	4457.58	9315.0
2021-03-17 19:00:00	ES	Futures	4457.86	4465.73	4455.61	4464.6	7816.0
2021-03-17 20:00:00	ES	Futures	4464.6	4470.22	4463.76	4469.1	12204.0
2021-03-17 21:00:00	ES	Futures	4469.1	4471.35	4466.29	4469.94	11004.0
2021-03-17 22:00:00	ES	Futures	4469.94	4470.5	4464.04	4467.41	8238.0
2021-03-17 23:00:00	ES	Futures	4467.41	4467.41	4455.05	4455.61	13455.0
2021-03-17 00:00:00	NQ	Futures	15194.16	15197.63	15183.16	15193.0	1828.0
2021-03-17 01:00:00	NQ	Futures	15192.42	15214.14	15175.05	15208.92	4350.0
2021-03-17 02:00:00	NQ	Futures	15209.21	15217.32	15183.16	15195.03	3453.0
2021-03-17 03:00:00	NQ	Futures	15195.61	15206.9	15182.87	15191.84	4507.0
2021-03-17 04:00:00	NQ	Futures	15191.84	15207.19	15178.82	15196.48	5370.0
2021-03-17 05:00:00	NQ	Futures	15197.05	15200.82	15167.24	15170.42	4790.0
2021-03-17 06:00:00	NQ	Futures	15170.71	15189.24	15151.03	15155.66	5464.0
2021-03-17 07:00:00	NQ	Futures	15155.95	15158.84	15026.83	15042.75	26341.0
2021-03-17 08:00:00	NQ	Futures	15042.17	15066.2	15016.12	15054.33	20864.0
2021-03-17 09:00:00	NQ	Futures	15054.91	15103.84	14977.62	15093.71	78993.0
2021-03-17 10:00:00	NQ	Futures	15094.28	15138.58	15041.89	15066.2	82234.0
2021-03-17 11:00:00	NQ	Futures	15065.91	15080.1	14993.54	15018.73	58501.0
2021-03-17 12:00:00	NQ	Futures	15018.44	15077.2	14982.83	15010.33	50552.0
2021-03-17 13:00:00	NQ	Futures	15010.62	15071.7	14996.72	15049.12	31761.0
2021-03-17 14:00:00	NQ	Futures	15048.83	15328.78	15048.83	15327.04	108330.0
2021-03-17 15:00:00	NQ	Futures	15326.17	15367.57	15233.82	15277.25	74561.0
2021-03-17 16:00:00	NQ	Futures	15277.25	15282.75	15245.11	15250.61	9749.0
2021-03-17 18:00:00	NQ	Futures	15270.3	15297.8	15257.27	15273.19	4496.0
2021-03-17 19:00:00	NQ	Futures	15273.77	15316.04	15267.69	15311.41	3854.0
2021-03-17 20:00:00	NQ	Futures	15311.7	15354.25	15309.38	15350.78	7047.0
2021-03-17 21:00:00	NQ	Futures	15351.36	15362.94	15322.7	15336.01	5398.0
2021-03-17 22:00:00	NQ	Futures	15335.72	15338.62	15307.93	15325.3	4755.0
2021-03-17 23:00:00	NQ	Futures	15325.88	15328.2	15246.85	15261.9	8188.0
2021-03-17 00:00:00	YM	Futures	36416.3	36426.3	36406.3	36426.3	413.0
2021-03-17 01:00:00	YM	Futures	36425.2	36466.4	36415.2	36459.7	1714.0
2021-03-17 02:00:00	YM	Futures	36463.1	36464.2	36439.7	36459.7	1007.0
2021-03-17 03:00:00	YM	Futures	36459.7	36465.3	36417.4	36439.7	1504.0

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

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