PREVIEW / etf_1hour / 2009-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-15.parquet
  size:    132 KB
  rows:    4,078

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-15 04:00:00	SPY	ETF	84.41	84.73	84.41	84.73	28190.0
2009-04-15 05:00:00	SPY	ETF	84.75	84.75	84.41	84.41	1300.0
2009-04-15 06:00:00	SPY	ETF	84.41	84.59	84.36	84.59	45020.0
2009-04-15 07:00:00	SPY	ETF	84.58	84.76	84.19	84.2	974900.0
2009-04-15 08:00:00	SPY	ETF	84.21	84.38	83.93	84.04	3829246.0
2009-04-15 09:00:00	SPY	ETF	84.04	84.65	83.61	84.28	29065117.0
2009-04-15 10:00:00	SPY	ETF	84.28	84.62	83.95	83.98	37119403.0
2009-04-15 11:00:00	SPY	ETF	83.98	84.52	83.8	84.41	24950175.0
2009-04-15 12:00:00	SPY	ETF	84.41	84.77	84.34	84.74	22468595.0
2009-04-15 13:00:00	SPY	ETF	84.75	84.885	84.19	84.38	26464635.0
2009-04-15 14:00:00	SPY	ETF	84.38	84.66	83.87	84.01	36042077.0
2009-04-15 15:00:00	SPY	ETF	84.01	85.42	83.99	85.29	55956713.0
2009-04-15 16:00:00	SPY	ETF	85.28	85.48	83.73	85.35	5730461.0
2009-04-15 17:00:00	SPY	ETF	85.37	85.48	85.29	85.43	431692.0
2009-04-15 18:00:00	SPY	ETF	85.43	85.43	85.3	85.33	108239.0
2009-04-15 19:00:00	SPY	ETF	85.32	85.35	85.28	85.33	45419.0
2009-04-15 04:00:00	QQQ	ETF	32.42	32.42	32.42	32.42	100.0
2009-04-15 06:00:00	QQQ	ETF	32.35	32.45	32.35	32.45	12644.0
2009-04-15 07:00:00	QQQ	ETF	32.42	32.48	32.31	32.31	162549.0
2009-04-15 08:00:00	QQQ	ETF	32.31	32.4	32.25	32.3	1284511.0
2009-04-15 09:00:00	QQQ	ETF	32.31	32.35	32.09	32.21	16260116.0
2009-04-15 10:00:00	QQQ	ETF	32.21	32.39	32.08	32.08	15470546.0
2009-04-15 11:00:00	QQQ	ETF	32.08	32.15	31.96	32.11	12559727.0
2009-04-15 12:00:00	QQQ	ETF	32.1125	32.21	32.07	32.18	7762271.0
2009-04-15 13:00:00	QQQ	ETF	32.18	32.31	32.15	32.21	12571347.0
2009-04-15 14:00:00	QQQ	ETF	32.2	32.26	31.85	31.9115	16810939.0
2009-04-15 15:00:00	QQQ	ETF	31.9124	32.43	31.9	32.4	25662125.0
2009-04-15 16:00:00	QQQ	ETF	32.4	32.5261	32.14	32.42	10048726.0
2009-04-15 17:00:00	QQQ	ETF	32.42	32.45	32.4	32.42	78518.0
2009-04-15 18:00:00	QQQ	ETF	32.44	32.47	32.41	32.41	74297.0
2009-04-15 19:00:00	QQQ	ETF	32.41	32.45	32.41	32.42	13250.0
2009-04-15 06:00:00	IWM	ETF	45.4	45.4	45.4	45.4	100.0
2009-04-15 07:00:00	IWM	ETF	45.52	45.64	45.36	45.36	16100.0
2009-04-15 08:00:00	IWM	ETF	45.37	45.42	45.06	45.15	553830.0
2009-04-15 09:00:00	IWM	ETF	45.16	45.55	44.1	45.49	8818862.0
2009-04-15 10:00:00	IWM	ETF	45.49	45.92	45.39	45.42	6902827.0
2009-04-15 11:00:00	IWM	ETF	45.42	45.63	45.21	45.57	3423546.0
2009-04-15 12:00:00	IWM	ETF	45.58	45.83	45.52	45.8	2409617.0
2009-04-15 13:00:00	IWM	ETF	45.8	45.9	45.46	45.55	3900243.0
2009-04-15 14:00:00	IWM	ETF	45.56	45.75	45.15	45.23	4558884.0
2009-04-15 15:00:00	IWM	ETF	45.22	46.1499	45.21	45.99	11116436.0
2009-04-15 16:00:00	IWM	ETF	45.97	46.17	45.313	45.5	4112272.0
2009-04-15 17:00:00	IWM	ETF	45.99	46.02	45.95	46.02	8862.0
2009-04-15 18:00:00	IWM	ETF	46.03	46.03	46.01	46.01	5100.0
2009-04-15 19:00:00	IWM	ETF	46.0	46.0	46.0	46.0	500.0
2009-04-15 06:00:00	DIA	ETF	79.55	79.61	79.55	79.61	300.0
2009-04-15 07:00:00	DIA	ETF	79.71	79.71	79.24	79.24	2200.0
2009-04-15 08:00:00	DIA	ETF	79.23	79.42	79.04	79.14	94149.0
2009-04-15 09:00:00	DIA	ETF	79.12	79.45	78.74	79.42	2592220.0
2009-04-15 10:00:00	DIA	ETF	79.41	79.71	79.28	79.2952	2708449.0

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

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