PREVIEW / etf_1hour / 2009-05-21

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-21.parquet
  size:    137 KB
  rows:    4,244

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-05-21 04:00:00	SPY	ETF	90.07	90.07	89.87	89.87	1165.0
2009-05-21 05:00:00	SPY	ETF	89.94	90.02	89.78	90.0	9141.0
2009-05-21 06:00:00	SPY	ETF	90.02	90.11	89.92	89.98	46729.0
2009-05-21 07:00:00	SPY	ETF	89.96	90.08	89.81	90.03	830357.0
2009-05-21 08:00:00	SPY	ETF	90.02	90.2	89.44	89.45	3796979.0
2009-05-21 09:00:00	SPY	ETF	89.45	89.8	89.25	89.36	34433103.0
2009-05-21 10:00:00	SPY	ETF	89.36	89.74	88.8	88.82	48262830.0
2009-05-21 11:00:00	SPY	ETF	88.82	89.39	88.72	89.36	24633017.0
2009-05-21 12:00:00	SPY	ETF	89.36	89.46	89.06	89.31	18400913.0
2009-05-21 13:00:00	SPY	ETF	89.325	89.43	88.74	88.94	24535495.0
2009-05-21 14:00:00	SPY	ETF	88.93	89.07	88.26	88.51	38227637.0
2009-05-21 15:00:00	SPY	ETF	88.51	89.22	88.37	89.2	49496653.0
2009-05-21 16:00:00	SPY	ETF	89.23	90.6774	88.61	89.5	15287396.0
2009-05-21 17:00:00	SPY	ETF	89.49	89.53	89.4	89.46	143606.0
2009-05-21 18:00:00	SPY	ETF	89.46	89.7706	88.27	89.5	534460.0
2009-05-21 19:00:00	SPY	ETF	89.5	89.5	89.36	89.36	28194.0
2009-05-21 04:00:00	QQQ	ETF	34.18	34.18	34.07	34.07	3300.0
2009-05-21 06:00:00	QQQ	ETF	34.11	34.11	34.11	34.11	100.0
2009-05-21 07:00:00	QQQ	ETF	34.12	34.15	34.05	34.15	151075.0
2009-05-21 08:00:00	QQQ	ETF	34.12	34.15	33.96	33.96	1569536.0
2009-05-21 09:00:00	QQQ	ETF	33.95	34.26	33.84	34.01	20119985.0
2009-05-21 10:00:00	QQQ	ETF	34.01	34.16	33.63	33.65	27466852.0
2009-05-21 11:00:00	QQQ	ETF	33.66	33.73	33.51	33.71	14064050.0
2009-05-21 12:00:00	QQQ	ETF	33.7	33.74	33.53	33.6499	8753620.0
2009-05-21 13:00:00	QQQ	ETF	33.64	33.71	33.45	33.54	10969768.0
2009-05-21 14:00:00	QQQ	ETF	33.53	33.62	33.31	33.42	15233469.0
2009-05-21 15:00:00	QQQ	ETF	33.42	33.68	33.39	33.67	19821224.0
2009-05-21 16:00:00	QQQ	ETF	33.68	34.3116	33.55	33.75	13488687.0
2009-05-21 17:00:00	QQQ	ETF	33.75	33.76	33.7	33.7	58300.0
2009-05-21 18:00:00	QQQ	ETF	33.71	33.75	33.7	33.72	70830.0
2009-05-21 19:00:00	QQQ	ETF	33.72	33.74	33.7	33.71	14400.0
2009-05-21 05:00:00	IWM	ETF	48.75	48.75	48.75	48.75	1000.0
2009-05-21 06:00:00	IWM	ETF	48.61	48.61	48.61	48.61	200.0
2009-05-21 07:00:00	IWM	ETF	48.6	48.72	48.54	48.72	40101.0
2009-05-21 08:00:00	IWM	ETF	48.69	48.69	48.26	48.27	801815.0
2009-05-21 09:00:00	IWM	ETF	48.26	48.7	48.14	48.32	6154710.0
2009-05-21 10:00:00	IWM	ETF	48.35	48.61	47.8	47.81	10380022.0
2009-05-21 11:00:00	IWM	ETF	47.82	48.25	47.72	48.21	4021002.0
2009-05-21 12:00:00	IWM	ETF	48.21	48.26	47.87	48.07	4531577.0
2009-05-21 13:00:00	IWM	ETF	48.079	48.21	47.79	47.9	3726075.0
2009-05-21 14:00:00	IWM	ETF	47.9	48.0	47.45	47.66	5926480.0
2009-05-21 15:00:00	IWM	ETF	47.6599	48.29	47.61	48.28	8685623.0
2009-05-21 16:00:00	IWM	ETF	48.27	48.52	47.5	48.44	1769576.0
2009-05-21 17:00:00	IWM	ETF	48.42	48.47	48.38	48.45	2800.0
2009-05-21 18:00:00	IWM	ETF	48.44	48.44	48.36	48.42	300.0
2009-05-21 19:00:00	IWM	ETF	48.46	48.46	48.4	48.46	500.0
2009-05-21 06:00:00	DIA	ETF	83.77	83.78	83.73	83.78	1000.0
2009-05-21 07:00:00	DIA	ETF	83.66	83.84	83.66	83.84	6200.0
2009-05-21 08:00:00	DIA	ETF	83.78	83.81	83.31	83.31	110147.0
2009-05-21 09:00:00	DIA	ETF	83.31	83.34	82.95	82.96	3013928.0

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

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