PREVIEW / futures_1hour / 2019-04-26

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-26.parquet
  size:    47 KB
  rows:    1,434

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
2019-04-26 00:00:00	ES	Futures	3169.19	3170.81	3169.19	3170.81	2050.0
2019-04-26 01:00:00	ES	Futures	3170.81	3172.98	3169.73	3171.35	7556.0
2019-04-26 02:00:00	ES	Futures	3171.35	3172.44	3169.19	3170.81	7489.0
2019-04-26 03:00:00	ES	Futures	3170.81	3171.35	3166.75	3169.73	15079.0
2019-04-26 04:00:00	ES	Futures	3169.73	3171.08	3168.64	3169.19	11014.0
2019-04-26 05:00:00	ES	Futures	3169.19	3171.35	3168.1	3171.35	8838.0
2019-04-26 06:00:00	ES	Futures	3171.08	3173.52	3170.54	3172.17	11554.0
2019-04-26 07:00:00	ES	Futures	3171.9	3173.52	3168.64	3169.19	10701.0
2019-04-26 08:00:00	ES	Futures	3168.91	3179.49	3166.75	3175.69	62091.0
2019-04-26 09:00:00	ES	Futures	3175.69	3180.3	3166.47	3168.64	220173.0
2019-04-26 10:00:00	ES	Futures	3168.64	3177.05	3165.66	3174.61	208981.0
2019-04-26 11:00:00	ES	Futures	3174.88	3182.47	3172.44	3179.49	138208.0
2019-04-26 12:00:00	ES	Futures	3179.49	3181.93	3178.4	3179.49	55680.0
2019-04-26 13:00:00	ES	Futures	3179.76	3179.76	3177.05	3179.22	52231.0
2019-04-26 14:00:00	ES	Futures	3179.22	3181.93	3175.69	3181.11	70326.0
2019-04-26 15:00:00	ES	Futures	3181.39	3190.6	3181.39	3190.06	196292.0
2019-04-26 16:00:00	ES	Futures	3189.79	3191.14	3187.08	3187.08	71474.0
2019-04-26 00:00:00	NQ	Futures	9077.66	9081.74	9077.08	9081.16	1107.0
2019-04-26 01:00:00	NQ	Futures	9081.16	9094.84	9077.66	9088.73	4319.0
2019-04-26 02:00:00	NQ	Futures	9088.73	9093.09	9082.03	9088.14	3770.0
2019-04-26 03:00:00	NQ	Futures	9088.14	9096.88	9078.83	9093.97	8346.0
2019-04-26 04:00:00	NQ	Futures	9093.97	9096.3	9084.36	9087.85	6147.0
2019-04-26 05:00:00	NQ	Futures	9088.14	9093.97	9082.32	9092.22	4299.0
2019-04-26 06:00:00	NQ	Futures	9092.22	9100.37	9090.77	9094.84	3623.0
2019-04-26 07:00:00	NQ	Futures	9094.84	9100.08	9081.16	9083.78	4234.0
2019-04-26 08:00:00	NQ	Futures	9084.07	9123.67	9078.83	9118.13	21582.0
2019-04-26 09:00:00	NQ	Futures	9117.84	9131.24	9039.81	9050.29	98787.0
2019-04-26 10:00:00	NQ	Futures	9050.0	9088.14	9032.24	9082.32	88507.0
2019-04-26 11:00:00	NQ	Futures	9082.32	9105.32	9074.75	9092.22	49089.0
2019-04-26 12:00:00	NQ	Futures	9092.22	9105.32	9089.6	9095.72	24806.0
2019-04-26 13:00:00	NQ	Futures	9095.72	9096.59	9079.99	9093.09	26961.0
2019-04-26 14:00:00	NQ	Futures	9093.39	9110.86	9083.78	9109.4	27981.0
2019-04-26 15:00:00	NQ	Futures	9109.69	9133.86	9108.53	9132.4	47880.0
2019-04-26 16:00:00	NQ	Futures	9132.69	9137.06	9126.29	9127.45	13363.0
2019-04-26 00:00:00	YM	Futures	28734.0	28744.9	28732.9	28740.5	559.0
2019-04-26 01:00:00	YM	Futures	28741.6	28765.5	28731.8	28740.5	1612.0
2019-04-26 02:00:00	YM	Futures	28741.6	28750.3	28716.6	28726.4	1836.0
2019-04-26 03:00:00	YM	Futures	28727.5	28732.9	28692.7	28725.3	3414.0
2019-04-26 04:00:00	YM	Futures	28725.3	28736.2	28705.7	28707.9	2275.0
2019-04-26 05:00:00	YM	Futures	28707.9	28728.6	28695.9	28728.6	1803.0
2019-04-26 06:00:00	YM	Futures	28728.6	28744.9	28715.5	28723.1	2432.0
2019-04-26 07:00:00	YM	Futures	28724.2	28744.9	28686.1	28689.4	2618.0
2019-04-26 08:00:00	YM	Futures	28690.5	28789.5	28655.7	28736.2	12457.0
2019-04-26 09:00:00	YM	Futures	28737.3	28794.9	28690.5	28716.6	31176.0
2019-04-26 10:00:00	YM	Futures	28717.7	28776.4	28692.7	28742.7	27705.0
2019-04-26 11:00:00	YM	Futures	28743.8	28808.0	28726.4	28796.0	16565.0
2019-04-26 12:00:00	YM	Futures	28797.1	28803.6	28771.0	28780.8	8720.0
2019-04-26 13:00:00	YM	Futures	28781.8	28791.6	28766.6	28779.7	6888.0
2019-04-26 14:00:00	YM	Futures	28779.7	28802.5	28749.2	28774.2	10705.0
2019-04-26 15:00:00	YM	Futures	28775.3	28852.5	28775.3	28846.0	19327.0

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

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