PREVIEW / etf_1hour / 2009-04-14

all etf 1-hour files

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

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-14 04:00:00	SPY	ETF	85.3	85.45	85.26	85.45	5250.0
2009-04-14 05:00:00	SPY	ETF	85.53	85.85	85.53	85.81	48315.0
2009-04-14 06:00:00	SPY	ETF	85.8	85.85	85.47	85.59	66464.0
2009-04-14 07:00:00	SPY	ETF	85.6	85.84	85.48	85.56	1389883.0
2009-04-14 08:00:00	SPY	ETF	85.56	86.2	84.97	85.08	11261521.0
2009-04-14 09:00:00	SPY	ETF	85.08	85.19	84.51	85.03	30412316.0
2009-04-14 10:00:00	SPY	ETF	85.03	85.76	84.55	85.51	39659332.0
2009-04-14 11:00:00	SPY	ETF	85.5	85.6	85.01	85.11	26458531.0
2009-04-14 12:00:00	SPY	ETF	85.11	85.1125	84.13	84.28	27375048.0
2009-04-14 13:00:00	SPY	ETF	84.2702	84.49	84.08	84.4075	28769250.0
2009-04-14 14:00:00	SPY	ETF	84.41	84.7	84.1	84.7	29629963.0
2009-04-14 15:00:00	SPY	ETF	84.695	84.94	84.15	84.31	54915320.0
2009-04-14 16:00:00	SPY	ETF	84.33	84.8	83.86	83.9	18673113.0
2009-04-14 17:00:00	SPY	ETF	83.91	84.1	83.91	83.95	940862.0
2009-04-14 18:00:00	SPY	ETF	83.96	83.97	83.76	83.91	408147.0
2009-04-14 19:00:00	SPY	ETF	83.92	83.95	83.86	83.88	118549.0
2009-04-14 04:00:00	QQQ	ETF	32.71	32.71	32.71	32.71	295.0
2009-04-14 06:00:00	QQQ	ETF	32.82	32.82	32.79	32.79	200.0
2009-04-14 07:00:00	QQQ	ETF	32.79	32.86	32.79	32.83	708987.0
2009-04-14 08:00:00	QQQ	ETF	32.84	33.02	32.63	32.65	3157604.0
2009-04-14 09:00:00	QQQ	ETF	32.65	32.77	32.54	32.76	14251319.0
2009-04-14 10:00:00	QQQ	ETF	32.75	32.88	32.57	32.78	17811155.0
2009-04-14 11:00:00	QQQ	ETF	32.78	32.83	32.57	32.63	14638639.0
2009-04-14 12:00:00	QQQ	ETF	32.63	32.64	32.33	32.369	11523934.0
2009-04-14 13:00:00	QQQ	ETF	32.37	32.47	32.27	32.43	14772369.0
2009-04-14 14:00:00	QQQ	ETF	32.43	32.61	32.36	32.6	13292529.0
2009-04-14 15:00:00	QQQ	ETF	32.6	32.67	32.48	32.49	21679662.0
2009-04-14 16:00:00	QQQ	ETF	32.49	32.85	32.1	32.15	10160099.0
2009-04-14 17:00:00	QQQ	ETF	32.15	32.32	32.15	32.2	1126257.0
2009-04-14 18:00:00	QQQ	ETF	32.22	32.27	32.15	32.18	152744.0
2009-04-14 19:00:00	QQQ	ETF	32.19	32.19	32.16	32.19	41211.0
2009-04-14 06:00:00	IWM	ETF	46.63	46.63	46.43	46.44	3500.0
2009-04-14 07:00:00	IWM	ETF	46.52	46.54	46.39	46.4	31962.0
2009-04-14 08:00:00	IWM	ETF	46.44	46.77	45.97	46.04	575482.0
2009-04-14 09:00:00	IWM	ETF	46.04	46.13	45.54	46.04	5868016.0
2009-04-14 10:00:00	IWM	ETF	46.04	46.525	45.87	46.31	7525821.0
2009-04-14 11:00:00	IWM	ETF	46.32	46.36	45.78	45.85	7842632.0
2009-04-14 12:00:00	IWM	ETF	45.84	45.94	45.23	45.35	7240548.0
2009-04-14 13:00:00	IWM	ETF	45.36	46.0	45.25	45.46	3305087.0
2009-04-14 14:00:00	IWM	ETF	45.47	45.77	45.27	45.77	5765408.0
2009-04-14 15:00:00	IWM	ETF	45.78	46.5	45.26	45.34	10436139.0
2009-04-14 16:00:00	IWM	ETF	45.34	46.7903	45.19	45.22	6242454.0
2009-04-14 17:00:00	IWM	ETF	45.29	45.3	45.24	45.26	9212.0
2009-04-14 18:00:00	IWM	ETF	45.16	45.16	45.08	45.08	4554.0
2009-04-14 06:00:00	DIA	ETF	80.58	80.6	80.45	80.45	800.0
2009-04-14 07:00:00	DIA	ETF	80.56	80.61	80.31	80.38	6700.0
2009-04-14 08:00:00	DIA	ETF	80.46	80.93	79.9	79.93	191934.0
2009-04-14 09:00:00	DIA	ETF	79.94	80.01	79.28	79.66	2272015.0
2009-04-14 10:00:00	DIA	ETF	79.64	80.34	79.55	80.14	2997512.0
2009-04-14 11:00:00	DIA	ETF	80.146	80.21	79.81	79.89	2126450.0

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

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