PREVIEW / etf_1hour / 2021-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-28.parquet
  size:    413 KB
  rows:    14,524

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-06-28 04:00:00	SPY	ETF	426.8	426.85	426.42	426.71	10296.0
2021-06-28 05:00:00	SPY	ETF	426.75	426.83	426.63	426.7	7306.0
2021-06-28 06:00:00	SPY	ETF	426.7	426.75	426.3	426.68	34207.0
2021-06-28 07:00:00	SPY	ETF	426.66	427.08	426.58	426.79	98469.0
2021-06-28 08:00:00	SPY	ETF	426.8899	427.31	426.32	427.23	293568.0
2021-06-28 09:00:00	SPY	ETF	427.24	427.39	426.02	426.69	4177387.0
2021-06-28 10:00:00	SPY	ETF	426.69	426.87	426.34	426.5	3672467.0
2021-06-28 11:00:00	SPY	ETF	426.51	426.79	426.15	426.5325	3027421.0
2021-06-28 12:00:00	SPY	ETF	426.54	426.65	426.17	426.18	2272138.0
2021-06-28 13:00:00	SPY	ETF	426.18	426.52	425.89	426.5	3806073.0
2021-06-28 14:00:00	SPY	ETF	426.49	427.0	426.47	426.92	3438110.0
2021-06-28 15:00:00	SPY	ETF	426.93	427.65	426.755	427.48	10722037.0
2021-06-28 16:00:00	SPY	ETF	427.49	427.65	427.33	427.59	3913420.0
2021-06-28 17:00:00	SPY	ETF	427.6	427.65	427.47	427.6	622463.0
2021-06-28 18:00:00	SPY	ETF	427.58	427.58	427.21	427.22	113908.0
2021-06-28 19:00:00	SPY	ETF	427.23	427.32	427.13	427.2	38481.0
2021-06-28 04:00:00	QQQ	ETF	349.71	350.38	349.71	350.3	19815.0
2021-06-28 05:00:00	QQQ	ETF	350.31	350.4	350.16	350.25	14141.0
2021-06-28 06:00:00	QQQ	ETF	350.3	350.3	349.98	350.28	21119.0
2021-06-28 07:00:00	QQQ	ETF	350.24	350.6	350.16	350.5	110710.0
2021-06-28 08:00:00	QQQ	ETF	350.55	350.74	349.96	350.72	146344.0
2021-06-28 09:00:00	QQQ	ETF	350.7201	352.37	350.65	352.17	4358794.0
2021-06-28 10:00:00	QQQ	ETF	352.18	353.06	352.1713	352.375	5324451.0
2021-06-28 11:00:00	QQQ	ETF	352.39	352.91	352.26	352.695	3173387.0
2021-06-28 12:00:00	QQQ	ETF	352.695	353.23	352.6	352.71	2789092.0
2021-06-28 13:00:00	QQQ	ETF	352.71	352.775	352.33	352.48	2013120.0
2021-06-28 14:00:00	QQQ	ETF	352.47	353.5	352.385	353.46	2455732.0
2021-06-28 15:00:00	QQQ	ETF	353.47	353.85	353.1	353.68	6583815.0
2021-06-28 16:00:00	QQQ	ETF	353.68	353.71	353.33	353.44	2318952.0
2021-06-28 17:00:00	QQQ	ETF	353.48	353.71	353.41	353.46	55275.0
2021-06-28 18:00:00	QQQ	ETF	353.41	353.46	353.17	353.2	85350.0
2021-06-28 19:00:00	QQQ	ETF	353.2	353.27	353.08	353.15	34345.0
2021-06-28 04:00:00	IWM	ETF	231.91	231.91	231.22	231.27	8983.0
2021-06-28 05:00:00	IWM	ETF	231.39	231.42	231.26	231.35	8739.0
2021-06-28 06:00:00	IWM	ETF	231.36	231.36	230.85	231.15	90230.0
2021-06-28 07:00:00	IWM	ETF	231.26	231.82	231.26	231.55	72641.0
2021-06-28 08:00:00	IWM	ETF	231.4	232.2	231.35	232.1	138727.0
2021-06-28 09:00:00	IWM	ETF	232.13	232.59	230.44	231.26	4220685.0
2021-06-28 10:00:00	IWM	ETF	231.25	231.25	229.8816	230.63	3394597.0
2021-06-28 11:00:00	IWM	ETF	230.62	230.805	230.04	230.53	1614983.0
2021-06-28 12:00:00	IWM	ETF	230.52	230.605	229.68	230.06	1963334.0
2021-06-28 13:00:00	IWM	ETF	230.06	230.1	228.77	229.92	2377935.0
2021-06-28 14:00:00	IWM	ETF	229.91	230.46	229.82	230.06	1772977.0
2021-06-28 15:00:00	IWM	ETF	230.07	230.755	229.75	230.41	3705234.0
2021-06-28 16:00:00	IWM	ETF	230.44	230.62	230.31	230.61	540594.0
2021-06-28 17:00:00	IWM	ETF	230.42	230.68	230.42	230.68	5335.0
2021-06-28 18:00:00	IWM	ETF	230.58	230.58	230.28	230.32	40000.0
2021-06-28 19:00:00	IWM	ETF	230.37	230.48	230.3	230.36	40458.0
2021-06-28 04:00:00	DIA	ETF	344.1	344.1	344.0	344.0	350.0
2021-06-28 05:00:00	DIA	ETF	344.25	344.31	344.2	344.26	1286.0

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

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