PREVIEW / etf_1hour / 2009-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-23.parquet
  size:    133 KB
  rows:    4,106

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
2009-04-23 04:00:00	SPY	ETF	84.94	85.02	84.87	84.89	8057.0
2009-04-23 05:00:00	SPY	ETF	84.87	85.2	84.85	85.02	18800.0
2009-04-23 06:00:00	SPY	ETF	85.09	85.09	84.77	84.85	49900.0
2009-04-23 07:00:00	SPY	ETF	84.85	85.26	84.74	84.95	1638762.0
2009-04-23 08:00:00	SPY	ETF	85.04	85.18	84.71	84.94	4465877.0
2009-04-23 09:00:00	SPY	ETF	84.95	85.0	84.3	84.34	28776235.0
2009-04-23 10:00:00	SPY	ETF	84.34	84.73	83.83	84.02	46849850.0
2009-04-23 11:00:00	SPY	ETF	84.02	84.2	83.63	83.7701	35983663.0
2009-04-23 12:00:00	SPY	ETF	83.77	84.34	83.71	84.28	21606556.0
2009-04-23 13:00:00	SPY	ETF	84.29	84.85	84.28	84.69	32019369.0
2009-04-23 14:00:00	SPY	ETF	84.7	85.14	84.34	84.73	41907747.0
2009-04-23 15:00:00	SPY	ETF	84.74	85.42	84.15	85.36	79758409.0
2009-04-23 16:00:00	SPY	ETF	85.33	85.8	83.9127	85.48	18765522.0
2009-04-23 17:00:00	SPY	ETF	85.46	85.65	85.46	85.59	4437515.0
2009-04-23 18:00:00	SPY	ETF	85.52	85.63	85.46	85.5	245065.0
2009-04-23 19:00:00	SPY	ETF	85.47	85.5	85.36	85.38	70890.0
2009-04-23 04:00:00	QQQ	ETF	32.92	33.0	32.92	33.0	400.0
2009-04-23 05:00:00	QQQ	ETF	33.0	33.11	33.0	33.11	10500.0
2009-04-23 06:00:00	QQQ	ETF	33.07	33.07	33.01	33.03	1900.0
2009-04-23 07:00:00	QQQ	ETF	33.0	33.15	33.0	33.1	792830.0
2009-04-23 08:00:00	QQQ	ETF	33.1	33.19	33.02	33.15	2074040.0
2009-04-23 09:00:00	QQQ	ETF	33.15	33.16	32.76	32.8001	21903120.0
2009-04-23 10:00:00	QQQ	ETF	32.8	33.05	32.65	32.69	28474390.0
2009-04-23 11:00:00	QQQ	ETF	32.68	32.74	32.49	32.57	16458447.0
2009-04-23 12:00:00	QQQ	ETF	32.56	32.88	32.56	32.83	15749207.0
2009-04-23 13:00:00	QQQ	ETF	32.83	33.0	32.81	32.94	17285075.0
2009-04-23 14:00:00	QQQ	ETF	32.95	33.04	32.78	32.87	19162738.0
2009-04-23 15:00:00	QQQ	ETF	32.87	33.13	32.68	33.13	32866740.0
2009-04-23 16:00:00	QQQ	ETF	33.13	33.36	32.72	33.15	10757887.0
2009-04-23 17:00:00	QQQ	ETF	33.15	33.28	32.8546	33.21	2379422.0
2009-04-23 18:00:00	QQQ	ETF	33.21	33.21	33.14	33.14	90478.0
2009-04-23 19:00:00	QQQ	ETF	33.15	33.16	33.13	33.14	133946.0
2009-04-23 06:00:00	IWM	ETF	47.2	47.2	47.17	47.17	2200.0
2009-04-23 07:00:00	IWM	ETF	47.27	47.5	47.18	47.27	15900.0
2009-04-23 08:00:00	IWM	ETF	47.28	47.44	47.21	47.29	255168.0
2009-04-23 09:00:00	IWM	ETF	47.27	47.28	46.542	46.579	6012813.0
2009-04-23 10:00:00	IWM	ETF	46.58	46.92	46.1	46.24	9401312.0
2009-04-23 11:00:00	IWM	ETF	46.24	46.7246	45.97	46.15	6476140.0
2009-04-23 12:00:00	IWM	ETF	46.15	46.57	46.13	46.5	5616862.0
2009-04-23 13:00:00	IWM	ETF	46.51	46.8	46.2	46.46	8444201.0
2009-04-23 14:00:00	IWM	ETF	46.45	46.71	46.12	46.3	7724375.0
2009-04-23 15:00:00	IWM	ETF	46.3	46.82	45.93	46.7	17411759.0
2009-04-23 16:00:00	IWM	ETF	46.69	47.0638	46.56	46.77	1511941.0
2009-04-23 17:00:00	IWM	ETF	46.82	47.0641	46.74	46.77	1540717.0
2009-04-23 18:00:00	IWM	ETF	46.7	46.7	46.64	46.64	900.0
2009-04-23 19:00:00	IWM	ETF	46.62	46.62	46.55	46.59	700.0
2009-04-23 06:00:00	DIA	ETF	79.28	79.43	79.13	79.13	5300.0
2009-04-23 07:00:00	DIA	ETF	79.21	79.47	79.13	79.21	19264.0
2009-04-23 08:00:00	DIA	ETF	79.26	79.48	79.0	79.22	108271.0
2009-04-23 09:00:00	DIA	ETF	79.22	79.23	78.56	78.6	2098997.0

> showing 50 of 4,106 rows — these rows as CSV

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