PREVIEW / etf_1hour / 2008-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-25.parquet
  size:    101 KB
  rows:    3,396

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-02-25 04:00:00	SPY	ETF	136.12	136.33	136.12	136.33	1600.0
2008-02-25 05:00:00	SPY	ETF	136.04	136.1	136.04	136.1	6100.0
2008-02-25 06:00:00	SPY	ETF	136.25	136.26	136.0	136.0	40300.0
2008-02-25 07:00:00	SPY	ETF	136.02	136.05	135.65	135.78	655100.0
2008-02-25 08:00:00	SPY	ETF	135.75	135.87	135.45	135.61	1003900.0
2008-02-25 09:00:00	SPY	ETF	135.61	135.85	134.85	134.92	17872953.0
2008-02-25 10:00:00	SPY	ETF	134.92	136.52	134.78	136.44	31282733.0
2008-02-25 11:00:00	SPY	ETF	136.44	136.47	135.52	135.59	14191207.0
2008-02-25 12:00:00	SPY	ETF	135.58	135.96	135.35	135.74	12205408.0
2008-02-25 13:00:00	SPY	ETF	135.74	136.07	135.25	135.73	14088172.0
2008-02-25 14:00:00	SPY	ETF	135.73	137.27	135.4449	136.55	53938759.0
2008-02-25 15:00:00	SPY	ETF	136.55	137.65	136.1472	137.31	35776842.0
2008-02-25 16:00:00	SPY	ETF	137.291	137.51	135.33	137.28	5420400.0
2008-02-25 17:00:00	SPY	ETF	137.27	137.33	137.16	137.16	318200.0
2008-02-25 18:00:00	SPY	ETF	137.15	137.27	137.1	137.14	231900.0
2008-02-25 19:00:00	SPY	ETF	137.14	137.32	137.09	137.29	89700.0
2008-02-25 04:00:00	QQQ	ETF	43.84	43.84	43.84	43.84	120.0
2008-02-25 05:00:00	QQQ	ETF	43.85	43.85	43.85	43.85	200.0
2008-02-25 06:00:00	QQQ	ETF	43.85	43.85	43.74	43.78	135100.0
2008-02-25 07:00:00	QQQ	ETF	43.76	43.78	43.63	43.67	181466.0
2008-02-25 08:00:00	QQQ	ETF	43.68	43.69	43.57	43.61	1122871.0
2008-02-25 09:00:00	QQQ	ETF	43.6	43.71	43.4	43.42	11755293.0
2008-02-25 10:00:00	QQQ	ETF	43.42	43.95	43.34	43.88	27241371.0
2008-02-25 11:00:00	QQQ	ETF	43.89	43.92	43.63	43.66	11446352.0
2008-02-25 12:00:00	QQQ	ETF	43.65	43.7	43.51	43.68	8900692.0
2008-02-25 13:00:00	QQQ	ETF	43.68	43.75	43.34	43.52	10975354.0
2008-02-25 14:00:00	QQQ	ETF	43.51	44.0	43.43	43.7	24372745.0
2008-02-25 15:00:00	QQQ	ETF	43.7	44.07	43.61	43.9	22878835.0
2008-02-25 16:00:00	QQQ	ETF	43.9	43.92	43.84	43.88	2269822.0
2008-02-25 17:00:00	QQQ	ETF	43.86	43.92	43.86	43.89	60468.0
2008-02-25 18:00:00	QQQ	ETF	43.9	43.91	43.86	43.86	73811.0
2008-02-25 19:00:00	QQQ	ETF	43.86	43.94	43.86	43.92	29730.0
2008-02-25 07:00:00	IWM	ETF	69.52	69.52	69.37	69.42	93200.0
2008-02-25 08:00:00	IWM	ETF	69.4	69.43	69.29	69.34	713200.0
2008-02-25 09:00:00	IWM	ETF	69.35	69.55	69.03	69.11	7340054.0
2008-02-25 10:00:00	IWM	ETF	69.1	70.19	69.03	70.03	11711416.0
2008-02-25 11:00:00	IWM	ETF	70.01	70.05	69.45	69.49	5253399.0
2008-02-25 12:00:00	IWM	ETF	69.49	69.69	69.26	69.58	4358689.0
2008-02-25 13:00:00	IWM	ETF	69.57	69.79	69.15	69.52	10849181.0
2008-02-25 14:00:00	IWM	ETF	69.53	70.61	69.38	70.29	15939406.0
2008-02-25 15:00:00	IWM	ETF	70.29	71.0	70.09	70.78	17006130.0
2008-02-25 16:00:00	IWM	ETF	70.78	70.87	69.3	70.78	3134500.0
2008-02-25 17:00:00	IWM	ETF	70.77	70.81	70.73	70.75	10100.0
2008-02-25 18:00:00	IWM	ETF	70.68	70.76	70.68	70.76	4400.0
2008-02-25 19:00:00	IWM	ETF	70.73	70.77	70.72	70.77	3700.0
2008-02-25 07:00:00	DIA	ETF	124.18	124.18	123.9	123.95	5300.0
2008-02-25 08:00:00	DIA	ETF	123.94	123.94	123.66	123.72	49800.0
2008-02-25 09:00:00	DIA	ETF	123.75	124.09	123.48	123.55	1402965.0
2008-02-25 10:00:00	DIA	ETF	123.55	124.95	123.41	124.88	3412697.0
2008-02-25 11:00:00	DIA	ETF	124.89	124.92	124.1	124.11	1178525.0

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

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