PREVIEW / etf_1hour / 2020-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-16.parquet
  size:    405 KB
  rows:    14,005

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-11-16 04:00:00	SPY	ETF	360.58	361.3	360.47	361.13	37280.0
2020-11-16 05:00:00	SPY	ETF	361.27	361.28	360.7	360.99	10005.0
2020-11-16 06:00:00	SPY	ETF	361.06	363.67	360.7	361.84	314064.0
2020-11-16 07:00:00	SPY	ETF	361.83	362.95	361.46	362.0	1090572.0
2020-11-16 08:00:00	SPY	ETF	361.95	362.85	360.7	361.22	655557.0
2020-11-16 09:00:00	SPY	ETF	361.25	361.76	359.59	360.4	9288470.0
2020-11-16 10:00:00	SPY	ETF	360.4	361.93	360.195	361.93	7607390.0
2020-11-16 11:00:00	SPY	ETF	361.94	362.25	361.65	361.77	5298443.0
2020-11-16 12:00:00	SPY	ETF	361.775	361.98	360.81	361.1	4664399.0
2020-11-16 13:00:00	SPY	ETF	361.1011	361.11	359.6499	360.57	6145617.0
2020-11-16 14:00:00	SPY	ETF	360.58	361.24	360.22	360.919	6998163.0
2020-11-16 15:00:00	SPY	ETF	360.93	362.59	360.24	362.44	20956833.0
2020-11-16 16:00:00	SPY	ETF	362.47	362.97	357.9984	362.73	8055628.0
2020-11-16 17:00:00	SPY	ETF	362.77	362.82	362.6	362.6	214905.0
2020-11-16 18:00:00	SPY	ETF	362.57	362.81	362.27	362.35	328636.0
2020-11-16 19:00:00	SPY	ETF	362.34	362.34	361.6	361.76	327245.0
2020-11-16 04:00:00	QQQ	ETF	292.5	293.0	292.45	292.79	27519.0
2020-11-16 05:00:00	QQQ	ETF	292.75	292.88	292.33	292.55	21178.0
2020-11-16 06:00:00	QQQ	ETF	292.51	293.04	290.9	290.94	134746.0
2020-11-16 07:00:00	QQQ	ETF	291.0	291.56	289.18	290.77	513551.0
2020-11-16 08:00:00	QQQ	ETF	291.2799	293.7	289.3	290.32	728084.0
2020-11-16 09:00:00	QQQ	ETF	290.27	292.45	289.99	291.88	4689540.0
2020-11-16 10:00:00	QQQ	ETF	291.88	293.08	291.565	293.08	3603478.0
2020-11-16 11:00:00	QQQ	ETF	293.085	293.51	292.07	292.57	2311486.0
2020-11-16 12:00:00	QQQ	ETF	292.59	292.8582	291.54	291.8482	2044795.0
2020-11-16 13:00:00	QQQ	ETF	291.83	292.0786	291.01	291.985	2087700.0
2020-11-16 14:00:00	QQQ	ETF	291.99	292.4	291.58	291.73	2096868.0
2020-11-16 15:00:00	QQQ	ETF	291.73	293.15	291.32	293.05	4329136.0
2020-11-16 16:00:00	QQQ	ETF	293.03	293.7	292.8865	293.2	1736268.0
2020-11-16 17:00:00	QQQ	ETF	293.69	294.38	293.61	294.19	140401.0
2020-11-16 18:00:00	QQQ	ETF	294.3	294.81	292.84	293.9	337517.0
2020-11-16 19:00:00	QQQ	ETF	293.95	294.09	293.59	293.87	91791.0
2020-11-16 04:00:00	IWM	ETF	175.07	175.73	175.0	175.73	18564.0
2020-11-16 05:00:00	IWM	ETF	175.68	175.9	175.4	175.46	16668.0
2020-11-16 06:00:00	IWM	ETF	175.63	178.27	175.39	177.68	174543.0
2020-11-16 07:00:00	IWM	ETF	176.97	178.43	176.74	177.59	484220.0
2020-11-16 08:00:00	IWM	ETF	177.73	178.4396	175.02	176.74	316086.0
2020-11-16 09:00:00	IWM	ETF	177.02	177.49	175.4	176.11	5071759.0
2020-11-16 10:00:00	IWM	ETF	176.12	177.55	176.03	177.33	3916276.0
2020-11-16 11:00:00	IWM	ETF	177.34	177.78	177.03	177.54	2499852.0
2020-11-16 12:00:00	IWM	ETF	177.55	177.65	176.78	176.93	1920642.0
2020-11-16 13:00:00	IWM	ETF	176.92	177.0	175.775	176.005	2040685.0
2020-11-16 14:00:00	IWM	ETF	176.01	176.76	175.68	176.65	2061981.0
2020-11-16 15:00:00	IWM	ETF	176.65	177.61	176.27	177.59	4977191.0
2020-11-16 16:00:00	IWM	ETF	177.59	177.97	176.8443	177.68	2477989.0
2020-11-16 17:00:00	IWM	ETF	177.73	177.98	177.66	177.8	97911.0
2020-11-16 18:00:00	IWM	ETF	177.73	177.76	177.4	177.57	568361.0
2020-11-16 19:00:00	IWM	ETF	177.5	177.5	177.21	177.27	20488.0
2020-11-16 04:00:00	DIA	ETF	297.58	298.07	297.58	298.07	1315.0
2020-11-16 05:00:00	DIA	ETF	297.91	297.94	297.91	297.94	1300.0

> showing 50 of 14,005 rows — these rows as CSV

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