PREVIEW / etf_1hour / 2021-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-23.parquet
  size:    413 KB
  rows:    14,043

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-23 04:00:00	SPY	ETF	412.68	413.57	412.68	413.45	17279.0
2021-04-23 05:00:00	SPY	ETF	413.34	413.38	413.08	413.22	21364.0
2021-04-23 06:00:00	SPY	ETF	413.23	413.51	413.2	413.3	25622.0
2021-04-23 07:00:00	SPY	ETF	413.39	413.5	413.0	413.08	89712.0
2021-04-23 08:00:00	SPY	ETF	413.38	413.5	412.53	412.72	247994.0
2021-04-23 09:00:00	SPY	ETF	412.72	414.2	412.68	414.18	5328141.0
2021-04-23 10:00:00	SPY	ETF	414.19	416.02	414.11	415.9601	7869216.0
2021-04-23 11:00:00	SPY	ETF	415.97	416.475	415.6119	416.2505	6180090.0
2021-04-23 12:00:00	SPY	ETF	416.25	417.28	416.25	417.102	4434686.0
2021-04-23 13:00:00	SPY	ETF	417.1	417.38	416.9	417.02	3547822.0
2021-04-23 14:00:00	SPY	ETF	417.015	417.58	416.75	417.375	4841028.0
2021-04-23 15:00:00	SPY	ETF	417.371	418.25	416.64	416.72	15773559.0
2021-04-23 16:00:00	SPY	ETF	416.71	416.84	416.17	416.25	4937446.0
2021-04-23 17:00:00	SPY	ETF	416.27	416.74	416.14	416.36	85508.0
2021-04-23 18:00:00	SPY	ETF	416.35	416.44	416.15	416.33	30271.0
2021-04-23 19:00:00	SPY	ETF	416.3	416.3	416.14	416.25	45652.0
2021-04-23 04:00:00	QQQ	ETF	336.01	336.03	335.74	335.82	45955.0
2021-04-23 05:00:00	QQQ	ETF	335.77	335.88	335.64	335.7	13993.0
2021-04-23 06:00:00	QQQ	ETF	335.72	336.05	335.69	335.88	58092.0
2021-04-23 07:00:00	QQQ	ETF	335.86	335.98	335.55	335.82	159501.0
2021-04-23 08:00:00	QQQ	ETF	335.86	336.01	335.03	335.71	228648.0
2021-04-23 09:00:00	QQQ	ETF	335.79	337.25	335.58	337.1	3270588.0
2021-04-23 10:00:00	QQQ	ETF	337.13	338.195	336.91	338.1312	4326630.0
2021-04-23 11:00:00	QQQ	ETF	338.1396	339.7	337.91	339.39	4194001.0
2021-04-23 12:00:00	QQQ	ETF	339.4	340.18	339.3001	340.04	2951441.0
2021-04-23 13:00:00	QQQ	ETF	340.04	340.35	339.82	340.05	1863954.0
2021-04-23 14:00:00	QQQ	ETF	340.04	340.49	339.745	340.29	2312803.0
2021-04-23 15:00:00	QQQ	ETF	340.29	340.767	339.34	339.43	5661969.0
2021-04-23 16:00:00	QQQ	ETF	339.43	339.561	338.93	338.96	1540878.0
2021-04-23 17:00:00	QQQ	ETF	338.98	339.42	338.96	339.13	66552.0
2021-04-23 18:00:00	QQQ	ETF	339.1	339.28	339.1	339.28	9860.0
2021-04-23 19:00:00	QQQ	ETF	339.2	339.34	339.06	339.3	20874.0
2021-04-23 04:00:00	IWM	ETF	223.31	223.52	223.14	223.23	43907.0
2021-04-23 05:00:00	IWM	ETF	223.22	223.22	222.78	222.85	6404.0
2021-04-23 06:00:00	IWM	ETF	223.01	223.35	223.01	223.18	14716.0
2021-04-23 07:00:00	IWM	ETF	223.18	223.52	223.0	223.3	115454.0
2021-04-23 08:00:00	IWM	ETF	223.25	223.5	222.44	222.53	167040.0
2021-04-23 09:00:00	IWM	ETF	222.56	224.57	222.02	224.5151	2251451.0
2021-04-23 10:00:00	IWM	ETF	224.52	225.54	224.34	224.86	3588979.0
2021-04-23 11:00:00	IWM	ETF	224.8699	225.5189	224.51	225.33	2310490.0
2021-04-23 12:00:00	IWM	ETF	225.34	225.64	224.79	224.959	1694963.0
2021-04-23 13:00:00	IWM	ETF	224.97	225.89	224.94	225.87	1227680.0
2021-04-23 14:00:00	IWM	ETF	225.88	226.38	225.77	226.34	1438010.0
2021-04-23 15:00:00	IWM	ETF	226.34	226.65	225.53	225.6298	5171129.0
2021-04-23 16:00:00	IWM	ETF	225.64	226.45	225.22	225.5299	1925085.0
2021-04-23 17:00:00	IWM	ETF	225.36	225.76	225.12	225.39	110194.0
2021-04-23 18:00:00	IWM	ETF	225.4	225.69	225.34	225.35	402918.0
2021-04-23 19:00:00	IWM	ETF	225.49	225.49	225.45	225.45	797.0
2021-04-23 04:00:00	DIA	ETF	338.79	338.92	338.74	338.92	800.0
2021-04-23 05:00:00	DIA	ETF	338.64	338.64	338.64	338.64	400.0

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

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