PREVIEW / etf_1hour / 2011-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-14.parquet
  size:    181 KB
  rows:    5,507

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
2011-03-14 04:00:00	SPY	ETF	130.5	131.25	129.89	130.26	81496.0
2011-03-14 05:00:00	SPY	ETF	130.26	130.72	130.26	130.56	18858.0
2011-03-14 06:00:00	SPY	ETF	130.7	130.8	130.45	130.49	130079.0
2011-03-14 07:00:00	SPY	ETF	130.56	130.63	130.05	130.14	1665858.0
2011-03-14 08:00:00	SPY	ETF	130.15	130.61	129.98	130.21	5660030.0
2011-03-14 09:00:00	SPY	ETF	130.22	130.45	129.92	130.28	26236312.0
2011-03-14 10:00:00	SPY	ETF	130.29	130.48	129.46	129.62	34419135.0
2011-03-14 11:00:00	SPY	ETF	129.61	129.83	129.12	129.319	33637462.0
2011-03-14 12:00:00	SPY	ETF	129.32	129.43	129.06	129.37	16808194.0
2011-03-14 13:00:00	SPY	ETF	129.37	129.63	129.26	129.47	16618061.0
2011-03-14 14:00:00	SPY	ETF	129.48	129.94	129.45	129.54	21476876.0
2011-03-14 15:00:00	SPY	ETF	129.54	130.3	129.35	130.07	41599302.0
2011-03-14 16:00:00	SPY	ETF	130.07	130.8862	129.24	130.06	28984190.0
2011-03-14 17:00:00	SPY	ETF	130.06	130.09	130.02	130.06	2197947.0
2011-03-14 18:00:00	SPY	ETF	130.06	130.25	130.05	130.06	246691.0
2011-03-14 19:00:00	SPY	ETF	130.14	130.17	129.33	129.56	425501.0
2011-03-14 04:00:00	QQQ	ETF	56.22	56.22	56.0	56.09	4300.0
2011-03-14 05:00:00	QQQ	ETF	56.34	56.34	56.25	56.25	2100.0
2011-03-14 06:00:00	QQQ	ETF	56.34	56.38	56.2	56.2	3558.0
2011-03-14 07:00:00	QQQ	ETF	56.28	56.29	56.09	56.15	528611.0
2011-03-14 08:00:00	QQQ	ETF	56.16	56.3	56.13	56.23	1488215.0
2011-03-14 09:00:00	QQQ	ETF	56.23	56.59	56.14	56.5399	8707274.0
2011-03-14 10:00:00	QQQ	ETF	56.54	56.59	56.06	56.06	15204772.0
2011-03-14 11:00:00	QQQ	ETF	56.07	56.195	55.9	55.95	12311403.0
2011-03-14 12:00:00	QQQ	ETF	55.9598	56.04	55.86	56.0398	5361692.0
2011-03-14 13:00:00	QQQ	ETF	56.03	56.17	55.99	56.08	6320283.0
2011-03-14 14:00:00	QQQ	ETF	56.08	56.28	56.04	56.095	5799764.0
2011-03-14 15:00:00	QQQ	ETF	56.095	56.4	56.08	56.29	11394206.0
2011-03-14 16:00:00	QQQ	ETF	56.29	56.4947	56.19	56.32	4460148.0
2011-03-14 17:00:00	QQQ	ETF	56.33	56.36	56.33	56.35	16309.0
2011-03-14 18:00:00	QQQ	ETF	56.34	56.4	56.28	56.32	37436.0
2011-03-14 19:00:00	QQQ	ETF	56.32	56.32	55.99	56.14	50617.0
2011-03-14 04:00:00	IWM	ETF	79.3	79.37	79.18	79.18	2156.0
2011-03-14 05:00:00	IWM	ETF	79.67	79.67	79.67	79.67	400.0
2011-03-14 06:00:00	IWM	ETF	79.88	79.88	79.58	79.65	2900.0
2011-03-14 07:00:00	IWM	ETF	79.68	79.68	79.27	79.37	163044.0
2011-03-14 08:00:00	IWM	ETF	79.37	79.53	79.3	79.47	220732.0
2011-03-14 09:00:00	IWM	ETF	79.5	80.33	79.29	80.19	8171975.0
2011-03-14 10:00:00	IWM	ETF	80.19	80.31	79.5	79.5433	8618324.0
2011-03-14 11:00:00	IWM	ETF	79.56	79.68	78.91	79.2799	10744759.0
2011-03-14 12:00:00	IWM	ETF	79.28	79.42	79.12	79.38	4727153.0
2011-03-14 13:00:00	IWM	ETF	79.37	79.75	79.35	79.49	5565855.0
2011-03-14 14:00:00	IWM	ETF	79.49	79.83	79.47	79.57	4351012.0
2011-03-14 15:00:00	IWM	ETF	79.56	80.03	79.52	79.75	9324614.0
2011-03-14 16:00:00	IWM	ETF	79.76	79.99	79.65	79.92	1056041.0
2011-03-14 17:00:00	IWM	ETF	79.92	79.96	79.9	79.9	2000.0
2011-03-14 18:00:00	IWM	ETF	79.95	79.98	79.95	79.95	6611.0
2011-03-14 19:00:00	IWM	ETF	79.83	79.83	79.6	79.65	17500.0
2011-03-14 04:00:00	DIA	ETF	119.79	119.79	119.77	119.77	1000.0
2011-03-14 05:00:00	DIA	ETF	120.15	120.27	120.15	120.16	1940.0

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

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