PREVIEW / etf_1hour / 2020-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-13.parquet
  size:    363 KB
  rows:    11,953

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-13 04:00:00	SPY	ETF	336.1	336.1	335.07	335.32	30078.0
2020-02-13 05:00:00	SPY	ETF	335.28	335.52	334.62	335.25	36451.0
2020-02-13 06:00:00	SPY	ETF	335.12	335.61	334.89	335.37	190316.0
2020-02-13 07:00:00	SPY	ETF	335.41	335.71	335.15	335.61	629371.0
2020-02-13 08:00:00	SPY	ETF	335.66	336.52	335.22	336.14	762765.0
2020-02-13 09:00:00	SPY	ETF	336.07	336.845	335.56	336.12	6114976.0
2020-02-13 10:00:00	SPY	ETF	336.13	337.13	335.6	337.08	7437122.0
2020-02-13 11:00:00	SPY	ETF	337.07	337.63	336.9	337.3	5319354.0
2020-02-13 12:00:00	SPY	ETF	337.29	337.73	337.19	337.2	3810451.0
2020-02-13 13:00:00	SPY	ETF	337.2	338.0	337.01	337.88	4505688.0
2020-02-13 14:00:00	SPY	ETF	337.865	338.12	337.56	337.88	4096821.0
2020-02-13 15:00:00	SPY	ETF	337.87	338.0	336.77	337.08	14506636.0
2020-02-13 16:00:00	SPY	ETF	337.08	337.5283	336.9679	337.5	4559147.0
2020-02-13 17:00:00	SPY	ETF	337.51	337.59	337.06	337.53	163940.0
2020-02-13 18:00:00	SPY	ETF	337.53	337.53	336.87	337.06	361403.0
2020-02-13 19:00:00	SPY	ETF	337.06	337.39	336.85	337.37	92099.0
2020-02-13 04:00:00	QQQ	ETF	233.08	233.08	232.25	232.44	52000.0
2020-02-13 05:00:00	QQQ	ETF	232.26	232.57	231.7	232.41	54217.0
2020-02-13 06:00:00	QQQ	ETF	232.38	232.82	232.1	232.6	89632.0
2020-02-13 07:00:00	QQQ	ETF	232.63	232.79	232.01	232.53	362093.0
2020-02-13 08:00:00	QQQ	ETF	232.7501	233.45	232.1	232.92	508594.0
2020-02-13 09:00:00	QQQ	ETF	232.91	233.66	232.36	233.12	3334298.0
2020-02-13 10:00:00	QQQ	ETF	233.14	234.07	232.72	234.0148	2869690.0
2020-02-13 11:00:00	QQQ	ETF	234.03	234.57	233.9201	234.2101	2364270.0
2020-02-13 12:00:00	QQQ	ETF	234.215	234.59	233.94	233.9433	1725473.0
2020-02-13 13:00:00	QQQ	ETF	233.95	234.88	233.83	234.78	1946486.0
2020-02-13 14:00:00	QQQ	ETF	234.75	234.93	234.43	234.6561	2356891.0
2020-02-13 15:00:00	QQQ	ETF	234.65	234.78	233.71	233.94	3742955.0
2020-02-13 16:00:00	QQQ	ETF	233.93	234.46	233.8957	234.45	1046981.0
2020-02-13 17:00:00	QQQ	ETF	234.32	234.45	234.31	234.42	22967.0
2020-02-13 18:00:00	QQQ	ETF	234.42	234.43	233.9	233.97	55587.0
2020-02-13 19:00:00	QQQ	ETF	234.1	234.29	233.87	234.26	37478.0
2020-02-13 04:00:00	IWM	ETF	167.3	167.32	166.84	166.84	13929.0
2020-02-13 05:00:00	IWM	ETF	166.65	166.94	166.64	166.94	10300.0
2020-02-13 06:00:00	IWM	ETF	166.7	167.05	166.7	167.05	11400.0
2020-02-13 07:00:00	IWM	ETF	166.91	167.12	166.87	167.12	128498.0
2020-02-13 08:00:00	IWM	ETF	167.1	167.57	167.01	167.44	43597.0
2020-02-13 09:00:00	IWM	ETF	167.35	168.16	167.15	167.4025	1759219.0
2020-02-13 10:00:00	IWM	ETF	167.415	168.16	167.11	168.135	1301718.0
2020-02-13 11:00:00	IWM	ETF	168.13	168.39	167.83	168.18	1023891.0
2020-02-13 12:00:00	IWM	ETF	168.18	168.65	168.16	168.16	668024.0
2020-02-13 13:00:00	IWM	ETF	168.16	168.71	168.1002	168.685	710338.0
2020-02-13 14:00:00	IWM	ETF	168.67	168.95	168.61	168.86	1797317.0
2020-02-13 15:00:00	IWM	ETF	168.86	168.9197	168.31	168.54	2685264.0
2020-02-13 16:00:00	IWM	ETF	168.56	168.84	168.37	168.83	998020.0
2020-02-13 17:00:00	IWM	ETF	168.55	168.55	168.55	168.55	27894.0
2020-02-13 18:00:00	IWM	ETF	168.7	168.72	168.49	168.51	20836.0
2020-02-13 19:00:00	IWM	ETF	168.55	168.74	168.55	168.73	12180.0
2020-02-13 04:00:00	DIA	ETF	294.17	294.17	293.96	293.96	701.0
2020-02-13 05:00:00	DIA	ETF	293.56	293.56	293.49	293.49	3400.0

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

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