PREVIEW / etf_1hour / 2019-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-09.parquet
  size:    326 KB
  rows:    10,871

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-09 04:00:00	SPY	ETF	292.38	292.38	292.01	292.29	7587.0
2019-08-09 05:00:00	SPY	ETF	292.43	292.68	292.0	292.06	37336.0
2019-08-09 06:00:00	SPY	ETF	292.09	292.24	291.78	292.08	78977.0
2019-08-09 07:00:00	SPY	ETF	292.11	292.11	291.52	291.85	247217.0
2019-08-09 08:00:00	SPY	ETF	291.83	293.62	291.61	292.28	440808.0
2019-08-09 09:00:00	SPY	ETF	292.21	293.24	291.765	292.0	8927655.0
2019-08-09 10:00:00	SPY	ETF	292.0	292.3765	290.48	291.34	14194249.0
2019-08-09 11:00:00	SPY	ETF	291.35	291.49	289.65	289.9268	9648433.0
2019-08-09 12:00:00	SPY	ETF	289.93	292.04	289.7	291.09	10577404.0
2019-08-09 13:00:00	SPY	ETF	291.08	292.5	291.01	291.98	9938412.0
2019-08-09 14:00:00	SPY	ETF	291.97	292.38	291.71	291.94	6696391.0
2019-08-09 15:00:00	SPY	ETF	291.935	292.97	291.42	291.59	19403191.0
2019-08-09 16:00:00	SPY	ETF	291.57	293.4935	291.44	292.05	10009305.0
2019-08-09 17:00:00	SPY	ETF	292.03	292.03	291.62	292.0	2161946.0
2019-08-09 18:00:00	SPY	ETF	291.95	292.02	291.93	291.95	39174.0
2019-08-09 19:00:00	SPY	ETF	291.95	291.95	291.85	291.93	25198.0
2019-08-09 04:00:00	QQQ	ETF	187.28	187.28	186.93	187.14	24655.0
2019-08-09 05:00:00	QQQ	ETF	187.14	187.35	186.9	186.91	23981.0
2019-08-09 06:00:00	QQQ	ETF	186.95	187.04	186.75	186.86	12608.0
2019-08-09 07:00:00	QQQ	ETF	186.87	186.93	186.5	186.74	189958.0
2019-08-09 08:00:00	QQQ	ETF	186.69	188.26	186.52	187.1	291920.0
2019-08-09 09:00:00	QQQ	ETF	187.1	188.0	186.62	186.93	3553902.0
2019-08-09 10:00:00	QQQ	ETF	186.94	187.25	185.69	186.49	5452524.0
2019-08-09 11:00:00	QQQ	ETF	186.48	186.58	185.03	185.23	3730614.0
2019-08-09 12:00:00	QQQ	ETF	185.21	186.73	185.12	186.23	3686199.0
2019-08-09 13:00:00	QQQ	ETF	186.2	187.34	186.15	186.7966	3230882.0
2019-08-09 14:00:00	QQQ	ETF	186.79	187.07	186.53	186.685	1803874.0
2019-08-09 15:00:00	QQQ	ETF	186.71	187.415	186.32	186.45	4760862.0
2019-08-09 16:00:00	QQQ	ETF	186.44	186.86	186.36	186.75	1139787.0
2019-08-09 17:00:00	QQQ	ETF	186.85	186.85	186.4	186.54	39857.0
2019-08-09 18:00:00	QQQ	ETF	186.54	186.62	186.45	186.53	3848.0
2019-08-09 19:00:00	QQQ	ETF	186.54	186.6	186.49	186.49	7836.0
2019-08-09 04:00:00	IWM	ETF	151.95	151.95	151.95	151.95	193.0
2019-08-09 06:00:00	IWM	ETF	151.81	151.81	151.81	151.81	200.0
2019-08-09 07:00:00	IWM	ETF	151.78	151.86	151.52	151.75	51300.0
2019-08-09 08:00:00	IWM	ETF	151.83	152.09	151.72	152.05	97646.0
2019-08-09 09:00:00	IWM	ETF	152.05	152.23	151.05	151.18	2163947.0
2019-08-09 10:00:00	IWM	ETF	151.18	151.45	150.36	150.59	2753971.0
2019-08-09 11:00:00	IWM	ETF	150.57	150.73	150.03	150.36	2069755.0
2019-08-09 12:00:00	IWM	ETF	150.36	151.11	150.15	150.61	1885353.0
2019-08-09 13:00:00	IWM	ETF	150.6	151.27	150.4	150.641	2095663.0
2019-08-09 14:00:00	IWM	ETF	150.66	150.85	150.43	150.69	1429496.0
2019-08-09 15:00:00	IWM	ETF	150.7	151.12	150.5	150.58	3724095.0
2019-08-09 16:00:00	IWM	ETF	150.57	150.89	150.42	150.79	916655.0
2019-08-09 17:00:00	IWM	ETF	150.85	150.85	150.65	150.65	618.0
2019-08-09 18:00:00	IWM	ETF	150.78	150.78	150.78	150.78	100.0
2019-08-09 19:00:00	IWM	ETF	150.65	150.65	150.62	150.62	1098.0
2019-08-09 04:00:00	DIA	ETF	263.16	263.16	263.16	263.16	100.0
2019-08-09 06:00:00	DIA	ETF	262.96	262.96	262.72	262.72	600.0
2019-08-09 07:00:00	DIA	ETF	262.75	262.75	262.56	262.67	2600.0

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

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