PREVIEW / etf_1hour / 2008-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-29.parquet
  size:    105 KB
  rows:    3,353

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-05-29 04:00:00	SPY	ETF	139.72	139.8	139.62	139.65	24300.0
2008-05-29 06:00:00	SPY	ETF	139.42	139.42	139.25	139.25	205500.0
2008-05-29 07:00:00	SPY	ETF	139.33	139.54	139.27	139.5	630580.0
2008-05-29 08:00:00	SPY	ETF	139.5	139.65	139.04	139.04	2140254.0
2008-05-29 09:00:00	SPY	ETF	139.05	139.63	138.97	139.53	13678780.0
2008-05-29 10:00:00	SPY	ETF	139.53	140.14	139.08	139.96	42005944.0
2008-05-29 11:00:00	SPY	ETF	139.95	140.37	139.85	140.2796	23843411.0
2008-05-29 12:00:00	SPY	ETF	140.27	140.79	140.0	140.67	20460207.0
2008-05-29 13:00:00	SPY	ETF	140.68	140.78	140.45	140.58	12337645.0
2008-05-29 14:00:00	SPY	ETF	140.57	140.93	140.27	140.38	23891525.0
2008-05-29 15:00:00	SPY	ETF	140.38	140.4	139.96	140.03	28507480.0
2008-05-29 16:00:00	SPY	ETF	140.0299	140.22	139.96	140.14	3476446.0
2008-05-29 17:00:00	SPY	ETF	140.15	140.16	140.0	140.08	143426.0
2008-05-29 18:00:00	SPY	ETF	140.11	140.11	139.79	139.82	78113.0
2008-05-29 19:00:00	SPY	ETF	139.84	139.96	139.84	139.92	17146.0
2008-05-29 04:00:00	QQQ	ETF	49.43	49.43	49.42	49.42	10000.0
2008-05-29 06:00:00	QQQ	ETF	49.38	49.38	49.26	49.26	2000.0
2008-05-29 07:00:00	QQQ	ETF	49.29	49.36	49.26	49.33	151707.0
2008-05-29 08:00:00	QQQ	ETF	49.29	49.45	49.17	49.18	1458260.0
2008-05-29 09:00:00	QQQ	ETF	49.18	49.56	49.18	49.52	13688983.0
2008-05-29 10:00:00	QQQ	ETF	49.52	49.65	49.25	49.54	32767555.0
2008-05-29 11:00:00	QQQ	ETF	49.54	49.74	49.45	49.6776	19136602.0
2008-05-29 12:00:00	QQQ	ETF	49.68	49.9	49.6	49.84	14935214.0
2008-05-29 13:00:00	QQQ	ETF	49.84	49.91	49.76	49.77	8838035.0
2008-05-29 14:00:00	QQQ	ETF	49.78	49.97	49.72	49.78	14749263.0
2008-05-29 15:00:00	QQQ	ETF	49.77	49.81	49.65	49.68	18808096.0
2008-05-29 16:00:00	QQQ	ETF	49.69	49.84	49.2259	49.8	13385018.0
2008-05-29 17:00:00	QQQ	ETF	49.83	49.87	49.8	49.84	466987.0
2008-05-29 18:00:00	QQQ	ETF	49.85	49.87	49.79	49.79	68507.0
2008-05-29 19:00:00	QQQ	ETF	49.79	49.84	49.79	49.82	15080.0
2008-05-29 06:00:00	IWM	ETF	73.68	73.68	73.68	73.68	200.0
2008-05-29 08:00:00	IWM	ETF	73.75	73.8	73.52	73.52	267614.0
2008-05-29 09:00:00	IWM	ETF	73.52	73.96	73.45	73.89	4967147.0
2008-05-29 10:00:00	IWM	ETF	73.89	74.26	73.71	74.13	10562541.0
2008-05-29 11:00:00	IWM	ETF	74.12	74.47	74.05	74.38	6955410.0
2008-05-29 12:00:00	IWM	ETF	74.38	74.95	74.32	74.89	10790693.0
2008-05-29 13:00:00	IWM	ETF	74.89	74.95	74.69	74.77	5646341.0
2008-05-29 14:00:00	IWM	ETF	74.77	75.02	74.56	74.6	7877100.0
2008-05-29 15:00:00	IWM	ETF	74.6	74.66	74.25	74.37	12599762.0
2008-05-29 16:00:00	IWM	ETF	74.37	74.46	73.76	73.76	4893071.0
2008-05-29 17:00:00	IWM	ETF	74.48	74.48	73.76	74.35	1012614.0
2008-05-29 18:00:00	IWM	ETF	74.37	74.37	74.37	74.37	800.0
2008-05-29 07:00:00	DIA	ETF	125.91	126.01	125.88	126.01	4400.0
2008-05-29 08:00:00	DIA	ETF	125.99	126.17	125.7	125.7	48841.0
2008-05-29 09:00:00	DIA	ETF	125.7	126.05	125.58	125.97	705664.0
2008-05-29 10:00:00	DIA	ETF	125.97	126.37	125.49	126.24	1966341.0
2008-05-29 11:00:00	DIA	ETF	126.23	126.67	126.12	126.6	1636730.0
2008-05-29 12:00:00	DIA	ETF	126.61	127.18	126.54	127.1	1872840.0
2008-05-29 13:00:00	DIA	ETF	127.09	127.23	126.92	126.96	1136393.0
2008-05-29 14:00:00	DIA	ETF	126.96	127.21	126.63	126.75	1912923.0

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

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