PREVIEW / etf_1hour / 2009-05-12

all etf 1-hour files

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

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-12 04:00:00	SPY	ETF	91.76	91.92	91.69	91.69	5200.0
2009-05-12 05:00:00	SPY	ETF	91.89	91.92	91.71	91.8	1009.0
2009-05-12 06:00:00	SPY	ETF	91.75	91.75	91.28	91.34	86300.0
2009-05-12 07:00:00	SPY	ETF	91.31	91.71	91.3	91.68	919879.0
2009-05-12 08:00:00	SPY	ETF	91.68	92.0	90.8	91.77	3019536.0
2009-05-12 09:00:00	SPY	ETF	91.76	91.83	90.82	91.05	33260750.0
2009-05-12 10:00:00	SPY	ETF	91.05	91.05	90.39	90.83	36008054.0
2009-05-12 11:00:00	SPY	ETF	90.83	90.9	90.33	90.48	30073095.0
2009-05-12 12:00:00	SPY	ETF	90.47	90.58	89.86	89.8899	26263416.0
2009-05-12 13:00:00	SPY	ETF	89.8891	90.37	89.85	90.17	26253183.0
2009-05-12 14:00:00	SPY	ETF	90.17	91.24	90.09	91.12	55870105.0
2009-05-12 15:00:00	SPY	ETF	91.13	91.69	90.74	91.02	62460646.0
2009-05-12 16:00:00	SPY	ETF	91.02	91.35	90.05	91.29	7260076.0
2009-05-12 17:00:00	SPY	ETF	91.29	91.4	91.28	91.36	303246.0
2009-05-12 18:00:00	SPY	ETF	91.36	91.38	91.25	91.25	59914.0
2009-05-12 19:00:00	SPY	ETF	91.3	91.3	91.14	91.23	131450.0
2009-05-12 04:00:00	QQQ	ETF	34.59	34.59	34.55	34.55	2200.0
2009-05-12 06:00:00	QQQ	ETF	34.43	34.43	34.35	34.35	700.0
2009-05-12 07:00:00	QQQ	ETF	34.33	34.54	34.33	34.51	163839.0
2009-05-12 08:00:00	QQQ	ETF	34.52	34.65	34.37	34.55	2567031.0
2009-05-12 09:00:00	QQQ	ETF	34.55	34.55	33.92	34.0201	22886497.0
2009-05-12 10:00:00	QQQ	ETF	34.03	34.08	33.8	33.94	18426376.0
2009-05-12 11:00:00	QQQ	ETF	33.94	33.965	33.69	33.74	13327711.0
2009-05-12 12:00:00	QQQ	ETF	33.73	33.76	33.52	33.53	16198202.0
2009-05-12 13:00:00	QQQ	ETF	33.52	33.76	33.52	33.67	16764109.0
2009-05-12 14:00:00	QQQ	ETF	33.68	34.14	33.64	33.89	15330579.0
2009-05-12 15:00:00	QQQ	ETF	33.89	34.12	33.63	33.93	27495138.0
2009-05-12 16:00:00	QQQ	ETF	33.92	34.3441	33.8	34.13	10953894.0
2009-05-12 17:00:00	QQQ	ETF	34.14	34.17	34.13	34.15	222724.0
2009-05-12 18:00:00	QQQ	ETF	34.16	34.17	34.13	34.15	58999.0
2009-05-12 19:00:00	QQQ	ETF	34.15	34.16	34.09	34.16	85374.0
2009-05-12 04:00:00	IWM	ETF	50.71	50.71	50.58	50.58	2389.0
2009-05-12 06:00:00	IWM	ETF	50.64	50.64	50.38	50.43	4600.0
2009-05-12 07:00:00	IWM	ETF	50.5	50.68	50.5	50.62	8200.0
2009-05-12 08:00:00	IWM	ETF	50.63	50.9	50.42	50.6	413652.0
2009-05-12 09:00:00	IWM	ETF	50.6	50.82	49.8	50.018	4814577.0
2009-05-12 10:00:00	IWM	ETF	50.01	50.07	49.2	49.57	7675608.0
2009-05-12 11:00:00	IWM	ETF	49.57	49.58	49.19	49.33	4341758.0
2009-05-12 12:00:00	IWM	ETF	49.32	49.36	48.74	48.78	6038448.0
2009-05-12 13:00:00	IWM	ETF	48.78	49.11	48.71	48.92	4323875.0
2009-05-12 14:00:00	IWM	ETF	48.92	49.71	48.87	49.61	6123239.0
2009-05-12 15:00:00	IWM	ETF	49.61	50.01	49.43	49.57	10037704.0
2009-05-12 16:00:00	IWM	ETF	49.57	49.83	49.1	49.55	4914934.0
2009-05-12 17:00:00	IWM	ETF	49.78	49.82	49.78	49.8	53389.0
2009-05-12 18:00:00	IWM	ETF	49.77	49.77	49.77	49.77	200.0
2009-05-12 19:00:00	IWM	ETF	49.68	49.7	49.68	49.69	700.0
2009-05-12 04:00:00	DIA	ETF	84.95	84.95	84.95	84.95	100.0
2009-05-12 05:00:00	DIA	ETF	84.85	84.85	84.85	84.85	100.0
2009-05-12 06:00:00	DIA	ETF	84.68	84.68	84.68	84.68	100.0
2009-05-12 07:00:00	DIA	ETF	84.66	84.82	84.66	84.82	400.0

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

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