PREVIEW / futures_1hour / 2020-04-27

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-27.parquet
  size:    61 KB
  rows:    1,867

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-27 00:00:00	ES	Futures	3121.74	3139.3	3121.46	3137.65	12763.0
2020-04-27 01:00:00	ES	Futures	3137.65	3144.79	3133.81	3138.2	11730.0
2020-04-27 02:00:00	ES	Futures	3138.2	3139.85	3120.09	3124.21	20830.0
2020-04-27 03:00:00	ES	Futures	3124.48	3138.2	3119.82	3134.63	34162.0
2020-04-27 04:00:00	ES	Futures	3134.36	3135.73	3124.21	3133.26	23854.0
2020-04-27 05:00:00	ES	Futures	3132.99	3142.32	3128.6	3139.85	18454.0
2020-04-27 06:00:00	ES	Futures	3139.3	3139.3	3130.52	3131.07	16316.0
2020-04-27 07:00:00	ES	Futures	3131.07	3136.56	3128.6	3132.71	17161.0
2020-04-27 08:00:00	ES	Futures	3132.99	3143.42	3132.16	3134.09	35208.0
2020-04-27 09:00:00	ES	Futures	3133.81	3139.03	3121.46	3131.62	149909.0
2020-04-27 10:00:00	ES	Futures	3131.62	3141.22	3127.5	3133.54	146198.0
2020-04-27 11:00:00	ES	Futures	3133.26	3150.28	3130.52	3147.26	121715.0
2020-04-27 12:00:00	ES	Futures	3147.26	3152.2	3141.77	3149.18	95290.0
2020-04-27 13:00:00	ES	Futures	3149.18	3149.18	3138.48	3143.14	84625.0
2020-04-27 14:00:00	ES	Futures	3142.87	3154.94	3142.87	3152.47	75933.0
2020-04-27 15:00:00	ES	Futures	3152.2	3162.62	3148.36	3149.45	190374.0
2020-04-27 16:00:00	ES	Futures	3149.45	3151.37	3145.61	3146.98	50403.0
2020-04-27 18:00:00	ES	Futures	3147.81	3149.45	3142.32	3145.89	5620.0
2020-04-27 19:00:00	ES	Futures	3145.89	3153.29	3145.34	3147.53	5829.0
2020-04-27 20:00:00	ES	Futures	3147.53	3154.94	3142.59	3151.92	11815.0
2020-04-27 21:00:00	ES	Futures	3151.92	3151.92	3132.99	3134.63	18918.0
2020-04-27 22:00:00	ES	Futures	3134.91	3141.22	3132.71	3139.3	7090.0
2020-04-27 23:00:00	ES	Futures	3139.3	3140.67	3134.09	3135.73	6090.0
2020-04-27 00:00:00	NQ	Futures	10096.54	10155.1	10094.25	10148.24	5681.0
2020-04-27 01:00:00	NQ	Futures	10147.38	10166.52	10129.96	10149.67	4605.0
2020-04-27 02:00:00	NQ	Futures	10149.67	10155.38	10108.54	10117.96	6651.0
2020-04-27 03:00:00	NQ	Futures	10118.25	10157.38	10098.54	10147.38	8650.0
2020-04-27 04:00:00	NQ	Futures	10146.81	10147.67	10110.54	10137.1	5939.0
2020-04-27 05:00:00	NQ	Futures	10137.67	10165.38	10125.96	10157.1	4724.0
2020-04-27 06:00:00	NQ	Futures	10155.95	10155.95	10122.25	10123.1	5601.0
2020-04-27 07:00:00	NQ	Futures	10124.25	10151.67	10117.68	10139.67	6001.0
2020-04-27 08:00:00	NQ	Futures	10139.96	10157.38	10129.96	10131.96	10297.0
2020-04-27 09:00:00	NQ	Futures	10131.96	10147.67	10076.54	10129.96	47508.0
2020-04-27 10:00:00	NQ	Futures	10129.1	10142.53	10069.12	10073.69	49657.0
2020-04-27 11:00:00	NQ	Futures	10073.4	10127.1	10062.55	10105.39	37122.0
2020-04-27 12:00:00	NQ	Futures	10105.68	10115.11	10073.69	10096.25	30302.0
2020-04-27 13:00:00	NQ	Futures	10096.25	10097.4	10041.98	10055.69	32236.0
2020-04-27 14:00:00	NQ	Futures	10056.26	10097.11	10055.98	10082.83	25140.0
2020-04-27 15:00:00	NQ	Futures	10082.26	10111.39	10070.83	10082.26	37264.0
2020-04-27 16:00:00	NQ	Futures	10082.54	10085.69	10072.83	10075.4	6966.0
2020-04-27 18:00:00	NQ	Futures	10076.26	10080.54	10055.69	10070.26	1906.0
2020-04-27 19:00:00	NQ	Futures	10071.97	10098.54	10069.12	10081.12	2464.0
2020-04-27 20:00:00	NQ	Futures	10080.83	10108.82	10067.12	10100.25	3394.0
2020-04-27 21:00:00	NQ	Futures	10099.11	10099.11	10031.7	10035.98	5410.0
2020-04-27 22:00:00	NQ	Futures	10036.27	10063.41	10028.27	10058.84	3157.0
2020-04-27 23:00:00	NQ	Futures	10059.12	10063.41	10039.41	10049.41	2259.0
2020-04-27 00:00:00	YM	Futures	26060.9	26224.1	26058.7	26210.9	2827.0
2020-04-27 01:00:00	YM	Futures	26210.9	26266.8	26174.8	26200.0	2228.0
2020-04-27 02:00:00	YM	Futures	26203.3	26216.4	26056.5	26094.8	3867.0
2020-04-27 03:00:00	YM	Futures	26095.9	26197.8	26060.9	26170.4	4504.0

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

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