PREVIEW / futures_1hour / 2020-04-29

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-29.parquet
  size:    62 KB
  rows:    1,860

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-29 00:00:00	ES	Futures	3181.29	3188.69	3176.35	3185.13	22674.0
2020-04-29 01:00:00	ES	Futures	3185.13	3187.05	3177.17	3183.21	10347.0
2020-04-29 02:00:00	ES	Futures	3183.21	3185.13	3167.56	3171.68	13749.0
2020-04-29 03:00:00	ES	Futures	3171.68	3178.54	3164.55	3176.35	25720.0
2020-04-29 04:00:00	ES	Futures	3176.07	3177.99	3167.56	3177.72	16518.0
2020-04-29 05:00:00	ES	Futures	3177.99	3180.19	3173.05	3175.8	13970.0
2020-04-29 06:00:00	ES	Futures	3176.07	3176.07	3165.09	3174.15	20070.0
2020-04-29 07:00:00	ES	Futures	3174.15	3176.62	3161.53	3164.27	26737.0
2020-04-29 08:00:00	ES	Futures	3164.0	3207.9	3163.17	3206.81	122858.0
2020-04-29 09:00:00	ES	Futures	3206.81	3212.57	3185.68	3202.96	203687.0
2020-04-29 10:00:00	ES	Futures	3202.69	3210.65	3190.07	3207.35	186314.0
2020-04-29 11:00:00	ES	Futures	3207.63	3215.86	3202.14	3213.12	147585.0
2020-04-29 12:00:00	ES	Futures	3213.12	3229.58	3212.84	3224.92	147028.0
2020-04-29 13:00:00	ES	Futures	3224.92	3232.05	3218.61	3221.62	119556.0
2020-04-29 14:00:00	ES	Futures	3221.9	3226.56	3208.73	3224.92	166499.0
2020-04-29 15:00:00	ES	Futures	3224.92	3235.07	3215.04	3215.86	271831.0
2020-04-29 16:00:00	ES	Futures	3215.59	3248.79	3214.76	3247.42	93940.0
2020-04-29 18:00:00	ES	Futures	3245.22	3245.77	3233.97	3237.54	11527.0
2020-04-29 19:00:00	ES	Futures	3237.81	3238.64	3232.05	3233.7	8581.0
2020-04-29 20:00:00	ES	Futures	3233.42	3233.7	3218.61	3225.74	17266.0
2020-04-29 21:00:00	ES	Futures	3225.47	3231.23	3221.9	3226.01	10898.0
2020-04-29 22:00:00	ES	Futures	3226.29	3235.62	3225.19	3234.8	9020.0
2020-04-29 23:00:00	ES	Futures	3235.07	3246.6	3232.6	3245.77	9634.0
2020-04-29 00:00:00	NQ	Futures	10097.97	10118.53	10079.12	10103.11	6646.0
2020-04-29 01:00:00	NQ	Futures	10103.68	10114.25	10081.97	10098.25	3739.0
2020-04-29 02:00:00	NQ	Futures	10098.82	10105.68	10051.69	10070.83	5814.0
2020-04-29 03:00:00	NQ	Futures	10071.12	10093.4	10045.41	10077.69	10823.0
2020-04-29 04:00:00	NQ	Futures	10077.4	10087.4	10058.84	10079.97	6591.0
2020-04-29 05:00:00	NQ	Futures	10080.26	10087.4	10063.12	10072.26	5109.0
2020-04-29 06:00:00	NQ	Futures	10072.55	10072.83	10042.27	10071.12	5741.0
2020-04-29 07:00:00	NQ	Futures	10070.83	10073.4	10023.99	10036.27	8632.0
2020-04-29 08:00:00	NQ	Futures	10035.98	10162.52	10029.7	10156.24	27241.0
2020-04-29 09:00:00	NQ	Futures	10156.24	10176.8	10072.83	10162.24	58927.0
2020-04-29 10:00:00	NQ	Futures	10161.95	10214.22	10130.82	10191.66	57381.0
2020-04-29 11:00:00	NQ	Futures	10191.37	10208.51	10173.66	10186.8	35623.0
2020-04-29 12:00:00	NQ	Futures	10187.09	10242.79	10187.09	10223.08	31900.0
2020-04-29 13:00:00	NQ	Futures	10223.65	10248.5	10216.51	10237.07	24003.0
2020-04-29 14:00:00	NQ	Futures	10237.93	10265.35	10194.8	10259.07	36079.0
2020-04-29 15:00:00	NQ	Futures	10259.07	10299.92	10235.93	10241.36	48507.0
2020-04-29 16:00:00	NQ	Futures	10241.36	10418.74	10237.65	10418.17	25916.0
2020-04-29 18:00:00	NQ	Futures	10408.17	10408.17	10367.61	10386.46	4202.0
2020-04-29 19:00:00	NQ	Futures	10386.75	10402.75	10370.75	10387.89	3497.0
2020-04-29 20:00:00	NQ	Futures	10386.46	10387.61	10332.48	10352.47	4918.0
2020-04-29 21:00:00	NQ	Futures	10352.47	10373.33	10346.48	10360.76	5186.0
2020-04-29 22:00:00	NQ	Futures	10361.04	10393.61	10355.04	10381.04	3840.0
2020-04-29 23:00:00	NQ	Futures	10379.61	10427.31	10373.9	10417.6	3903.0
2020-04-29 00:00:00	YM	Futures	26569.1	26633.7	26533.0	26606.4	3533.0
2020-04-29 01:00:00	YM	Futures	26604.2	26619.5	26540.6	26593.2	2229.0
2020-04-29 02:00:00	YM	Futures	26595.4	26612.9	26455.2	26492.4	3526.0
2020-04-29 03:00:00	YM	Futures	26489.2	26553.8	26439.9	26533.0	5622.0

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

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