PREVIEW / etf_1hour / 2021-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-19.parquet
  size:    439 KB
  rows:    15,471

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-11-19 04:00:00	SPY	ETF	470.53	472.0	469.67	469.67	36240.0
2021-11-19 05:00:00	SPY	ETF	469.57	469.57	468.0	469.55	80115.0
2021-11-19 06:00:00	SPY	ETF	469.55	469.57	468.2	468.44	72007.0
2021-11-19 07:00:00	SPY	ETF	468.46	468.95	468.01	468.31	189956.0
2021-11-19 08:00:00	SPY	ETF	468.31	471.52	468.03	468.92	388206.0
2021-11-19 09:00:00	SPY	ETF	468.89	470.21	468.54	470.18	5353004.0
2021-11-19 10:00:00	SPY	ETF	470.18	470.21	468.8	469.35	5433659.0
2021-11-19 11:00:00	SPY	ETF	469.35	470.2	469.32	469.97	2779658.0
2021-11-19 12:00:00	SPY	ETF	469.9713	470.94	469.97	470.31	3005591.0
2021-11-19 13:00:00	SPY	ETF	470.32	470.44	468.5	469.54	4888205.0
2021-11-19 14:00:00	SPY	ETF	469.53	469.85	469.1032	469.4	3425711.0
2021-11-19 15:00:00	SPY	ETF	469.395	469.54	468.66	468.92	7610540.0
2021-11-19 16:00:00	SPY	ETF	468.9	469.32	468.8	469.32	2424426.0
2021-11-19 17:00:00	SPY	ETF	469.13	469.45	469.1	469.24	89772.0
2021-11-19 18:00:00	SPY	ETF	469.24	469.25	469.05	469.2	8747.0
2021-11-19 19:00:00	SPY	ETF	469.24	469.24	469.01	469.17	12620.0
2021-11-19 04:00:00	QQQ	ETF	403.12	403.96	403.12	403.15	81450.0
2021-11-19 05:00:00	QQQ	ETF	403.21	403.44	402.43	403.3	83499.0
2021-11-19 06:00:00	QQQ	ETF	403.34	403.42	402.62	402.97	68797.0
2021-11-19 07:00:00	QQQ	ETF	402.98	403.58	402.92	403.36	162033.0
2021-11-19 08:00:00	QQQ	ETF	403.0	403.85	402.051	403.8	452217.0
2021-11-19 09:00:00	QQQ	ETF	403.79	405.02	402.58	404.92	4618784.0
2021-11-19 10:00:00	QQQ	ETF	404.94	405.04	403.34	403.78	4904401.0
2021-11-19 11:00:00	QQQ	ETF	403.78	405.25	403.71	404.71	2755674.0
2021-11-19 12:00:00	QQQ	ETF	404.72	405.3	404.3	404.4	1973838.0
2021-11-19 13:00:00	QQQ	ETF	404.41	404.86	403.02	404.17	3015594.0
2021-11-19 14:00:00	QQQ	ETF	404.17	404.4269	403.79	404.215	2070972.0
2021-11-19 15:00:00	QQQ	ETF	404.22	404.335	403.62	403.97	3875251.0
2021-11-19 16:00:00	QQQ	ETF	403.97	404.38	403.87	404.35	2219760.0
2021-11-19 17:00:00	QQQ	ETF	404.19	404.41	403.99	404.28	105731.0
2021-11-19 18:00:00	QQQ	ETF	404.24	404.3	403.99	404.25	40172.0
2021-11-19 19:00:00	QQQ	ETF	404.2	404.3	404.14	404.3	9967.0
2021-11-19 04:00:00	IWM	ETF	235.62	235.66	233.63	233.66	52251.0
2021-11-19 05:00:00	IWM	ETF	233.68	233.68	231.5	232.75	107181.0
2021-11-19 06:00:00	IWM	ETF	233.17	233.24	231.82	232.22	99926.0
2021-11-19 07:00:00	IWM	ETF	232.26	232.51	231.39	231.74	225109.0
2021-11-19 08:00:00	IWM	ETF	232.27	236.03	231.5	232.68	308456.0
2021-11-19 09:00:00	IWM	ETF	232.5899	234.29	232.2	233.69	4017480.0
2021-11-19 10:00:00	IWM	ETF	233.71	234.25	232.6035	233.795	3935662.0
2021-11-19 11:00:00	IWM	ETF	233.81	233.94	233.19	233.335	2755909.0
2021-11-19 12:00:00	IWM	ETF	233.335	234.42	233.33	233.975	1795502.0
2021-11-19 13:00:00	IWM	ETF	233.98	234.28	232.57	233.27	2016026.0
2021-11-19 14:00:00	IWM	ETF	233.24	233.66	233.02	233.26	2198720.0
2021-11-19 15:00:00	IWM	ETF	233.26	233.39	232.39	232.71	4054747.0
2021-11-19 16:00:00	IWM	ETF	232.72	234.1	232.5	232.87	1790219.0
2021-11-19 17:00:00	IWM	ETF	232.76	233.0	232.72	232.88	1977671.0
2021-11-19 18:00:00	IWM	ETF	232.77	232.93	232.72	232.72	325041.0
2021-11-19 19:00:00	IWM	ETF	232.85	232.92	232.74	232.92	2806.0
2021-11-19 04:00:00	DIA	ETF	359.47	359.53	358.0	358.0	2173.0
2021-11-19 05:00:00	DIA	ETF	357.8	357.82	356.16	357.6	12050.0

> showing 50 of 15,471 rows — these rows as CSV

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