PREVIEW / etf_1hour / 2008-05-28

all etf 1-hour files

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

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-28 04:00:00	SPY	ETF	138.89	138.89	138.8	138.8	1500.0
2008-05-28 05:00:00	SPY	ETF	138.84	138.92	138.81	138.92	2170.0
2008-05-28 06:00:00	SPY	ETF	138.95	139.13	138.87	138.95	7300.0
2008-05-28 07:00:00	SPY	ETF	138.92	139.28	138.92	139.26	2094438.0
2008-05-28 08:00:00	SPY	ETF	139.24	139.59	138.66	139.32	9615853.0
2008-05-28 09:00:00	SPY	ETF	139.32	140.0	138.72	138.9	20821806.0
2008-05-28 10:00:00	SPY	ETF	138.9099	138.92	138.29	138.8	33719107.0
2008-05-28 11:00:00	SPY	ETF	138.8	138.83	138.0	138.39	17718194.0
2008-05-28 12:00:00	SPY	ETF	138.4	139.28	138.05	138.55	21362767.0
2008-05-28 13:00:00	SPY	ETF	138.55	138.9	138.32	138.52	20611768.0
2008-05-28 14:00:00	SPY	ETF	138.5199	138.76	138.23	138.6	15874816.0
2008-05-28 15:00:00	SPY	ETF	138.6	139.37	138.58	139.37	33947407.0
2008-05-28 16:00:00	SPY	ETF	139.38	139.55	138.3	139.23	2921282.0
2008-05-28 17:00:00	SPY	ETF	139.24	139.26	139.08	139.23	35857.0
2008-05-28 18:00:00	SPY	ETF	139.18	139.19	139.16	139.16	14074.0
2008-05-28 19:00:00	SPY	ETF	139.2	139.21	139.13	139.13	8500.0
2008-05-28 04:00:00	QQQ	ETF	49.01	49.01	48.98	48.98	26200.0
2008-05-28 06:00:00	QQQ	ETF	49.08	49.1	49.08	49.1	2600.0
2008-05-28 07:00:00	QQQ	ETF	49.09	49.24	49.09	49.23	1261426.0
2008-05-28 08:00:00	QQQ	ETF	49.22	49.37	49.1295	49.34	3560050.0
2008-05-28 09:00:00	QQQ	ETF	49.35	49.36	49.06	49.15	17105727.0
2008-05-28 10:00:00	QQQ	ETF	49.1499	49.15	48.86	49.1	21561811.0
2008-05-28 11:00:00	QQQ	ETF	49.09	49.11	48.87	48.9399	12855233.0
2008-05-28 12:00:00	QQQ	ETF	48.94	48.94	48.75	48.89	11096923.0
2008-05-28 13:00:00	QQQ	ETF	48.9	49.08	48.87	48.94	14205861.0
2008-05-28 14:00:00	QQQ	ETF	48.95	49.05	48.84	48.97	11961104.0
2008-05-28 15:00:00	QQQ	ETF	48.97	49.24	48.95	49.23	18989102.0
2008-05-28 16:00:00	QQQ	ETF	49.24	49.34	49.22	49.25	2176985.0
2008-05-28 17:00:00	QQQ	ETF	49.23	49.25	49.1115	49.24	2134368.0
2008-05-28 18:00:00	QQQ	ETF	49.24	49.24	49.23	49.23	4455.0
2008-05-28 19:00:00	QQQ	ETF	49.23	49.23	49.21	49.21	2300.0
2008-05-28 06:00:00	IWM	ETF	73.38	73.4	73.38	73.4	20000.0
2008-05-28 07:00:00	IWM	ETF	73.38	73.59	73.35	73.59	204600.0
2008-05-28 08:00:00	IWM	ETF	73.54	73.84	73.45	73.76	641401.0
2008-05-28 09:00:00	IWM	ETF	73.75	73.76	73.29	73.35	4896279.0
2008-05-28 10:00:00	IWM	ETF	73.36	73.37	72.96	73.28	7085503.0
2008-05-28 11:00:00	IWM	ETF	73.28	73.31	72.92	73.16	5126398.0
2008-05-28 12:00:00	IWM	ETF	73.16	73.27	72.96	73.26	3685762.0
2008-05-28 13:00:00	IWM	ETF	73.25	73.4	73.05	73.12	4489710.0
2008-05-28 14:00:00	IWM	ETF	73.13	73.35	73.05	73.23	6135503.0
2008-05-28 15:00:00	IWM	ETF	73.23	73.76	73.23	73.73	11066064.0
2008-05-28 16:00:00	IWM	ETF	73.72	73.77	73.28	73.69	4610826.0
2008-05-28 17:00:00	IWM	ETF	73.67	73.68	73.34	73.68	3210816.0
2008-05-28 18:00:00	IWM	ETF	73.62	73.62	73.62	73.62	200.0
2008-05-28 19:00:00	IWM	ETF	73.64	73.66	73.64	73.64	712.0
2008-05-28 04:00:00	DIA	ETF	125.54	125.54	125.54	125.54	100.0
2008-05-28 07:00:00	DIA	ETF	125.67	125.86	125.67	125.86	14900.0
2008-05-28 08:00:00	DIA	ETF	125.84	126.13	125.72	125.97	123128.0
2008-05-28 09:00:00	DIA	ETF	125.97	125.98	125.63	125.78	1012070.0
2008-05-28 10:00:00	DIA	ETF	125.77	125.78	125.21	125.67	1339543.0

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

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