PREVIEW / etf_1hour / 2021-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-21.parquet
  size:    418 KB
  rows:    14,322

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-04-21 04:00:00	SPY	ETF	411.8	412.49	411.8	412.08	7292.0
2021-04-21 05:00:00	SPY	ETF	412.17	412.36	411.75	412.04	83108.0
2021-04-21 06:00:00	SPY	ETF	412.17	412.66	411.8	412.66	42859.0
2021-04-21 07:00:00	SPY	ETF	412.77	412.77	411.98	412.11	181517.0
2021-04-21 08:00:00	SPY	ETF	412.41	412.7104	411.07	411.47	440684.0
2021-04-21 09:00:00	SPY	ETF	411.42	413.43	411.32	413.41	6562525.0
2021-04-21 10:00:00	SPY	ETF	413.41	414.1	412.995	413.7659	8058804.0
2021-04-21 11:00:00	SPY	ETF	413.77	414.93	413.61	414.89	6976569.0
2021-04-21 12:00:00	SPY	ETF	414.89	414.92	414.361	414.465	4145663.0
2021-04-21 13:00:00	SPY	ETF	414.4644	414.94	414.45	414.915	3118997.0
2021-04-21 14:00:00	SPY	ETF	414.915	415.26	414.76	414.96	3664042.0
2021-04-21 15:00:00	SPY	ETF	414.95	416.29	414.825	416.09	15699475.0
2021-04-21 16:00:00	SPY	ETF	416.08	416.0962	415.24	415.3	5970085.0
2021-04-21 17:00:00	SPY	ETF	415.39	415.4	415.11	415.29	97704.0
2021-04-21 18:00:00	SPY	ETF	415.29	416.07	415.07	415.2	138155.0
2021-04-21 19:00:00	SPY	ETF	415.16	415.32	414.93	414.94	362738.0
2021-04-21 04:00:00	QQQ	ETF	335.0	335.55	335.0	335.2	27839.0
2021-04-21 05:00:00	QQQ	ETF	335.33	335.88	335.14	335.42	30556.0
2021-04-21 06:00:00	QQQ	ETF	335.41	336.06	335.41	336.06	38769.0
2021-04-21 07:00:00	QQQ	ETF	336.06	336.06	335.37	335.51	130879.0
2021-04-21 08:00:00	QQQ	ETF	336.0	336.0	334.54	335.19	346160.0
2021-04-21 09:00:00	QQQ	ETF	335.18	336.51	333.97	336.45	4848616.0
2021-04-21 10:00:00	QQQ	ETF	336.45	336.9	335.4099	335.98	5255540.0
2021-04-21 11:00:00	QQQ	ETF	336.0	338.23	335.83	338.155	4228311.0
2021-04-21 12:00:00	QQQ	ETF	338.17	338.1984	337.19	337.295	1987990.0
2021-04-21 13:00:00	QQQ	ETF	337.31	338.04	337.26	337.82	1726725.0
2021-04-21 14:00:00	QQQ	ETF	337.8382	338.17	337.5498	337.74	1738024.0
2021-04-21 15:00:00	QQQ	ETF	337.73	339.48	337.54	339.3	5372490.0
2021-04-21 16:00:00	QQQ	ETF	339.3	339.3972	338.56	338.62	913964.0
2021-04-21 17:00:00	QQQ	ETF	338.59	339.29	338.48	338.64	86021.0
2021-04-21 18:00:00	QQQ	ETF	338.67	338.84	338.4	338.58	139929.0
2021-04-21 19:00:00	QQQ	ETF	338.54	338.69	338.3	338.43	138834.0
2021-04-21 04:00:00	IWM	ETF	218.57	218.67	218.36	218.48	9107.0
2021-04-21 05:00:00	IWM	ETF	218.48	218.58	218.01	218.22	6800.0
2021-04-21 06:00:00	IWM	ETF	218.11	218.63	217.84	218.62	16850.0
2021-04-21 07:00:00	IWM	ETF	218.6	218.6	217.76	218.02	220093.0
2021-04-21 08:00:00	IWM	ETF	218.1301	218.56	216.58	216.75	187989.0
2021-04-21 09:00:00	IWM	ETF	216.74	219.11	215.5	218.98	4471428.0
2021-04-21 10:00:00	IWM	ETF	218.97	221.26	218.96	220.53	6140864.0
2021-04-21 11:00:00	IWM	ETF	220.52	220.98	219.4	220.67	3213957.0
2021-04-21 12:00:00	IWM	ETF	220.67	221.22	220.51	220.79	1549611.0
2021-04-21 13:00:00	IWM	ETF	220.8	221.72	220.72	221.63	1511385.0
2021-04-21 14:00:00	IWM	ETF	221.64	221.8	221.27	221.76	1721106.0
2021-04-21 15:00:00	IWM	ETF	221.765	222.62	221.73	222.54	4739664.0
2021-04-21 16:00:00	IWM	ETF	222.5	222.53	217.276	221.92	1139581.0
2021-04-21 17:00:00	IWM	ETF	221.99	222.5	221.84	222.02	78189.0
2021-04-21 18:00:00	IWM	ETF	222.0	222.03	221.46	221.67	49354.0
2021-04-21 19:00:00	IWM	ETF	221.64	221.75	221.34	221.45	41545.0
2021-04-21 04:00:00	DIA	ETF	338.24	338.3	338.1	338.1	600.0
2021-04-21 05:00:00	DIA	ETF	338.16	338.16	337.8	337.96	3400.0

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

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