PREVIEW / etf_1hour / 2021-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-07.parquet
  size:    418 KB
  rows:    14,467

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-05-07 04:00:00	SPY	ETF	419.13	419.59	419.1	419.5	17262.0
2021-05-07 05:00:00	SPY	ETF	419.59	419.71	419.49	419.64	4663.0
2021-05-07 06:00:00	SPY	ETF	419.97	420.25	419.89	420.05	17583.0
2021-05-07 07:00:00	SPY	ETF	420.09	420.13	419.81	420.13	136191.0
2021-05-07 08:00:00	SPY	ETF	420.1	421.5	419.0	420.38	1666991.0
2021-05-07 09:00:00	SPY	ETF	420.4	421.48	419.16	420.95	8380871.0
2021-05-07 10:00:00	SPY	ETF	420.96	422.67	420.88	422.1719	8789860.0
2021-05-07 11:00:00	SPY	ETF	422.17	422.815	422.05	422.535	4904931.0
2021-05-07 12:00:00	SPY	ETF	422.54	422.57	421.64	422.105	4510137.0
2021-05-07 13:00:00	SPY	ETF	422.11	422.15	421.45	421.695	3944088.0
2021-05-07 14:00:00	SPY	ETF	421.6919	422.29	421.21	422.1481	4998177.0
2021-05-07 15:00:00	SPY	ETF	422.145	422.79	421.97	422.09	12806652.0
2021-05-07 16:00:00	SPY	ETF	422.08	422.54	422.04	422.3	2935688.0
2021-05-07 17:00:00	SPY	ETF	422.3	422.6	422.25	422.52	52309.0
2021-05-07 18:00:00	SPY	ETF	422.52	422.62	422.12	422.4	33430.0
2021-05-07 19:00:00	SPY	ETF	422.4	422.6	422.32	422.42	25639.0
2021-05-07 04:00:00	QQQ	ETF	331.73	332.14	331.58	332.14	20467.0
2021-05-07 05:00:00	QQQ	ETF	332.18	332.36	331.9	332.36	32341.0
2021-05-07 06:00:00	QQQ	ETF	332.52	332.8	332.3	332.57	47306.0
2021-05-07 07:00:00	QQQ	ETF	332.56	332.65	332.26	332.36	113636.0
2021-05-07 08:00:00	QQQ	ETF	332.37	336.86	331.54	335.67	3624603.0
2021-05-07 09:00:00	QQQ	ETF	335.7	336.06	333.1	334.55	9065364.0
2021-05-07 10:00:00	QQQ	ETF	334.57	336.65	333.97	335.72	8339131.0
2021-05-07 11:00:00	QQQ	ETF	335.71	336.43	335.57	336.16	3921772.0
2021-05-07 12:00:00	QQQ	ETF	336.16	336.19	334.44	334.94	3304669.0
2021-05-07 13:00:00	QQQ	ETF	334.95	334.97	333.53	333.53	3175747.0
2021-05-07 14:00:00	QQQ	ETF	333.53	334.57	333.06	334.46	3440828.0
2021-05-07 15:00:00	QQQ	ETF	334.4505	335.13	334.08	334.16	6064929.0
2021-05-07 16:00:00	QQQ	ETF	334.16	334.9351	334.12	334.39	1670748.0
2021-05-07 17:00:00	QQQ	ETF	334.43	334.55	334.41	334.44	22083.0
2021-05-07 18:00:00	QQQ	ETF	334.44	334.5	334.29	334.41	17512.0
2021-05-07 19:00:00	QQQ	ETF	334.46	334.52	334.33	334.5	6176.0
2021-05-07 04:00:00	IWM	ETF	222.94	223.3	222.94	223.28	2960.0
2021-05-07 05:00:00	IWM	ETF	223.35	223.56	223.28	223.44	22395.0
2021-05-07 06:00:00	IWM	ETF	223.68	224.3	223.61	223.74	22736.0
2021-05-07 07:00:00	IWM	ETF	223.7	223.95	223.54	223.63	28734.0
2021-05-07 08:00:00	IWM	ETF	223.74	224.1596	221.66	222.53	612324.0
2021-05-07 09:00:00	IWM	ETF	222.63	224.68	222.16	223.74	2898286.0
2021-05-07 10:00:00	IWM	ETF	223.74	225.93	223.74	225.68	4324647.0
2021-05-07 11:00:00	IWM	ETF	225.68	225.72	224.62	224.644	2228371.0
2021-05-07 12:00:00	IWM	ETF	224.645	225.44	224.491	225.44	1431319.0
2021-05-07 13:00:00	IWM	ETF	225.44	225.65	224.92	225.115	1506630.0
2021-05-07 14:00:00	IWM	ETF	225.11	225.415	224.5	225.39	2018000.0
2021-05-07 15:00:00	IWM	ETF	225.39	225.63	224.9	225.41	5305442.0
2021-05-07 16:00:00	IWM	ETF	225.39	225.72	225.35	225.46	817948.0
2021-05-07 17:00:00	IWM	ETF	225.52	225.52	225.41	225.45	561.0
2021-05-07 18:00:00	IWM	ETF	225.59	225.66	225.45	225.47	8478.0
2021-05-07 19:00:00	IWM	ETF	225.47	225.5	225.39	225.44	13453.0
2021-05-07 04:00:00	DIA	ETF	345.65	345.84	345.65	345.84	390.0
2021-05-07 06:00:00	DIA	ETF	346.49	346.58	346.41	346.41	3296.0

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

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