PREVIEW / etf_1hour / 2020-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-06.parquet
  size:    360 KB
  rows:    12,177

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-02-06 04:00:00	SPY	ETF	334.48	334.64	333.78	333.91	27767.0
2020-02-06 05:00:00	SPY	ETF	333.8	333.95	333.64	333.64	6580.0
2020-02-06 06:00:00	SPY	ETF	333.68	334.5	333.68	334.5	24382.0
2020-02-06 07:00:00	SPY	ETF	334.43	334.51	333.91	334.0	251807.0
2020-02-06 08:00:00	SPY	ETF	334.15	335.15	332.86	333.99	382737.0
2020-02-06 09:00:00	SPY	ETF	333.97	334.11	332.8	333.73	6961516.0
2020-02-06 10:00:00	SPY	ETF	333.73	333.95	332.94	333.5	7776940.0
2020-02-06 11:00:00	SPY	ETF	333.51	334.06	333.32	333.4705	5496352.0
2020-02-06 12:00:00	SPY	ETF	333.46	334.125	333.42	334.065	3332813.0
2020-02-06 13:00:00	SPY	ETF	334.055	334.19	333.51	333.8701	3909726.0
2020-02-06 14:00:00	SPY	ETF	333.87	334.11	333.71	333.77	6027468.0
2020-02-06 15:00:00	SPY	ETF	333.78	334.09	333.49	333.96	9504485.0
2020-02-06 16:00:00	SPY	ETF	333.96	334.32	332.8263	334.3	3811198.0
2020-02-06 17:00:00	SPY	ETF	334.37	334.51	333.916	334.36	1585746.0
2020-02-06 18:00:00	SPY	ETF	334.38	334.52	334.26	334.44	112173.0
2020-02-06 19:00:00	SPY	ETF	334.45	334.47	333.24	333.63	255327.0
2020-02-06 04:00:00	QQQ	ETF	229.71	229.91	229.2	229.34	58250.0
2020-02-06 05:00:00	QQQ	ETF	229.19	229.35	228.98	228.98	25850.0
2020-02-06 06:00:00	QQQ	ETF	228.93	229.72	228.93	229.72	35718.0
2020-02-06 07:00:00	QQQ	ETF	229.68	229.76	229.19	229.29	164568.0
2020-02-06 08:00:00	QQQ	ETF	229.27	230.25	228.22	229.07	308249.0
2020-02-06 09:00:00	QQQ	ETF	228.98	229.22	227.98	229.22	3290450.0
2020-02-06 10:00:00	QQQ	ETF	229.21	229.46	228.66	229.31	2587141.0
2020-02-06 11:00:00	QQQ	ETF	229.335	229.9869	229.19	229.51	2190637.0
2020-02-06 12:00:00	QQQ	ETF	229.5	230.12	229.4501	230.09	1529306.0
2020-02-06 13:00:00	QQQ	ETF	230.09	230.1686	229.665	229.92	1345491.0
2020-02-06 14:00:00	QQQ	ETF	229.92	230.05	229.6592	229.67	1148788.0
2020-02-06 15:00:00	QQQ	ETF	229.67	230.25	229.51	230.17	2501515.0
2020-02-06 16:00:00	QQQ	ETF	230.18	230.42	229.97	230.41	1498642.0
2020-02-06 17:00:00	QQQ	ETF	230.41	230.41	230.3	230.3	40644.0
2020-02-06 18:00:00	QQQ	ETF	230.4	230.58	230.36	230.49	60530.0
2020-02-06 19:00:00	QQQ	ETF	230.56	230.56	229.62	229.8699	108974.0
2020-02-06 04:00:00	IWM	ETF	168.19	168.19	167.94	167.94	1474.0
2020-02-06 05:00:00	IWM	ETF	167.89	167.89	167.81	167.81	6100.0
2020-02-06 06:00:00	IWM	ETF	167.83	168.12	167.83	168.02	11001.0
2020-02-06 07:00:00	IWM	ETF	168.19	168.2	167.83	167.86	28380.0
2020-02-06 08:00:00	IWM	ETF	167.87	168.1	167.31	167.93	103232.0
2020-02-06 09:00:00	IWM	ETF	167.77	168.15	166.93	167.69	2357347.0
2020-02-06 10:00:00	IWM	ETF	167.69	167.83	166.84	167.06	1775604.0
2020-02-06 11:00:00	IWM	ETF	167.07	167.48	166.85	166.89	1334400.0
2020-02-06 12:00:00	IWM	ETF	166.88	167.49	166.7491	167.1	816190.0
2020-02-06 13:00:00	IWM	ETF	167.09	167.3	166.76	167.04	748813.0
2020-02-06 14:00:00	IWM	ETF	167.03	167.12	166.8	166.905	1001701.0
2020-02-06 15:00:00	IWM	ETF	166.91	167.22	166.81	166.93	2223850.0
2020-02-06 16:00:00	IWM	ETF	166.92	167.2954	166.8	167.2	2437445.0
2020-02-06 17:00:00	IWM	ETF	167.21	167.27	167.06	167.26	11326.0
2020-02-06 18:00:00	IWM	ETF	167.27	167.29	167.16	167.19	8900.0
2020-02-06 19:00:00	IWM	ETF	167.27	167.27	166.61	166.8	16118.0
2020-02-06 04:00:00	DIA	ETF	294.47	294.47	294.13	294.36	1710.0
2020-02-06 05:00:00	DIA	ETF	293.84	293.87	293.68	293.68	735.0

> showing 50 of 12,177 rows — these rows as CSV

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