PREVIEW / futures_1hour / 2021-03-08

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-08.parquet
  size:    65 KB
  rows:    1,950

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-08 00:00:00	ES	Futures	4297.84	4302.9	4292.23	4298.41	14175.0
2021-03-08 01:00:00	ES	Futures	4298.13	4305.14	4293.35	4295.32	12689.0
2021-03-08 02:00:00	ES	Futures	4295.32	4301.77	4282.13	4285.78	23968.0
2021-03-08 03:00:00	ES	Futures	4285.78	4286.9	4271.18	4283.25	42634.0
2021-03-08 04:00:00	ES	Futures	4283.25	4284.37	4261.92	4275.39	34311.0
2021-03-08 05:00:00	ES	Futures	4275.39	4285.5	4273.43	4282.69	21859.0
2021-03-08 06:00:00	ES	Futures	4282.69	4289.71	4279.88	4289.14	21286.0
2021-03-08 07:00:00	ES	Futures	4289.14	4293.63	4277.36	4283.53	36877.0
2021-03-08 08:00:00	ES	Futures	4283.81	4314.68	4279.88	4313.0	72976.0
2021-03-08 09:00:00	ES	Futures	4313.0	4336.01	4299.25	4312.72	300768.0
2021-03-08 10:00:00	ES	Futures	4312.72	4351.45	4305.7	4342.75	345914.0
2021-03-08 11:00:00	ES	Futures	4342.47	4351.17	4327.03	4327.31	234873.0
2021-03-08 12:00:00	ES	Futures	4327.59	4353.98	4325.91	4344.15	144477.0
2021-03-08 13:00:00	ES	Futures	4344.43	4354.54	4315.53	4317.21	165720.0
2021-03-08 14:00:00	ES	Futures	4317.21	4337.14	4312.44	4321.98	187866.0
2021-03-08 15:00:00	ES	Futures	4321.98	4321.98	4284.37	4288.3	279149.0
2021-03-08 16:00:00	ES	Futures	4288.58	4304.02	4287.18	4299.25	64229.0
2021-03-08 18:00:00	ES	Futures	4301.21	4314.12	4300.09	4309.07	14150.0
2021-03-08 19:00:00	ES	Futures	4309.35	4313.28	4298.97	4305.98	17387.0
2021-03-08 20:00:00	ES	Futures	4305.7	4318.05	4295.6	4297.28	26163.0
2021-03-08 21:00:00	ES	Futures	4297.0	4315.81	4296.72	4314.68	22422.0
2021-03-08 22:00:00	ES	Futures	4314.68	4323.95	4313.28	4323.1	13911.0
2021-03-08 23:00:00	ES	Futures	4323.1	4326.47	4317.77	4323.39	9559.0
2021-03-08 00:00:00	NQ	Futures	14522.34	14539.7	14484.71	14514.81	7748.0
2021-03-08 01:00:00	NQ	Futures	14515.1	14548.1	14486.74	14499.47	7744.0
2021-03-08 02:00:00	NQ	Futures	14499.47	14527.26	14420.46	14441.88	12938.0
2021-03-08 03:00:00	NQ	Futures	14443.32	14449.98	14360.83	14424.22	17640.0
2021-03-08 04:00:00	NQ	Futures	14425.67	14432.9	14328.13	14383.12	15129.0
2021-03-08 05:00:00	NQ	Futures	14382.83	14434.64	14375.02	14424.8	8527.0
2021-03-08 06:00:00	NQ	Futures	14425.38	14464.16	14407.43	14456.93	11849.0
2021-03-08 07:00:00	NQ	Futures	14458.66	14494.84	14412.35	14452.87	18395.0
2021-03-08 08:00:00	NQ	Futures	14454.03	14604.83	14430.3	14597.01	28234.0
2021-03-08 09:00:00	NQ	Futures	14596.72	14701.79	14502.66	14561.7	107130.0
2021-03-08 10:00:00	NQ	Futures	14562.57	14721.47	14512.79	14625.38	100622.0
2021-03-08 11:00:00	NQ	Futures	14625.96	14673.13	14476.9	14481.82	73068.0
2021-03-08 12:00:00	NQ	Futures	14481.24	14574.44	14450.85	14498.89	56694.0
2021-03-08 13:00:00	NQ	Futures	14499.76	14555.33	14375.59	14383.41	46389.0
2021-03-08 14:00:00	NQ	Futures	14383.12	14466.77	14348.97	14379.65	53336.0
2021-03-08 15:00:00	NQ	Futures	14378.49	14378.78	14219.01	14240.72	78239.0
2021-03-08 16:00:00	NQ	Futures	14240.43	14298.61	14232.33	14278.92	17410.0
2021-03-08 18:00:00	NQ	Futures	14293.11	14338.55	14280.66	14322.92	6947.0
2021-03-08 19:00:00	NQ	Futures	14321.76	14342.89	14285.87	14315.97	7447.0
2021-03-08 20:00:00	NQ	Futures	14315.68	14366.04	14270.24	14289.34	11614.0
2021-03-08 21:00:00	NQ	Futures	14286.16	14407.43	14283.55	14395.28	12927.0
2021-03-08 22:00:00	NQ	Futures	14395.86	14422.48	14382.25	14413.8	7630.0
2021-03-08 23:00:00	NQ	Futures	14414.38	14428.27	14392.09	14420.17	5480.0
2021-03-08 00:00:00	YM	Futures	34906.4	34944.1	34882.0	34921.9	3045.0
2021-03-08 01:00:00	YM	Futures	34924.1	34970.7	34888.6	34895.3	3037.0
2021-03-08 02:00:00	YM	Futures	34895.3	34938.5	34812.1	34849.8	5184.0
2021-03-08 03:00:00	YM	Futures	34850.9	34874.2	34760.0	34859.8	10284.0

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

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