PREVIEW / etf_1hour / 2019-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-16.parquet
  size:    331 KB
  rows:    10,923

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-08-16 04:00:00	SPY	ETF	286.48	287.55	286.48	287.44	71227.0
2019-08-16 05:00:00	SPY	ETF	287.47	287.71	287.06	287.41	86931.0
2019-08-16 06:00:00	SPY	ETF	287.44	287.63	287.21	287.53	31583.0
2019-08-16 07:00:00	SPY	ETF	287.49	287.66	287.06	287.11	293024.0
2019-08-16 08:00:00	SPY	ETF	287.12	287.64	286.15	287.19	720167.0
2019-08-16 09:00:00	SPY	ETF	287.21	287.36	286.16	286.91	6782050.0
2019-08-16 10:00:00	SPY	ETF	286.91	288.99	286.79	288.97	15744498.0
2019-08-16 11:00:00	SPY	ETF	288.965	289.09	288.18	288.645	9646197.0
2019-08-16 12:00:00	SPY	ETF	288.645	288.85	288.16	288.67	5321917.0
2019-08-16 13:00:00	SPY	ETF	288.67	289.11	288.65	288.87	5491598.0
2019-08-16 14:00:00	SPY	ETF	288.88	288.9	288.3499	288.65	5324038.0
2019-08-16 15:00:00	SPY	ETF	288.65	289.33	284.7138	288.87	19387498.0
2019-08-16 16:00:00	SPY	ETF	288.85	289.21	288.64	289.01	13369885.0
2019-08-16 17:00:00	SPY	ETF	289.02	289.02	288.8	288.87	1770288.0
2019-08-16 18:00:00	SPY	ETF	288.87	288.89	288.71	288.89	285921.0
2019-08-16 19:00:00	SPY	ETF	288.81	288.99	288.8	288.92	15150.0
2019-08-16 04:00:00	QQQ	ETF	184.21	185.08	184.16	185.08	34906.0
2019-08-16 05:00:00	QQQ	ETF	184.91	185.15	184.6	184.86	45803.0
2019-08-16 06:00:00	QQQ	ETF	184.98	185.09	184.74	184.99	25335.0
2019-08-16 07:00:00	QQQ	ETF	184.99	185.09	184.44	184.49	142643.0
2019-08-16 08:00:00	QQQ	ETF	184.98	185.01	182.55	184.59	542084.0
2019-08-16 09:00:00	QQQ	ETF	184.61	184.73	183.84	184.44	3187404.0
2019-08-16 10:00:00	QQQ	ETF	184.43	185.85	184.26	185.83	4818044.0
2019-08-16 11:00:00	QQQ	ETF	185.83	185.95	185.025	185.34	3527697.0
2019-08-16 12:00:00	QQQ	ETF	185.359	185.6	185.0	185.44	1222097.0
2019-08-16 13:00:00	QQQ	ETF	185.44	185.77	185.44	185.65	1250122.0
2019-08-16 14:00:00	QQQ	ETF	185.66	185.665	185.24	185.46	1540816.0
2019-08-16 15:00:00	QQQ	ETF	185.45	185.81	185.31	185.46	6050515.0
2019-08-16 16:00:00	QQQ	ETF	185.46	185.6	185.19	185.45	3969624.0
2019-08-16 17:00:00	QQQ	ETF	185.56	185.56	185.42	185.48	455996.0
2019-08-16 18:00:00	QQQ	ETF	185.47	185.6	185.41	185.42	245709.0
2019-08-16 19:00:00	QQQ	ETF	185.42	185.48	185.42	185.44	3051.0
2019-08-16 04:00:00	IWM	ETF	146.98	147.0	146.98	147.0	1300.0
2019-08-16 06:00:00	IWM	ETF	147.01	147.04	146.9	147.04	36100.0
2019-08-16 07:00:00	IWM	ETF	147.06	147.11	146.76	146.78	36400.0
2019-08-16 08:00:00	IWM	ETF	147.01	147.03	146.75	146.95	262238.0
2019-08-16 09:00:00	IWM	ETF	146.95	147.39	146.11	147.27	2229061.0
2019-08-16 10:00:00	IWM	ETF	147.28	147.86	147.02	147.84	3631931.0
2019-08-16 11:00:00	IWM	ETF	147.84	148.48	147.74	148.29	3607904.0
2019-08-16 12:00:00	IWM	ETF	148.29	148.66	148.23	148.55	1191050.0
2019-08-16 13:00:00	IWM	ETF	148.56	148.775	148.41	148.71	909237.0
2019-08-16 14:00:00	IWM	ETF	148.7299	148.84	148.58	148.76	1203794.0
2019-08-16 15:00:00	IWM	ETF	148.76	148.91	148.56	148.63	4397161.0
2019-08-16 16:00:00	IWM	ETF	148.63	148.75	148.45	148.72	1057716.0
2019-08-16 17:00:00	IWM	ETF	148.6	148.72	148.6	148.67	503600.0
2019-08-16 18:00:00	IWM	ETF	148.63	148.68	148.63	148.68	596630.0
2019-08-16 19:00:00	IWM	ETF	148.67	148.69	148.67	148.69	750.0
2019-08-16 04:00:00	DIA	ETF	257.5	257.5	257.5	257.5	100.0
2019-08-16 06:00:00	DIA	ETF	258.1	258.1	258.05	258.05	600.0
2019-08-16 07:00:00	DIA	ETF	258.26	258.26	258.0	258.0	2750.0

> showing 50 of 10,923 rows — these rows as CSV

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