PREVIEW / futures_1hour / 2020-05-27

all futures 1-hour files

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

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-05-27 00:00:00	ES	Futures	3308.61	3313.55	3307.52	3308.61	10601.0
2020-05-27 01:00:00	ES	Futures	3308.61	3311.36	3305.32	3306.69	11808.0
2020-05-27 02:00:00	ES	Futures	3306.42	3308.34	3301.75	3303.13	13913.0
2020-05-27 03:00:00	ES	Futures	3303.13	3314.65	3297.36	3310.81	38280.0
2020-05-27 04:00:00	ES	Futures	3310.53	3319.04	3307.79	3317.67	34368.0
2020-05-27 05:00:00	ES	Futures	3317.67	3331.39	3315.75	3329.47	48362.0
2020-05-27 06:00:00	ES	Futures	3329.19	3330.57	3321.51	3325.35	35972.0
2020-05-27 07:00:00	ES	Futures	3325.35	3327.82	3318.77	3319.86	34647.0
2020-05-27 08:00:00	ES	Futures	3319.86	3326.18	3313.83	3313.83	69074.0
2020-05-27 09:00:00	ES	Futures	3314.1	3320.14	3284.74	3288.03	286403.0
2020-05-27 10:00:00	ES	Futures	3288.31	3296.26	3255.1	3267.73	380963.0
2020-05-27 11:00:00	ES	Futures	3267.73	3285.29	3261.14	3284.19	285327.0
2020-05-27 12:00:00	ES	Futures	3284.19	3294.89	3281.45	3291.05	148992.0
2020-05-27 13:00:00	ES	Futures	3291.05	3294.62	3283.37	3292.97	119021.0
2020-05-27 14:00:00	ES	Futures	3293.25	3308.89	3292.97	3308.34	138542.0
2020-05-27 15:00:00	ES	Futures	3308.06	3328.1	3304.22	3327.27	225965.0
2020-05-27 16:00:00	ES	Futures	3327.27	3336.33	3323.43	3333.59	76469.0
2020-05-27 18:00:00	ES	Futures	3331.39	3336.33	3326.72	3334.13	15204.0
2020-05-27 19:00:00	ES	Futures	3334.13	3339.9	3330.02	3339.62	12474.0
2020-05-27 20:00:00	ES	Futures	3339.35	3349.5	3336.05	3345.38	23912.0
2020-05-27 21:00:00	ES	Futures	3345.11	3351.97	3339.62	3347.31	22722.0
2020-05-27 22:00:00	ES	Futures	3347.58	3351.15	3340.45	3340.72	15709.0
2020-05-27 23:00:00	ES	Futures	3340.99	3343.19	3328.1	3330.02	24682.0
2020-05-27 00:00:00	NQ	Futures	10833.49	10849.49	10829.78	10833.78	4540.0
2020-05-27 01:00:00	NQ	Futures	10834.06	10838.35	10816.64	10820.35	4866.0
2020-05-27 02:00:00	NQ	Futures	10820.35	10829.49	10808.07	10812.93	4811.0
2020-05-27 03:00:00	NQ	Futures	10812.93	10846.92	10800.93	10832.64	11568.0
2020-05-27 04:00:00	NQ	Futures	10832.35	10841.2	10807.78	10834.92	7947.0
2020-05-27 05:00:00	NQ	Futures	10835.78	10863.48	10821.78	10858.63	11075.0
2020-05-27 06:00:00	NQ	Futures	10858.63	10861.49	10814.64	10829.78	9826.0
2020-05-27 07:00:00	NQ	Futures	10829.49	10830.92	10780.08	10785.5	13188.0
2020-05-27 08:00:00	NQ	Futures	10785.79	10790.36	10724.66	10728.66	23057.0
2020-05-27 09:00:00	NQ	Futures	10728.95	10744.09	10593.84	10611.55	85800.0
2020-05-27 10:00:00	NQ	Futures	10611.55	10652.97	10480.16	10526.71	93552.0
2020-05-27 11:00:00	NQ	Futures	10527.0	10602.41	10486.72	10595.84	66677.0
2020-05-27 12:00:00	NQ	Futures	10595.84	10670.39	10583.27	10647.54	46012.0
2020-05-27 13:00:00	NQ	Futures	10647.54	10671.53	10620.69	10667.54	38246.0
2020-05-27 14:00:00	NQ	Futures	10667.54	10745.23	10667.25	10744.37	41363.0
2020-05-27 15:00:00	NQ	Futures	10744.94	10786.36	10718.09	10779.51	41753.0
2020-05-27 16:00:00	NQ	Futures	10780.36	10795.79	10765.51	10787.79	10849.0
2020-05-27 18:00:00	NQ	Futures	10781.79	10787.22	10753.8	10774.65	4935.0
2020-05-27 19:00:00	NQ	Futures	10776.08	10791.5	10758.37	10788.65	4351.0
2020-05-27 20:00:00	NQ	Futures	10787.79	10824.92	10778.36	10813.21	7575.0
2020-05-27 21:00:00	NQ	Futures	10812.64	10833.49	10789.5	10820.35	7039.0
2020-05-27 22:00:00	NQ	Futures	10820.64	10829.49	10769.51	10770.37	7062.0
2020-05-27 23:00:00	NQ	Futures	10770.65	10777.22	10707.81	10718.09	10460.0
2020-05-27 00:00:00	YM	Futures	27569.1	27613.0	27558.2	27570.2	2220.0
2020-05-27 01:00:00	YM	Futures	27570.2	27583.4	27534.1	27543.9	2686.0
2020-05-27 02:00:00	YM	Futures	27541.8	27563.7	27496.9	27508.9	3454.0
2020-05-27 03:00:00	YM	Futures	27507.8	27623.9	27456.3	27591.0	9654.0

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

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