PREVIEW / futures_1hour / 2020-06-15

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-15.parquet
  size:    63 KB
  rows:    1,827

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-06-15 00:00:00	ES	Futures	3335.56	3335.56	3318.53	3319.65	11705.0
2020-06-15 01:00:00	ES	Futures	3319.65	3320.48	3277.76	3279.72	43872.0
2020-06-15 02:00:00	ES	Futures	3279.99	3289.49	3265.75	3281.95	55094.0
2020-06-15 03:00:00	ES	Futures	3281.95	3294.79	3271.62	3292.56	56871.0
2020-06-15 04:00:00	ES	Futures	3292.84	3319.09	3288.09	3318.25	44755.0
2020-06-15 05:00:00	ES	Futures	3318.25	3327.47	3306.24	3324.95	29970.0
2020-06-15 06:00:00	ES	Futures	3324.95	3330.54	3302.33	3303.17	34865.0
2020-06-15 07:00:00	ES	Futures	3303.17	3326.91	3300.66	3315.74	32886.0
2020-06-15 08:00:00	ES	Futures	3316.02	3318.81	3305.96	3313.22	54850.0
2020-06-15 09:00:00	ES	Futures	3313.5	3335.56	3297.87	3333.61	251628.0
2020-06-15 10:00:00	ES	Futures	3333.61	3353.99	3326.07	3344.78	262479.0
2020-06-15 11:00:00	ES	Futures	3344.5	3363.77	3342.54	3355.39	202143.0
2020-06-15 12:00:00	ES	Futures	3355.39	3383.59	3352.6	3383.04	132956.0
2020-06-15 13:00:00	ES	Futures	3383.04	3393.93	3377.17	3379.96	112405.0
2020-06-15 14:00:00	ES	Futures	3379.68	3427.16	3379.68	3410.12	296468.0
2020-06-15 15:00:00	ES	Futures	3409.84	3421.85	3385.55	3413.19	256997.0
2020-06-15 16:00:00	ES	Futures	3413.19	3425.48	3410.4	3424.08	63075.0
2020-06-15 18:00:00	ES	Futures	3423.8	3434.97	3419.06	3428.27	18087.0
2020-06-15 19:00:00	ES	Futures	3427.99	3448.66	3418.22	3448.1	21221.0
2020-06-15 20:00:00	ES	Futures	3447.82	3452.01	3439.72	3445.03	22252.0
2020-06-15 21:00:00	ES	Futures	3445.31	3455.92	3442.79	3446.7	18094.0
2020-06-15 22:00:00	ES	Futures	3446.7	3477.7	3445.86	3474.35	28183.0
2020-06-15 23:00:00	ES	Futures	3474.35	3475.74	3469.32	3469.88	12433.0
2020-06-15 00:00:00	NQ	Futures	11058.48	11061.66	11011.92	11018.28	1503.0
2020-06-15 01:00:00	NQ	Futures	11017.12	11020.88	10876.87	10882.66	7452.0
2020-06-15 02:00:00	NQ	Futures	10882.95	10903.19	10836.39	10885.26	6476.0
2020-06-15 03:00:00	NQ	Futures	10887.28	10921.98	10857.5	10916.78	4774.0
2020-06-15 04:00:00	NQ	Futures	10917.36	10975.77	10900.3	10974.04	4061.0
2020-06-15 05:00:00	NQ	Futures	10971.14	11006.14	10942.23	11000.06	3055.0
2020-06-15 06:00:00	NQ	Futures	11001.22	11022.62	10948.3	10950.9	3755.0
2020-06-15 07:00:00	NQ	Futures	10954.08	11022.33	10947.14	11002.95	4772.0
2020-06-15 08:00:00	NQ	Futures	11004.4	11016.83	10978.66	11002.38	10021.0
2020-06-15 09:00:00	NQ	Futures	11002.95	11090.58	10955.53	11086.53	59067.0
2020-06-15 10:00:00	NQ	Futures	11085.95	11131.64	11039.97	11078.43	49136.0
2020-06-15 11:00:00	NQ	Futures	11077.56	11135.4	11070.91	11118.91	40042.0
2020-06-15 12:00:00	NQ	Futures	11118.05	11191.79	11111.4	11191.21	24492.0
2020-06-15 13:00:00	NQ	Futures	11190.05	11219.26	11179.64	11211.16	15284.0
2020-06-15 14:00:00	NQ	Futures	11210.87	11333.49	11210.87	11298.49	42076.0
2020-06-15 15:00:00	NQ	Futures	11297.63	11327.12	11234.59	11295.6	37119.0
2020-06-15 16:00:00	NQ	Futures	11295.89	11339.27	11292.42	11335.51	7477.0
2020-06-15 18:00:00	NQ	Futures	11335.51	11362.4	11321.92	11345.05	3056.0
2020-06-15 19:00:00	NQ	Futures	11345.92	11414.17	11324.23	11410.99	4397.0
2020-06-15 20:00:00	NQ	Futures	11410.12	11422.55	11384.09	11402.02	3905.0
2020-06-15 21:00:00	NQ	Futures	11402.31	11428.34	11394.79	11414.74	3853.0
2020-06-15 22:00:00	NQ	Futures	11415.32	11506.99	11412.72	11496.58	6609.0
2020-06-15 23:00:00	NQ	Futures	11496.87	11498.03	11469.4	11472.0	2746.0
2020-06-15 00:00:00	YM	Futures	27573.6	27577.0	27395.3	27403.0	3528.0
2020-06-15 01:00:00	YM	Futures	27403.0	27406.3	26997.8	27007.7	9668.0
2020-06-15 02:00:00	YM	Futures	27009.9	27098.0	26877.7	27018.7	4784.0
2020-06-15 03:00:00	YM	Futures	27024.2	27172.8	26955.9	27150.8	10839.0

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

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