PREVIEW / futures_1hour / 2020-04-30

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-30.parquet
  size:    64 KB
  rows:    1,862

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-04-30 00:00:00	ES	Futures	3245.5	3254.55	3243.03	3250.16	18676.0
2020-04-30 01:00:00	ES	Futures	3250.16	3251.54	3244.13	3244.67	24797.0
2020-04-30 02:00:00	ES	Futures	3244.67	3245.77	3235.34	3244.4	20515.0
2020-04-30 03:00:00	ES	Futures	3244.13	3244.4	3226.01	3228.48	35664.0
2020-04-30 04:00:00	ES	Futures	3228.48	3241.11	3226.01	3229.03	26402.0
2020-04-30 05:00:00	ES	Futures	3229.31	3236.72	3227.39	3236.17	18400.0
2020-04-30 06:00:00	ES	Futures	3236.17	3239.46	3214.76	3220.53	37405.0
2020-04-30 07:00:00	ES	Futures	3220.25	3223.0	3205.43	3206.81	52679.0
2020-04-30 08:00:00	ES	Futures	3206.81	3217.23	3193.08	3193.63	77872.0
2020-04-30 09:00:00	ES	Futures	3193.36	3200.49	3176.07	3193.91	237382.0
2020-04-30 10:00:00	ES	Futures	3194.18	3205.16	3186.77	3191.99	244476.0
2020-04-30 11:00:00	ES	Futures	3192.26	3201.59	3175.52	3175.8	186290.0
2020-04-30 12:00:00	ES	Futures	3175.8	3181.56	3164.82	3179.91	171931.0
2020-04-30 13:00:00	ES	Futures	3179.91	3185.13	3170.58	3171.41	117000.0
2020-04-30 14:00:00	ES	Futures	3171.41	3182.38	3167.84	3173.05	113458.0
2020-04-30 15:00:00	ES	Futures	3173.05	3193.63	3170.58	3184.58	370898.0
2020-04-30 16:00:00	ES	Futures	3184.3	3187.6	3159.06	3164.0	117371.0
2020-04-30 18:00:00	ES	Futures	3151.92	3152.47	3131.62	3147.26	30389.0
2020-04-30 19:00:00	ES	Futures	3147.26	3156.31	3144.24	3154.94	13444.0
2020-04-30 20:00:00	ES	Futures	3155.22	3158.78	3146.98	3158.23	16803.0
2020-04-30 21:00:00	ES	Futures	3158.23	3160.98	3146.43	3150.28	11201.0
2020-04-30 22:00:00	ES	Futures	3150.55	3152.2	3137.1	3140.12	11310.0
2020-04-30 23:00:00	ES	Futures	3140.12	3145.61	3134.91	3139.85	10313.0
2020-04-30 00:00:00	NQ	Futures	10417.03	10448.45	10406.17	10431.31	4552.0
2020-04-30 01:00:00	NQ	Futures	10431.88	10439.59	10415.31	10418.46	3859.0
2020-04-30 02:00:00	NQ	Futures	10419.31	10421.03	10377.04	10402.46	7448.0
2020-04-30 03:00:00	NQ	Futures	10402.18	10404.17	10354.47	10365.61	12216.0
2020-04-30 04:00:00	NQ	Futures	10366.47	10392.18	10355.9	10364.47	8111.0
2020-04-30 05:00:00	NQ	Futures	10364.76	10394.18	10364.76	10391.89	5909.0
2020-04-30 06:00:00	NQ	Futures	10392.46	10402.75	10331.34	10346.76	9725.0
2020-04-30 07:00:00	NQ	Futures	10346.76	10371.33	10333.34	10336.48	14311.0
2020-04-30 08:00:00	NQ	Futures	10336.48	10354.76	10270.78	10275.07	23170.0
2020-04-30 09:00:00	NQ	Futures	10275.07	10303.63	10211.94	10279.06	61926.0
2020-04-30 10:00:00	NQ	Futures	10279.35	10298.49	10220.79	10247.36	61726.0
2020-04-30 11:00:00	NQ	Futures	10247.64	10287.06	10214.22	10214.79	43180.0
2020-04-30 12:00:00	NQ	Futures	10214.79	10225.36	10175.38	10219.65	40632.0
2020-04-30 13:00:00	NQ	Futures	10219.37	10233.65	10185.95	10196.23	27486.0
2020-04-30 14:00:00	NQ	Futures	10195.37	10228.51	10178.52	10193.94	25319.0
2020-04-30 15:00:00	NQ	Futures	10194.23	10282.49	10185.95	10262.5	51080.0
2020-04-30 16:00:00	NQ	Futures	10262.5	10270.21	10119.11	10134.24	33651.0
2020-04-30 18:00:00	NQ	Futures	10108.25	10113.39	10060.26	10090.83	7096.0
2020-04-30 19:00:00	NQ	Futures	10090.54	10105.39	10077.12	10098.54	4107.0
2020-04-30 20:00:00	NQ	Futures	10098.82	10117.39	10072.83	10115.96	5148.0
2020-04-30 21:00:00	NQ	Futures	10115.39	10124.82	10081.97	10095.97	4882.0
2020-04-30 22:00:00	NQ	Futures	10095.97	10104.25	10055.69	10064.83	5166.0
2020-04-30 23:00:00	NQ	Futures	10064.55	10079.69	10039.7	10072.26	4835.0
2020-04-30 00:00:00	YM	Futures	27060.9	27155.1	27043.4	27116.8	3030.0
2020-04-30 01:00:00	YM	Futures	27117.9	27126.6	27048.9	27053.2	2246.0
2020-04-30 02:00:00	YM	Futures	27053.2	27066.4	26977.7	27058.7	3810.0
2020-04-30 03:00:00	YM	Futures	27056.5	27068.6	26895.5	26921.8	5841.0

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

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