PREVIEW / etf_1hour / 2022-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-20.parquet
  size:    477 KB
  rows:    17,379

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
2022-12-20 04:00:00	SPY	ETF	379.69	380.25	379.16	379.92	81762.0
2022-12-20 05:00:00	SPY	ETF	379.9	380.14	379.23	379.74	32106.0
2022-12-20 06:00:00	SPY	ETF	379.85	380.4	379.61	379.72	60250.0
2022-12-20 07:00:00	SPY	ETF	379.87	380.43	378.95	378.95	284847.0
2022-12-20 08:00:00	SPY	ETF	378.96	380.3996	376.2	379.23	476045.0
2022-12-20 09:00:00	SPY	ETF	379.27	380.27	377.85	380.04	5973992.0
2022-12-20 10:00:00	SPY	ETF	380.07	382.14	378.43	381.29	9462320.0
2022-12-20 11:00:00	SPY	ETF	381.29	381.54	378.85	380.627	6903325.0
2022-12-20 12:00:00	SPY	ETF	380.63	381.29	380.01	381.1417	5108828.0
2022-12-20 13:00:00	SPY	ETF	381.16	382.23	380.535	381.26	4657095.0
2022-12-20 14:00:00	SPY	ETF	381.27	382.02	380.47	380.7	5338288.0
2022-12-20 15:00:00	SPY	ETF	380.71	381.58	380.06	380.52	9878096.0
2022-12-20 16:00:00	SPY	ETF	380.51	380.99	380.28	380.99	4346749.0
2022-12-20 17:00:00	SPY	ETF	380.98	381.25	380.54	381.25	231518.0
2022-12-20 18:00:00	SPY	ETF	381.24	382.0	381.23	381.77	153819.0
2022-12-20 19:00:00	SPY	ETF	381.79	382.4	381.26	382.03	83303.0
2022-12-20 04:00:00	QQQ	ETF	269.24	269.64	268.0	269.1	58178.0
2022-12-20 05:00:00	QQQ	ETF	269.31	269.53	268.87	269.22	21881.0
2022-12-20 06:00:00	QQQ	ETF	269.26	269.83	269.16	269.36	39141.0
2022-12-20 07:00:00	QQQ	ETF	269.38	269.65	268.28	268.31	147856.0
2022-12-20 08:00:00	QQQ	ETF	268.39	269.952	266.75	268.66	464748.0
2022-12-20 09:00:00	QQQ	ETF	268.68	269.63	266.95	269.4	5046817.0
2022-12-20 10:00:00	QQQ	ETF	269.41	271.32	269.15	270.0	5449949.0
2022-12-20 11:00:00	QQQ	ETF	269.97	270.47	267.81	269.59	5233853.0
2022-12-20 12:00:00	QQQ	ETF	269.6	270.425	269.05	270.02	2881098.0
2022-12-20 13:00:00	QQQ	ETF	270.03	270.84	269.31	269.885	2629915.0
2022-12-20 14:00:00	QQQ	ETF	269.9	270.555	269.31	269.63	2171358.0
2022-12-20 15:00:00	QQQ	ETF	269.6	270.3	269.15	269.57	3662911.0
2022-12-20 16:00:00	QQQ	ETF	269.55	270.05	269.48	270.01	5012293.0
2022-12-20 17:00:00	QQQ	ETF	270.06	270.38	269.54	270.31	693919.0
2022-12-20 18:00:00	QQQ	ETF	270.4	270.97	270.3	270.72	191445.0
2022-12-20 19:00:00	QQQ	ETF	270.72	270.98	270.27	270.85	161345.0
2022-12-20 04:00:00	IWM	ETF	172.12	172.24	171.77	172.1	19212.0
2022-12-20 05:00:00	IWM	ETF	172.21	172.29	171.92	172.21	8627.0
2022-12-20 06:00:00	IWM	ETF	172.23	172.51	172.15	172.21	10624.0
2022-12-20 07:00:00	IWM	ETF	172.3	172.59	171.9	171.9	43579.0
2022-12-20 08:00:00	IWM	ETF	171.9	172.27	171.74	171.87	83378.0
2022-12-20 09:00:00	IWM	ETF	171.85	172.45	171.18	172.38	1962619.0
2022-12-20 10:00:00	IWM	ETF	172.38	174.02	172.32	173.36	2822457.0
2022-12-20 11:00:00	IWM	ETF	173.39	173.63	172.6	173.21	1845811.0
2022-12-20 12:00:00	IWM	ETF	173.24	173.64	172.9	173.34	1171717.0
2022-12-20 13:00:00	IWM	ETF	173.35	173.88	173.13	173.57	1125271.0
2022-12-20 14:00:00	IWM	ETF	173.58	173.82	173.05	173.19	1382319.0
2022-12-20 15:00:00	IWM	ETF	173.19	173.5	172.9	172.92	2693666.0
2022-12-20 16:00:00	IWM	ETF	172.92	173.27	172.78	173.27	1141041.0
2022-12-20 17:00:00	IWM	ETF	173.28	173.42	172.92	173.26	48421.0
2022-12-20 18:00:00	IWM	ETF	173.31	173.68	173.31	173.64	19413.0
2022-12-20 19:00:00	IWM	ETF	173.54	173.71	173.26	173.69	19224.0
2022-12-20 04:00:00	DIA	ETF	327.31	327.72	327.31	327.52	1093.0
2022-12-20 05:00:00	DIA	ETF	327.45	327.71	327.19	327.71	2300.0

> showing 50 of 17,379 rows — these rows as CSV

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