PREVIEW / etf_1hour / 2009-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-14.parquet
  size:    126 KB
  rows:    3,887

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-01-14 04:00:00	SPY	ETF	87.1	87.15	86.64	86.64	2913.0
2009-01-14 05:00:00	SPY	ETF	86.61	86.85	86.49	86.84	11580.0
2009-01-14 06:00:00	SPY	ETF	86.87	86.93	86.26	86.48	46566.0
2009-01-14 07:00:00	SPY	ETF	86.49	86.64	86.34	86.38	1070159.0
2009-01-14 08:00:00	SPY	ETF	86.38	86.575	85.46	85.64	5766036.0
2009-01-14 09:00:00	SPY	ETF	85.63	85.75	83.16	84.97	41974203.0
2009-01-14 10:00:00	SPY	ETF	84.98	85.2	83.8	84.11	78083996.0
2009-01-14 11:00:00	SPY	ETF	84.11	84.51	83.69	84.4	49555692.0
2009-01-14 12:00:00	SPY	ETF	84.4	84.62	83.98	84.56	34905178.0
2009-01-14 13:00:00	SPY	ETF	84.56	84.65	84.04	84.24	31910306.0
2009-01-14 14:00:00	SPY	ETF	84.25	85.04	84.04	84.585	59977336.0
2009-01-14 15:00:00	SPY	ETF	84.58	84.6	83.71	84.35	91229481.0
2009-01-14 16:00:00	SPY	ETF	84.33	87.2194	83.69	84.07	32102657.0
2009-01-14 17:00:00	SPY	ETF	84.06	84.28	83.6	83.72	3161457.0
2009-01-14 18:00:00	SPY	ETF	83.72	83.98	83.52	83.89	321383.0
2009-01-14 19:00:00	SPY	ETF	83.92	83.98	83.76	83.88	114763.0
2009-01-14 04:00:00	QQQ	ETF	29.51	29.51	29.49	29.49	322.0
2009-01-14 05:00:00	QQQ	ETF	29.45	29.46	29.41	29.46	433.0
2009-01-14 06:00:00	QQQ	ETF	29.49	29.49	29.31	29.36	3385.0
2009-01-14 07:00:00	QQQ	ETF	29.38	29.47	29.34	29.39	400705.0
2009-01-14 08:00:00	QQQ	ETF	29.54	29.54	29.11	29.17	1952609.0
2009-01-14 09:00:00	QQQ	ETF	29.17	29.28	28.87	29.0	18860546.0
2009-01-14 10:00:00	QQQ	ETF	29.0	29.08	28.619	28.71	22779951.0
2009-01-14 11:00:00	QQQ	ETF	28.72	28.89	28.55	28.84	15158249.0
2009-01-14 12:00:00	QQQ	ETF	28.832	28.87	28.63	28.82	10866724.0
2009-01-14 13:00:00	QQQ	ETF	28.82	28.84	28.65	28.73	7201418.0
2009-01-14 14:00:00	QQQ	ETF	28.72	28.93	28.65	28.79	13286199.0
2009-01-14 15:00:00	QQQ	ETF	28.78	28.8	28.47	28.66	31104031.0
2009-01-14 16:00:00	QQQ	ETF	28.66	28.7441	28.16	28.2	9097490.0
2009-01-14 17:00:00	QQQ	ETF	28.2	28.36	28.15	28.26	2189424.0
2009-01-14 18:00:00	QQQ	ETF	28.26	28.4	28.22	28.33	730181.0
2009-01-14 19:00:00	QQQ	ETF	28.33	28.33	28.25	28.27	59259.0
2009-01-14 07:00:00	IWM	ETF	46.9	46.99	46.77	46.77	34810.0
2009-01-14 08:00:00	IWM	ETF	46.78	46.84	46.26	46.28	338678.0
2009-01-14 09:00:00	IWM	ETF	46.35	46.67	46.0	46.18	5679145.0
2009-01-14 10:00:00	IWM	ETF	46.18	46.3225	45.23	45.41	15615272.0
2009-01-14 11:00:00	IWM	ETF	45.4	45.93	45.22	45.8	6619755.0
2009-01-14 12:00:00	IWM	ETF	45.81	45.83	45.43	45.73	4661516.0
2009-01-14 13:00:00	IWM	ETF	45.7299	45.79	45.36	45.47	3048698.0
2009-01-14 14:00:00	IWM	ETF	45.46	45.85	45.33	45.63	7878450.0
2009-01-14 15:00:00	IWM	ETF	45.62	45.6325	45.12	45.27	17572581.0
2009-01-14 16:00:00	IWM	ETF	45.26	47.2847	45.05	45.11	9001174.0
2009-01-14 17:00:00	IWM	ETF	45.09	45.25	44.85	44.85	18257.0
2009-01-14 18:00:00	IWM	ETF	44.7	46.1883	44.7	44.81	127400.0
2009-01-14 19:00:00	IWM	ETF	45.08	45.08	44.83	44.83	1120.0
2009-01-14 06:00:00	DIA	ETF	84.1	84.1	83.93	83.93	1350.0
2009-01-14 07:00:00	DIA	ETF	84.0	84.05	83.9	83.9	6129.0
2009-01-14 08:00:00	DIA	ETF	83.89	83.92	83.1	83.2	132779.0
2009-01-14 09:00:00	DIA	ETF	83.17	83.36	82.57	82.74	3930853.0
2009-01-14 10:00:00	DIA	ETF	82.74	82.85	81.51	81.78	8484089.0

> showing 50 of 3,887 rows — these rows as CSV

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