PREVIEW / etf_1hour / 2021-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-19.parquet
  size:    434 KB
  rows:    15,213

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
2021-10-19 04:00:00	SPY	ETF	448.14	448.8	448.03	448.58	20468.0
2021-10-19 05:00:00	SPY	ETF	448.52	448.96	448.43	448.84	15890.0
2021-10-19 06:00:00	SPY	ETF	448.78	449.64	448.78	449.57	56693.0
2021-10-19 07:00:00	SPY	ETF	449.56	449.95	449.36	449.5	168060.0
2021-10-19 08:00:00	SPY	ETF	449.1604	449.93	447.3	448.89	310048.0
2021-10-19 09:00:00	SPY	ETF	448.89	449.27	448.27	448.63	5746523.0
2021-10-19 10:00:00	SPY	ETF	448.63	449.95	448.57	449.85	6042384.0
2021-10-19 11:00:00	SPY	ETF	449.85	450.32	449.83	450.205	4404323.0
2021-10-19 12:00:00	SPY	ETF	450.21	450.56	450.0	450.53	2925771.0
2021-10-19 13:00:00	SPY	ETF	450.53	450.55	450.18	450.41	2791346.0
2021-10-19 14:00:00	SPY	ETF	450.4101	450.47	449.6	449.999	4204183.0
2021-10-19 15:00:00	SPY	ETF	449.99	450.7	449.89	450.68	9416711.0
2021-10-19 16:00:00	SPY	ETF	450.68	451.22	450.4	451.0	3077204.0
2021-10-19 17:00:00	SPY	ETF	450.86	450.99	450.83	450.94	40404.0
2021-10-19 18:00:00	SPY	ETF	450.96	451.05	450.63	450.82	70688.0
2021-10-19 19:00:00	SPY	ETF	450.77	451.17	450.7	451.06	56923.0
2021-10-19 04:00:00	QQQ	ETF	373.27	374.0	373.18	373.74	66141.0
2021-10-19 05:00:00	QQQ	ETF	373.6	373.95	373.48	373.78	45332.0
2021-10-19 06:00:00	QQQ	ETF	373.8	374.25	373.7	374.21	101999.0
2021-10-19 07:00:00	QQQ	ETF	374.2	374.58	374.01	374.37	215930.0
2021-10-19 08:00:00	QQQ	ETF	374.0599	374.57	372.74	373.7	324958.0
2021-10-19 09:00:00	QQQ	ETF	373.7	374.42	373.05	373.56	4174993.0
2021-10-19 10:00:00	QQQ	ETF	373.57	374.86	373.29	374.85	3852376.0
2021-10-19 11:00:00	QQQ	ETF	374.85	375.11	374.46	375.01	2240007.0
2021-10-19 12:00:00	QQQ	ETF	375.03	375.31	374.82	375.27	1787175.0
2021-10-19 13:00:00	QQQ	ETF	375.26	375.37	375.02	375.31	1615349.0
2021-10-19 14:00:00	QQQ	ETF	375.31	375.4	374.52	374.86	2100885.0
2021-10-19 15:00:00	QQQ	ETF	374.86	375.52	374.7601	375.44	4821411.0
2021-10-19 16:00:00	QQQ	ETF	375.44	376.1	375.36	375.69	1245329.0
2021-10-19 17:00:00	QQQ	ETF	375.84	375.84	375.5	375.6	22677.0
2021-10-19 18:00:00	QQQ	ETF	375.66	375.68	375.24	375.51	110589.0
2021-10-19 19:00:00	QQQ	ETF	375.46	375.75	375.43	375.64	74530.0
2021-10-19 04:00:00	IWM	ETF	225.34	225.87	225.34	225.85	9032.0
2021-10-19 05:00:00	IWM	ETF	225.89	226.16	225.86	226.12	37778.0
2021-10-19 06:00:00	IWM	ETF	226.08	226.94	226.05	226.83	41021.0
2021-10-19 07:00:00	IWM	ETF	226.85	227.16	226.57	226.58	91692.0
2021-10-19 08:00:00	IWM	ETF	226.6	227.1	225.14	226.04	91640.0
2021-10-19 09:00:00	IWM	ETF	226.06	226.28	224.8125	224.85	2238214.0
2021-10-19 10:00:00	IWM	ETF	224.86	225.34	224.61	225.33	1768975.0
2021-10-19 11:00:00	IWM	ETF	225.34	226.46	225.27	226.34	1389468.0
2021-10-19 12:00:00	IWM	ETF	226.35	226.8	226.17	226.8	1225650.0
2021-10-19 13:00:00	IWM	ETF	226.805	226.88	226.26	226.36	936443.0
2021-10-19 14:00:00	IWM	ETF	226.34	226.41	225.29	225.85	1222431.0
2021-10-19 15:00:00	IWM	ETF	225.84	226.19	225.44	225.87	2988659.0
2021-10-19 16:00:00	IWM	ETF	225.87	226.06	225.79	225.91	452698.0
2021-10-19 17:00:00	IWM	ETF	225.76	226.04	225.76	225.98	5883.0
2021-10-19 18:00:00	IWM	ETF	225.93	225.93	225.73	225.86	23373.0
2021-10-19 19:00:00	IWM	ETF	225.87	226.18	225.85	226.12	23413.0
2021-10-19 04:00:00	DIA	ETF	353.0	353.48	353.0	353.22	4900.0
2021-10-19 06:00:00	DIA	ETF	353.65	354.28	353.65	354.23	2522.0

> showing 50 of 15,213 rows — these rows as CSV

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