PREVIEW / futures_1hour / 2020-05-25

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-25.parquet
  size:    41 KB
  rows:    1,252

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-25 00:00:00	ES	Futures	3251.81	3255.38	3251.54	3252.91	2847.0
2020-05-25 01:00:00	ES	Futures	3253.18	3257.3	3252.63	3254.83	5270.0
2020-05-25 02:00:00	ES	Futures	3254.83	3260.04	3254.83	3256.75	8885.0
2020-05-25 03:00:00	ES	Futures	3257.02	3257.3	3248.24	3252.36	9953.0
2020-05-25 04:00:00	ES	Futures	3252.36	3275.13	3249.07	3270.74	21458.0
2020-05-25 05:00:00	ES	Futures	3270.74	3275.13	3269.37	3273.76	11493.0
2020-05-25 06:00:00	ES	Futures	3273.76	3276.51	3267.18	3275.41	13206.0
2020-05-25 07:00:00	ES	Futures	3275.13	3275.41	3269.92	3271.84	9213.0
2020-05-25 08:00:00	ES	Futures	3272.39	3277.33	3270.47	3275.96	8491.0
2020-05-25 09:00:00	ES	Futures	3275.96	3277.88	3274.04	3276.51	12444.0
2020-05-25 10:00:00	ES	Futures	3276.78	3280.35	3275.68	3280.07	11183.0
2020-05-25 11:00:00	ES	Futures	3279.8	3282.0	3278.7	3280.35	12967.0
2020-05-25 12:00:00	ES	Futures	3280.35	3282.0	3278.7	3281.45	6971.0
2020-05-25 18:00:00	ES	Futures	3281.45	3282.0	3274.04	3276.23	7745.0
2020-05-25 19:00:00	ES	Futures	3276.51	3276.78	3272.12	3273.49	4979.0
2020-05-25 20:00:00	ES	Futures	3273.76	3280.9	3271.84	3278.43	11781.0
2020-05-25 21:00:00	ES	Futures	3278.7	3286.39	3277.6	3286.11	16630.0
2020-05-25 22:00:00	ES	Futures	3286.39	3288.31	3283.64	3285.01	9725.0
2020-05-25 23:00:00	ES	Futures	3285.29	3294.89	3284.46	3293.25	10945.0
2020-05-25 00:00:00	NQ	Futures	10790.65	10804.36	10789.5	10796.36	1612.0
2020-05-25 01:00:00	NQ	Futures	10796.07	10812.64	10794.07	10805.5	2824.0
2020-05-25 02:00:00	NQ	Futures	10804.36	10824.64	10804.36	10817.78	3459.0
2020-05-25 03:00:00	NQ	Futures	10818.35	10818.64	10790.36	10804.36	5164.0
2020-05-25 04:00:00	NQ	Futures	10804.36	10861.77	10792.07	10850.63	7224.0
2020-05-25 05:00:00	NQ	Futures	10850.35	10860.34	10841.78	10857.49	4251.0
2020-05-25 06:00:00	NQ	Futures	10857.49	10874.34	10834.06	10867.48	5345.0
2020-05-25 07:00:00	NQ	Futures	10868.34	10870.63	10854.34	10864.91	3835.0
2020-05-25 08:00:00	NQ	Futures	10865.77	10877.77	10854.63	10872.63	4019.0
2020-05-25 09:00:00	NQ	Futures	10873.2	10886.05	10867.2	10880.91	5842.0
2020-05-25 10:00:00	NQ	Futures	10881.19	10890.91	10874.05	10886.05	4555.0
2020-05-25 11:00:00	NQ	Futures	10886.34	10896.05	10882.05	10888.91	4053.0
2020-05-25 12:00:00	NQ	Futures	10888.91	10893.48	10881.77	10889.19	2813.0
2020-05-25 18:00:00	NQ	Futures	10888.91	10893.19	10861.49	10875.2	2840.0
2020-05-25 19:00:00	NQ	Futures	10875.2	10876.34	10858.91	10865.48	1819.0
2020-05-25 20:00:00	NQ	Futures	10866.06	10889.76	10860.06	10880.34	4822.0
2020-05-25 21:00:00	NQ	Futures	10880.34	10914.33	10877.77	10910.62	6804.0
2020-05-25 22:00:00	NQ	Futures	10910.9	10916.04	10898.62	10906.62	4979.0
2020-05-25 23:00:00	NQ	Futures	10906.9	10938.04	10905.19	10931.75	4633.0
2020-05-25 00:00:00	YM	Futures	26845.1	26873.6	26841.9	26858.3	857.0
2020-05-25 01:00:00	YM	Futures	26856.1	26887.9	26849.5	26873.6	1591.0
2020-05-25 02:00:00	YM	Futures	26872.5	26917.4	26872.5	26886.8	2311.0
2020-05-25 03:00:00	YM	Futures	26888.9	26890.0	26822.1	26862.7	5182.0
2020-05-25 04:00:00	YM	Futures	26863.8	27047.8	26837.5	27020.4	6468.0
2020-05-25 05:00:00	YM	Futures	27020.4	27043.4	27001.8	27032.4	3698.0
2020-05-25 06:00:00	YM	Futures	27032.4	27037.9	26966.7	27025.9	3627.0
2020-05-25 07:00:00	YM	Futures	27025.9	27029.1	26981.0	27006.1	2763.0
2020-05-25 08:00:00	YM	Futures	27007.2	27045.6	26991.9	27034.6	2642.0
2020-05-25 09:00:00	YM	Futures	27034.6	27053.2	27011.6	27040.1	3635.0
2020-05-25 10:00:00	YM	Futures	27039.0	27052.2	27024.8	27051.1	2285.0
2020-05-25 11:00:00	YM	Futures	27051.1	27091.6	27042.3	27069.7	3161.0

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

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