PREVIEW / etf_1hour / 2019-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-18.parquet
  size:    335 KB
  rows:    10,913

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-07-18 04:00:00	SPY	ETF	297.28	297.28	296.79	296.88	35138.0
2019-07-18 05:00:00	SPY	ETF	297.07	297.32	297.07	297.17	16284.0
2019-07-18 06:00:00	SPY	ETF	297.17	297.51	297.12	297.5	47283.0
2019-07-18 07:00:00	SPY	ETF	297.48	297.68	297.34	297.38	180007.0
2019-07-18 08:00:00	SPY	ETF	297.5001	297.79	296.72	297.48	241507.0
2019-07-18 09:00:00	SPY	ETF	297.43	297.7	297.05	297.535	4849930.0
2019-07-18 10:00:00	SPY	ETF	297.535	298.12	297.32	297.85	5454255.0
2019-07-18 11:00:00	SPY	ETF	297.85	297.94	296.7	296.845	5762065.0
2019-07-18 12:00:00	SPY	ETF	296.84	297.64	296.79	297.43	5409075.0
2019-07-18 13:00:00	SPY	ETF	297.435	297.79	297.4	297.64	3700148.0
2019-07-18 14:00:00	SPY	ETF	297.64	298.9353	297.6215	298.92	9214278.0
2019-07-18 15:00:00	SPY	ETF	298.92	299.25	298.38	298.85	10868648.0
2019-07-18 16:00:00	SPY	ETF	298.85	299.62	298.68	299.5	4973038.0
2019-07-18 17:00:00	SPY	ETF	299.49	299.54	298.83	299.54	66610.0
2019-07-18 18:00:00	SPY	ETF	299.54	300.0	298.81	298.84	297780.0
2019-07-18 19:00:00	SPY	ETF	298.86	299.35	298.79	299.19	70229.0
2019-07-18 04:00:00	QQQ	ETF	191.2	191.2	190.94	191.04	4644.0
2019-07-18 05:00:00	QQQ	ETF	191.18	191.32	191.15	191.18	10055.0
2019-07-18 06:00:00	QQQ	ETF	191.2	191.4	191.13	191.37	36375.0
2019-07-18 07:00:00	QQQ	ETF	191.36	191.5	191.32	191.34	41246.0
2019-07-18 08:00:00	QQQ	ETF	191.3401	191.73	190.48	191.5	139609.0
2019-07-18 09:00:00	QQQ	ETF	191.49	192.07	191.17	191.75	2608536.0
2019-07-18 10:00:00	QQQ	ETF	191.7599	192.14	191.41	191.53	3680328.0
2019-07-18 11:00:00	QQQ	ETF	191.54	191.62	190.69	190.77	3776522.0
2019-07-18 12:00:00	QQQ	ETF	190.77	191.31	190.71	191.12	2731377.0
2019-07-18 13:00:00	QQQ	ETF	191.12	191.495	191.1	191.3899	1312913.0
2019-07-18 14:00:00	QQQ	ETF	191.38	192.55	191.37	192.5485	3438678.0
2019-07-18 15:00:00	QQQ	ETF	192.54	192.79	192.08	192.53	4141035.0
2019-07-18 16:00:00	QQQ	ETF	192.54	193.33	192.31	193.21	2172375.0
2019-07-18 17:00:00	QQQ	ETF	193.25	193.28	193.1	193.21	20374.0
2019-07-18 18:00:00	QQQ	ETF	193.25	193.81	192.95	192.95	126446.0
2019-07-18 19:00:00	QQQ	ETF	192.95	193.32	192.94	193.15	110823.0
2019-07-18 04:00:00	IWM	ETF	153.92	153.92	153.81	153.81	4000.0
2019-07-18 05:00:00	IWM	ETF	153.98	154.19	153.98	154.13	5693.0
2019-07-18 06:00:00	IWM	ETF	154.1	154.32	154.1	154.32	500.0
2019-07-18 07:00:00	IWM	ETF	154.31	154.39	154.21	154.24	5250.0
2019-07-18 08:00:00	IWM	ETF	154.26	154.45	153.78	154.38	19828.0
2019-07-18 09:00:00	IWM	ETF	154.25	154.41	153.74	153.88	2214852.0
2019-07-18 10:00:00	IWM	ETF	153.89	154.3284	153.73	154.31	2287943.0
2019-07-18 11:00:00	IWM	ETF	154.32	154.42	153.735	154.05	1462508.0
2019-07-18 12:00:00	IWM	ETF	154.06	154.75	153.9901	154.28	1974102.0
2019-07-18 13:00:00	IWM	ETF	154.28	154.42	154.11	154.21	762517.0
2019-07-18 14:00:00	IWM	ETF	154.22	154.8384	154.2099	154.83	1378110.0
2019-07-18 15:00:00	IWM	ETF	154.84	155.01	154.47	154.7	3064151.0
2019-07-18 16:00:00	IWM	ETF	154.71	155.13	154.62	154.99	797384.0
2019-07-18 17:00:00	IWM	ETF	155.16	155.16	154.98	154.98	2537.0
2019-07-18 18:00:00	IWM	ETF	155.09	155.24	154.72	154.73	49812.0
2019-07-18 19:00:00	IWM	ETF	154.9	154.91	154.89	154.91	1800.0
2019-07-18 04:00:00	DIA	ETF	271.54	271.6	271.54	271.56	400.0
2019-07-18 06:00:00	DIA	ETF	272.08	272.36	272.08	272.3	1000.0

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

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