PREVIEW / etf_1hour / 2008-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-28.parquet
  size:    103 KB
  rows:    3,320

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
2008-04-28 04:00:00	SPY	ETF	139.69	139.73	139.69	139.73	600.0
2008-04-28 06:00:00	SPY	ETF	140.0	140.31	140.0	140.24	81639.0
2008-04-28 07:00:00	SPY	ETF	140.15	140.25	139.95	139.96	361325.0
2008-04-28 08:00:00	SPY	ETF	139.98	140.28	139.67	139.74	1707326.0
2008-04-28 09:00:00	SPY	ETF	139.75	139.99	139.38	139.7101	15803287.0
2008-04-28 10:00:00	SPY	ETF	139.72	140.13	139.48	140.01	22456625.0
2008-04-28 11:00:00	SPY	ETF	140.0	140.05	139.56	139.8001	10030352.0
2008-04-28 12:00:00	SPY	ETF	139.8	140.16	139.77	139.91	8268935.0
2008-04-28 13:00:00	SPY	ETF	139.92	140.21	139.9	140.19	10968907.0
2008-04-28 14:00:00	SPY	ETF	140.185	140.24	139.9	140.05	10888250.0
2008-04-28 15:00:00	SPY	ETF	140.06	140.25	139.41	139.62	19370874.0
2008-04-28 16:00:00	SPY	ETF	139.64	139.8009	139.35	139.66	3332264.0
2008-04-28 17:00:00	SPY	ETF	139.65	139.68	139.45	139.59	204086.0
2008-04-28 18:00:00	SPY	ETF	139.6	139.71	139.57	139.7	22226.0
2008-04-28 19:00:00	SPY	ETF	139.7	139.72	139.66	139.71	7947.0
2008-04-28 06:00:00	QQQ	ETF	47.32	47.36	47.31	47.31	15500.0
2008-04-28 07:00:00	QQQ	ETF	47.31	47.32	47.23	47.26	58000.0
2008-04-28 08:00:00	QQQ	ETF	47.24	47.29	47.18	47.24	693208.0
2008-04-28 09:00:00	QQQ	ETF	47.24	47.34	47.13	47.31	7922260.0
2008-04-28 10:00:00	QQQ	ETF	47.31	47.46	47.22	47.46	12758994.0
2008-04-28 11:00:00	QQQ	ETF	47.45	47.47	47.27	47.36	6871996.0
2008-04-28 12:00:00	QQQ	ETF	47.3575	47.48	47.34	47.42	5189644.0
2008-04-28 13:00:00	QQQ	ETF	47.43	47.61	47.42	47.59	7123867.0
2008-04-28 14:00:00	QQQ	ETF	47.59	47.62	47.43	47.49	7277026.0
2008-04-28 15:00:00	QQQ	ETF	47.49	47.6	47.23	47.26	13455775.0
2008-04-28 16:00:00	QQQ	ETF	47.26	47.4107	47.14	47.29	8828876.0
2008-04-28 17:00:00	QQQ	ETF	47.27	47.28	47.23	47.24	19224.0
2008-04-28 18:00:00	QQQ	ETF	47.26	47.28	47.25	47.28	7407.0
2008-04-28 19:00:00	QQQ	ETF	47.27	47.29	47.26	47.27	15935.0
2008-04-28 06:00:00	IWM	ETF	72.0	72.0	72.0	72.0	100.0
2008-04-28 07:00:00	IWM	ETF	72.03	72.07	72.02	72.07	11000.0
2008-04-28 08:00:00	IWM	ETF	72.0	72.04	71.85	71.88	132988.0
2008-04-28 09:00:00	IWM	ETF	71.82	72.23	71.59	71.93	3961399.0
2008-04-28 10:00:00	IWM	ETF	71.93	72.25	71.7	72.25	6419681.0
2008-04-28 11:00:00	IWM	ETF	72.25	72.26	71.96	72.13	2228073.0
2008-04-28 12:00:00	IWM	ETF	72.13	72.42	72.11	72.27	3851848.0
2008-04-28 13:00:00	IWM	ETF	72.27	72.51	72.25	72.49	4100879.0
2008-04-28 14:00:00	IWM	ETF	72.49	72.62	72.41	72.61	3576717.0
2008-04-28 15:00:00	IWM	ETF	72.62	72.7	72.18	72.34	6386756.0
2008-04-28 16:00:00	IWM	ETF	72.32	72.6	72.26	72.41	4026326.0
2008-04-28 17:00:00	IWM	ETF	72.34	72.34	72.32	72.32	37414.0
2008-04-28 06:00:00	DIA	ETF	129.11	129.11	129.11	129.11	100.0
2008-04-28 07:00:00	DIA	ETF	128.94	128.94	128.94	128.94	200.0
2008-04-28 08:00:00	DIA	ETF	128.94	128.99	128.69	128.7	289809.0
2008-04-28 09:00:00	DIA	ETF	128.7	129.0	128.51	128.79	828451.0
2008-04-28 10:00:00	DIA	ETF	128.78	129.0	128.59	128.91	1067389.0
2008-04-28 11:00:00	DIA	ETF	128.91	128.94	128.6	128.83	917680.0
2008-04-28 12:00:00	DIA	ETF	128.83	129.17	128.82	128.93	862073.0
2008-04-28 13:00:00	DIA	ETF	128.93	129.28	127.69	129.22	926603.0
2008-04-28 14:00:00	DIA	ETF	129.23	129.27	128.94	129.03	975588.0

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

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