PREVIEW / etf_1hour / 2021-04-15

all etf 1-hour files

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

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-15 04:00:00	SPY	ETF	413.19	413.34	413.11	413.31	18254.0
2021-04-15 05:00:00	SPY	ETF	413.31	413.4	413.13	413.14	18680.0
2021-04-15 06:00:00	SPY	ETF	413.09	413.5	413.05	413.5	12149.0
2021-04-15 07:00:00	SPY	ETF	413.44	413.67	413.08	413.67	215109.0
2021-04-15 08:00:00	SPY	ETF	413.4001	414.12	412.24	413.79	409687.0
2021-04-15 09:00:00	SPY	ETF	413.8	414.37	413.47	413.95	5855736.0
2021-04-15 10:00:00	SPY	ETF	413.97	415.16	413.75	414.91	7495697.0
2021-04-15 11:00:00	SPY	ETF	414.92	415.46	414.52	414.82	5820475.0
2021-04-15 12:00:00	SPY	ETF	414.8159	415.68	414.7	415.6299	3826315.0
2021-04-15 13:00:00	SPY	ETF	415.63	415.7	415.09	415.4091	4503090.0
2021-04-15 14:00:00	SPY	ETF	415.405	415.79	415.18	415.36	4906065.0
2021-04-15 15:00:00	SPY	ETF	415.35	416.16	414.89	415.83	13760369.0
2021-04-15 16:00:00	SPY	ETF	415.83	415.93	415.62	415.79	2043274.0
2021-04-15 17:00:00	SPY	ETF	415.83	415.95	415.77	415.87	72529.0
2021-04-15 18:00:00	SPY	ETF	415.83	415.88	415.62	415.83	111325.0
2021-04-15 19:00:00	SPY	ETF	415.8	415.93	415.79	415.82	42167.0
2021-04-15 04:00:00	QQQ	ETF	338.22	338.37	337.52	338.36	38568.0
2021-04-15 05:00:00	QQQ	ETF	338.41	338.51	338.15	338.23	29142.0
2021-04-15 06:00:00	QQQ	ETF	338.06	338.76	337.95	338.7	72001.0
2021-04-15 07:00:00	QQQ	ETF	338.71	339.12	338.28	339.12	175991.0
2021-04-15 08:00:00	QQQ	ETF	338.79	339.85	336.51	339.63	320323.0
2021-04-15 09:00:00	QQQ	ETF	339.65	340.66	339.29	340.11	4106669.0
2021-04-15 10:00:00	QQQ	ETF	340.13	341.25	339.55	340.7599	4880638.0
2021-04-15 11:00:00	QQQ	ETF	340.82	341.4999	340.02	340.24	3565271.0
2021-04-15 12:00:00	QQQ	ETF	340.25	341.435	339.811	341.39	2207921.0
2021-04-15 13:00:00	QQQ	ETF	341.42	341.72	340.71	341.51	2420696.0
2021-04-15 14:00:00	QQQ	ETF	341.525	341.77	340.97	341.209	2175873.0
2021-04-15 15:00:00	QQQ	ETF	341.2	342.005	340.67	341.59	6190890.0
2021-04-15 16:00:00	QQQ	ETF	341.63	341.72	341.01	341.15	1092823.0
2021-04-15 17:00:00	QQQ	ETF	341.21	341.61	341.15	341.39	269420.0
2021-04-15 18:00:00	QQQ	ETF	341.28	341.41	341.0	341.36	45812.0
2021-04-15 19:00:00	QQQ	ETF	341.32	341.62	341.3	341.43	54273.0
2021-04-15 04:00:00	IWM	ETF	224.99	225.52	224.97	225.45	9080.0
2021-04-15 05:00:00	IWM	ETF	225.38	225.38	225.21	225.23	1100.0
2021-04-15 06:00:00	IWM	ETF	225.26	225.59	225.18	225.58	26200.0
2021-04-15 07:00:00	IWM	ETF	225.54	225.7	225.28	225.61	40533.0
2021-04-15 08:00:00	IWM	ETF	225.63	225.79	223.77	225.03	148131.0
2021-04-15 09:00:00	IWM	ETF	225.0	225.19	222.81	223.73	3373821.0
2021-04-15 10:00:00	IWM	ETF	223.73	223.74	222.26	223.36	2938552.0
2021-04-15 11:00:00	IWM	ETF	223.32	223.91	222.7	223.75	1496917.0
2021-04-15 12:00:00	IWM	ETF	223.75	223.78	222.905	222.99	1447865.0
2021-04-15 13:00:00	IWM	ETF	222.99	223.64	222.47	223.63	1833999.0
2021-04-15 14:00:00	IWM	ETF	223.66	224.2292	223.52	223.92	1264048.0
2021-04-15 15:00:00	IWM	ETF	223.92	224.43	223.37	224.25	3534636.0
2021-04-15 16:00:00	IWM	ETF	224.29	224.4	223.86	224.28	706981.0
2021-04-15 17:00:00	IWM	ETF	224.25	224.29	223.93	224.15	13957.0
2021-04-15 18:00:00	IWM	ETF	224.19	224.29	224.08	224.29	38402.0
2021-04-15 19:00:00	IWM	ETF	224.29	224.42	224.21	224.21	10257.0
2021-04-15 04:00:00	DIA	ETF	338.67	338.67	338.65	338.65	410.0
2021-04-15 05:00:00	DIA	ETF	338.8	338.8	338.8	338.8	2500.0

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

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