PREVIEW / etf_1hour / 2011-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-17.parquet
  size:    182 KB
  rows:    5,562

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-08-17 04:00:00	SPY	ETF	119.5	119.99	119.41	119.41	2400.0
2011-08-17 05:00:00	SPY	ETF	119.8	119.96	119.72	119.87	1880.0
2011-08-17 06:00:00	SPY	ETF	119.8	120.43	119.6	120.25	176098.0
2011-08-17 07:00:00	SPY	ETF	120.27	120.4	120.12	120.29	850420.0
2011-08-17 08:00:00	SPY	ETF	120.29	120.33	119.92	120.1	1197953.0
2011-08-17 09:00:00	SPY	ETF	120.11	121.18	120.04	121.0	23924687.0
2011-08-17 10:00:00	SPY	ETF	120.99	121.2	120.35	120.36	33342879.0
2011-08-17 11:00:00	SPY	ETF	120.35	120.74	119.59	119.74	31817170.0
2011-08-17 12:00:00	SPY	ETF	119.74	119.86	119.22	119.39	25321008.0
2011-08-17 13:00:00	SPY	ETF	119.39	119.55	118.72	119.11	29700949.0
2011-08-17 14:00:00	SPY	ETF	119.11	119.63	119.06	119.56	21189430.0
2011-08-17 15:00:00	SPY	ETF	119.56	119.79	119.35	119.6702	49161569.0
2011-08-17 16:00:00	SPY	ETF	119.7	120.0	119.15	119.27	15026792.0
2011-08-17 17:00:00	SPY	ETF	119.28	119.9176	119.24	119.33	5886077.0
2011-08-17 18:00:00	SPY	ETF	119.31	119.67	119.23	119.37	386057.0
2011-08-17 19:00:00	SPY	ETF	119.34	119.39	119.21	119.33	59849.0
2011-08-17 06:00:00	QQQ	ETF	53.83	54.1	53.83	54.08	1400.0
2011-08-17 07:00:00	QQQ	ETF	54.05	54.12	54.0	54.1	105025.0
2011-08-17 08:00:00	QQQ	ETF	54.08	54.1	53.91	53.99	604726.0
2011-08-17 09:00:00	QQQ	ETF	53.99	54.42	53.84	54.34	9116269.0
2011-08-17 10:00:00	QQQ	ETF	54.34	54.36	53.88	53.88	10809366.0
2011-08-17 11:00:00	QQQ	ETF	53.88	54.03	53.43	53.53	12243437.0
2011-08-17 12:00:00	QQQ	ETF	53.511	53.68	53.26	53.46	12380629.0
2011-08-17 13:00:00	QQQ	ETF	53.45	53.45	53.02	53.17	13692097.0
2011-08-17 14:00:00	QQQ	ETF	53.17	53.48	53.17	53.42	6824240.0
2011-08-17 15:00:00	QQQ	ETF	53.42	53.6	53.33	53.58	10608377.0
2011-08-17 16:00:00	QQQ	ETF	53.58	53.62	53.26	53.28	2362895.0
2011-08-17 17:00:00	QQQ	ETF	53.28	53.34	53.27	53.32	183356.0
2011-08-17 18:00:00	QQQ	ETF	53.3	53.34	53.28	53.31	30822.0
2011-08-17 19:00:00	QQQ	ETF	53.31	53.32	53.26	53.31	60387.0
2011-08-17 05:00:00	IWM	ETF	70.79	70.79	70.79	70.79	100.0
2011-08-17 06:00:00	IWM	ETF	71.0	71.0	71.0	71.0	2500.0
2011-08-17 07:00:00	IWM	ETF	71.0	71.0	70.8	70.89	26400.0
2011-08-17 08:00:00	IWM	ETF	70.98	71.05	70.7	70.85	293676.0
2011-08-17 09:00:00	IWM	ETF	70.85	71.49	70.44	71.35	7096401.0
2011-08-17 10:00:00	IWM	ETF	71.35	71.52	70.86	70.86	8908309.0
2011-08-17 11:00:00	IWM	ETF	70.86	71.185	69.97	70.16	9138297.0
2011-08-17 12:00:00	IWM	ETF	70.16	70.39	69.86	70.04	6659289.0
2011-08-17 13:00:00	IWM	ETF	70.04	70.2	69.76	69.885	7468235.0
2011-08-17 14:00:00	IWM	ETF	69.88	70.31	69.87	70.26	4535768.0
2011-08-17 15:00:00	IWM	ETF	70.26	70.46	70.12	70.44	7605360.0
2011-08-17 16:00:00	IWM	ETF	70.45	70.59	70.21	70.27	2688258.0
2011-08-17 17:00:00	IWM	ETF	70.27	70.32	70.17	70.17	137125.0
2011-08-17 18:00:00	IWM	ETF	70.04	70.21	70.04	70.21	744.0
2011-08-17 19:00:00	IWM	ETF	70.28	70.28	70.17	70.22	3508.0
2011-08-17 06:00:00	DIA	ETF	114.65	114.65	114.65	114.65	1000.0
2011-08-17 07:00:00	DIA	ETF	114.47	114.7	114.47	114.7	21200.0
2011-08-17 08:00:00	DIA	ETF	114.53	114.72	114.44	114.48	19050.0
2011-08-17 09:00:00	DIA	ETF	114.62	115.33	114.52	115.1627	1523861.0
2011-08-17 10:00:00	DIA	ETF	115.16	115.46	114.79	114.8	879001.0

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

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