PREVIEW / etf_1hour / 2021-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-13.parquet
  size:    416 KB
  rows:    14,411

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-13 04:00:00	SPY	ETF	411.76	411.8	411.64	411.64	5310.0
2021-04-13 05:00:00	SPY	ETF	411.67	412.16	411.61	412.16	10918.0
2021-04-13 06:00:00	SPY	ETF	412.18	412.23	411.09	411.22	112445.0
2021-04-13 07:00:00	SPY	ETF	411.25	411.3	409.68	410.41	792158.0
2021-04-13 08:00:00	SPY	ETF	410.41	411.8	409.96	411.8	632811.0
2021-04-13 09:00:00	SPY	ETF	411.77	411.91	411.12	411.8	4870878.0
2021-04-13 10:00:00	SPY	ETF	411.8	412.2	411.72	411.82	6252906.0
2021-04-13 11:00:00	SPY	ETF	411.827	412.21	411.74	412.077	3369845.0
2021-04-13 12:00:00	SPY	ETF	412.08	412.19	411.61	411.625	3284270.0
2021-04-13 13:00:00	SPY	ETF	411.6219	412.27	411.54	412.18	5911569.0
2021-04-13 14:00:00	SPY	ETF	412.185	413.12	412.15	413.045	6004881.0
2021-04-13 15:00:00	SPY	ETF	413.04	413.529	412.7	412.8299	13143280.0
2021-04-13 16:00:00	SPY	ETF	412.81	413.06	412.76	412.94	2291464.0
2021-04-13 17:00:00	SPY	ETF	412.97	412.98	412.84	412.95	101396.0
2021-04-13 18:00:00	SPY	ETF	412.95	412.95	412.65	412.75	83609.0
2021-04-13 19:00:00	SPY	ETF	412.72	412.78	412.58	412.64	49187.0
2021-04-13 04:00:00	QQQ	ETF	336.64	336.79	336.49	336.56	24547.0
2021-04-13 05:00:00	QQQ	ETF	336.51	336.77	336.37	336.76	37836.0
2021-04-13 06:00:00	QQQ	ETF	336.84	336.91	336.11	336.29	37925.0
2021-04-13 07:00:00	QQQ	ETF	336.31	336.58	335.81	336.44	191573.0
2021-04-13 08:00:00	QQQ	ETF	336.53	338.52	335.82	338.35	594179.0
2021-04-13 09:00:00	QQQ	ETF	338.39	339.95	338.02	339.8	4163497.0
2021-04-13 10:00:00	QQQ	ETF	339.82	339.985	338.8	339.27	3927240.0
2021-04-13 11:00:00	QQQ	ETF	339.26	339.6	338.41	338.922	2984393.0
2021-04-13 12:00:00	QQQ	ETF	338.93	339.36	338.745	338.9001	1942744.0
2021-04-13 13:00:00	QQQ	ETF	338.95	339.9897	338.94	339.6518	2052305.0
2021-04-13 14:00:00	QQQ	ETF	339.67	340.55	339.44	340.495	2498578.0
2021-04-13 15:00:00	QQQ	ETF	340.4882	341.08	340.365	340.61	5801167.0
2021-04-13 16:00:00	QQQ	ETF	340.6	340.79	340.48	340.58	931036.0
2021-04-13 17:00:00	QQQ	ETF	340.56	340.72	340.51	340.62	33315.0
2021-04-13 18:00:00	QQQ	ETF	340.64	340.75	340.49	340.56	62778.0
2021-04-13 19:00:00	QQQ	ETF	340.6	340.6	340.35	340.42	85665.0
2021-04-13 04:00:00	IWM	ETF	221.61	221.61	221.44	221.45	3800.0
2021-04-13 05:00:00	IWM	ETF	221.6	222.27	221.6	222.27	24813.0
2021-04-13 06:00:00	IWM	ETF	222.38	222.41	221.61	221.62	23288.0
2021-04-13 07:00:00	IWM	ETF	221.35	221.35	219.47	220.15	431547.0
2021-04-13 08:00:00	IWM	ETF	220.1301	221.47	219.79	221.47	228553.0
2021-04-13 09:00:00	IWM	ETF	221.44	222.57	220.03	220.24	2744498.0
2021-04-13 10:00:00	IWM	ETF	220.23	221.4597	219.23	221.12	4830078.0
2021-04-13 11:00:00	IWM	ETF	221.12	221.125	219.59	220.17	1538252.0
2021-04-13 12:00:00	IWM	ETF	220.1699	220.3951	218.83	219.15	2463540.0
2021-04-13 13:00:00	IWM	ETF	219.13	220.21	219.11	220.1832	1553565.0
2021-04-13 14:00:00	IWM	ETF	220.18	221.03	220.13	220.93	1295660.0
2021-04-13 15:00:00	IWM	ETF	220.92	221.87	220.88	221.15	3417408.0
2021-04-13 16:00:00	IWM	ETF	221.14	221.61	221.14	221.43	1583407.0
2021-04-13 17:00:00	IWM	ETF	221.74	221.74	221.35	221.49	41891.0
2021-04-13 18:00:00	IWM	ETF	221.51	221.51	220.89	221.05	262603.0
2021-04-13 19:00:00	IWM	ETF	221.05	221.08	220.84	220.9	57397.0
2021-04-13 04:00:00	DIA	ETF	337.76	337.76	337.71	337.71	400.0
2021-04-13 05:00:00	DIA	ETF	337.87	338.06	337.8	338.06	3805.0

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

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