PREVIEW / etf_1hour / 2010-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-23.parquet
  size:    173 KB
  rows:    5,344

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
2010-11-23 04:00:00	SPY	ETF	119.42	119.64	119.38	119.45	21329.0
2010-11-23 05:00:00	SPY	ETF	119.26	119.46	119.25	119.46	8400.0
2010-11-23 06:00:00	SPY	ETF	119.46	119.63	119.3	119.38	65080.0
2010-11-23 07:00:00	SPY	ETF	119.38	119.45	118.81	118.9	1565765.0
2010-11-23 08:00:00	SPY	ETF	118.89	119.15	118.77	118.96	5630910.0
2010-11-23 09:00:00	SPY	ETF	118.94	119.11	118.27	118.3538	30611076.0
2010-11-23 10:00:00	SPY	ETF	118.35	118.81	118.21	118.73	30243795.0
2010-11-23 11:00:00	SPY	ETF	118.73	118.73	117.99	118.33	27013527.0
2010-11-23 12:00:00	SPY	ETF	118.3201	118.66	118.17	118.6	18020669.0
2010-11-23 13:00:00	SPY	ETF	118.63	118.72	118.3	118.3799	18693161.0
2010-11-23 14:00:00	SPY	ETF	118.37	118.54	118.17	118.36	26237353.0
2010-11-23 15:00:00	SPY	ETF	118.35	118.73	118.28	118.42	41033528.0
2010-11-23 16:00:00	SPY	ETF	118.43	120.1288	118.12	118.18	13411719.0
2010-11-23 17:00:00	SPY	ETF	118.18	118.25	118.1	118.18	4267481.0
2010-11-23 18:00:00	SPY	ETF	118.23	118.66	118.23	118.64	261339.0
2010-11-23 19:00:00	SPY	ETF	118.62	118.77	118.58	118.72	198601.0
2010-11-23 05:00:00	QQQ	ETF	52.65	52.72	52.65	52.72	40100.0
2010-11-23 06:00:00	QQQ	ETF	52.75	52.75	52.67	52.7	1310.0
2010-11-23 07:00:00	QQQ	ETF	52.7	52.71	52.41	52.47	417246.0
2010-11-23 08:00:00	QQQ	ETF	52.46	52.64	52.43	52.5	836987.0
2010-11-23 09:00:00	QQQ	ETF	52.5	52.59	52.09	52.1	10447631.0
2010-11-23 10:00:00	QQQ	ETF	52.1	52.28	52.0115	52.2	9072111.0
2010-11-23 11:00:00	QQQ	ETF	52.2	52.2	51.77	51.9	9001197.0
2010-11-23 12:00:00	QQQ	ETF	51.9	52.01	51.81	52.0	5419276.0
2010-11-23 13:00:00	QQQ	ETF	52.0	52.05	51.9	51.92	4360665.0
2010-11-23 14:00:00	QQQ	ETF	51.93	52.03	51.86	51.97	5746466.0
2010-11-23 15:00:00	QQQ	ETF	51.97	52.11	51.94	52.08	12240182.0
2010-11-23 16:00:00	QQQ	ETF	52.065	52.155	51.967	52.02	2236539.0
2010-11-23 17:00:00	QQQ	ETF	52.04	52.0501	51.96	51.99	6034481.0
2010-11-23 18:00:00	QQQ	ETF	52.04	52.21	52.04	52.19	94358.0
2010-11-23 19:00:00	QQQ	ETF	52.19	52.24	52.19	52.23	56277.0
2010-11-23 04:00:00	IWM	ETF	72.55	72.55	72.55	72.55	1000.0
2010-11-23 05:00:00	IWM	ETF	72.4	72.4	72.4	72.4	100.0
2010-11-23 07:00:00	IWM	ETF	72.34	72.37	71.81	71.85	150275.0
2010-11-23 08:00:00	IWM	ETF	71.87	72.15	71.86	72.03	464022.0
2010-11-23 09:00:00	IWM	ETF	72.02	72.1401	71.72	71.77	6855796.0
2010-11-23 10:00:00	IWM	ETF	71.78	72.24	71.7	72.14	7633354.0
2010-11-23 11:00:00	IWM	ETF	72.13	72.14	71.5	71.63	8063123.0
2010-11-23 12:00:00	IWM	ETF	71.62	72.139	71.52	72.07	4240812.0
2010-11-23 13:00:00	IWM	ETF	72.08	72.19	71.955	72.0	3801690.0
2010-11-23 14:00:00	IWM	ETF	72.0	72.13	71.75	71.88	4557420.0
2010-11-23 15:00:00	IWM	ETF	71.88	72.12	71.85	72.12	8143459.0
2010-11-23 16:00:00	IWM	ETF	72.12	72.8141	71.6	71.98	4657484.0
2010-11-23 17:00:00	IWM	ETF	71.93	72.01	71.9	72.01	13811.0
2010-11-23 18:00:00	IWM	ETF	72.0	72.14	72.0	72.12	11200.0
2010-11-23 19:00:00	IWM	ETF	72.18	72.21	72.17	72.21	11100.0
2010-11-23 05:00:00	DIA	ETF	111.27	111.27	111.27	111.27	2000.0
2010-11-23 07:00:00	DIA	ETF	111.13	111.13	110.8	110.82	10000.0
2010-11-23 08:00:00	DIA	ETF	110.82	111.02	110.72	110.82	22600.0
2010-11-23 09:00:00	DIA	ETF	110.83	111.03	110.15	110.295	984350.0

> showing 50 of 5,344 rows — these rows as CSV

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