PREVIEW / etf_1hour / 2020-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-12.parquet
  size:    361 KB
  rows:    11,964

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-12 04:00:00	SPY	ETF	336.63	336.73	336.3	336.49	45454.0
2020-02-12 05:00:00	SPY	ETF	336.49	336.68	336.3	336.68	16592.0
2020-02-12 06:00:00	SPY	ETF	336.62	336.71	336.56	336.58	75298.0
2020-02-12 07:00:00	SPY	ETF	336.61	336.67	336.33	336.46	160881.0
2020-02-12 08:00:00	SPY	ETF	336.45	336.83	335.26	336.69	291431.0
2020-02-12 09:00:00	SPY	ETF	336.74	337.28	336.6124	337.0	5847987.0
2020-02-12 10:00:00	SPY	ETF	337.01	337.2	336.43	336.5763	5017514.0
2020-02-12 11:00:00	SPY	ETF	336.58	337.2	336.58	336.99	3568249.0
2020-02-12 12:00:00	SPY	ETF	337.0	337.23	336.8	337.0	3106060.0
2020-02-12 13:00:00	SPY	ETF	337.0	337.05	336.53	336.99	5010487.0
2020-02-12 14:00:00	SPY	ETF	336.99	337.32	336.93	337.2	4816125.0
2020-02-12 15:00:00	SPY	ETF	337.19	337.65	336.92	337.41	7926499.0
2020-02-12 16:00:00	SPY	ETF	337.42	337.69	335.2577	337.63	5987687.0
2020-02-12 17:00:00	SPY	ETF	337.58	337.6	337.47	337.57	109385.0
2020-02-12 18:00:00	SPY	ETF	337.57	337.77	335.95	336.18	980639.0
2020-02-12 19:00:00	SPY	ETF	336.24	336.77	336.08	336.43	165947.0
2020-02-12 04:00:00	QQQ	ETF	233.07	233.26	233.06	233.2	40464.0
2020-02-12 05:00:00	QQQ	ETF	233.13	233.22	233.03	233.22	12768.0
2020-02-12 06:00:00	QQQ	ETF	233.25	233.38	233.2	233.29	33933.0
2020-02-12 07:00:00	QQQ	ETF	233.28	233.3	232.92	233.06	200784.0
2020-02-12 08:00:00	QQQ	ETF	233.07	233.35	232.0	233.21	220704.0
2020-02-12 09:00:00	QQQ	ETF	233.23	233.875	232.84	233.35	3690666.0
2020-02-12 10:00:00	QQQ	ETF	233.36	233.56	232.8	233.12	3744195.0
2020-02-12 11:00:00	QQQ	ETF	233.1479	234.06	233.12	233.83	1967364.0
2020-02-12 12:00:00	QQQ	ETF	233.837	234.26	233.68	234.138	1417978.0
2020-02-12 13:00:00	QQQ	ETF	234.14	234.198	233.76	234.0	1097396.0
2020-02-12 14:00:00	QQQ	ETF	234.01	234.12	233.82	233.95	1165430.0
2020-02-12 15:00:00	QQQ	ETF	233.97	234.38	233.7	234.29	3486679.0
2020-02-12 16:00:00	QQQ	ETF	234.28	234.46	234.13	234.41	1166486.0
2020-02-12 17:00:00	QQQ	ETF	234.41	234.41	234.19	234.27	46539.0
2020-02-12 18:00:00	QQQ	ETF	234.28	234.4	232.92	233.14	243788.0
2020-02-12 19:00:00	QQQ	ETF	233.15	233.68	233.14	233.35	325301.0
2020-02-12 05:00:00	IWM	ETF	167.59	167.65	167.59	167.65	4900.0
2020-02-12 06:00:00	IWM	ETF	167.77	167.78	167.72	167.74	5800.0
2020-02-12 07:00:00	IWM	ETF	167.74	167.81	167.65	167.74	26438.0
2020-02-12 08:00:00	IWM	ETF	167.7499	167.92	167.7499	167.87	25377.0
2020-02-12 09:00:00	IWM	ETF	167.85	168.29	167.475	167.555	2085401.0
2020-02-12 10:00:00	IWM	ETF	167.57	167.75	167.28	167.48	1123953.0
2020-02-12 11:00:00	IWM	ETF	167.49	167.76	167.42	167.6	662638.0
2020-02-12 12:00:00	IWM	ETF	167.615	167.93	167.48	167.885	594615.0
2020-02-12 13:00:00	IWM	ETF	167.8884	168.06	167.63	168.025	755800.0
2020-02-12 14:00:00	IWM	ETF	168.02	168.19	167.93	168.11	852262.0
2020-02-12 15:00:00	IWM	ETF	168.11	168.21	167.92	168.08	2036014.0
2020-02-12 16:00:00	IWM	ETF	168.11	168.16	166.8767	168.13	955866.0
2020-02-12 17:00:00	IWM	ETF	168.11	168.11	168.11	168.11	147600.0
2020-02-12 18:00:00	IWM	ETF	168.14	168.24	167.49	167.49	12287.0
2020-02-12 19:00:00	IWM	ETF	167.42	167.72	167.39	167.53	14800.0
2020-02-12 04:00:00	DIA	ETF	293.97	294.14	293.97	294.14	200.0
2020-02-12 05:00:00	DIA	ETF	294.0	294.0	294.0	294.0	100.0
2020-02-12 06:00:00	DIA	ETF	294.2	294.32	294.17	294.17	20967.0

> showing 50 of 11,964 rows — these rows as CSV

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