PREVIEW / etf_1hour / 2011-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-19.parquet
  size:    178 KB
  rows:    5,399

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-04-19 04:00:00	SPY	ETF	130.34	130.35	130.24	130.34	2899.0
2011-04-19 05:00:00	SPY	ETF	130.35	130.59	130.35	130.59	6343.0
2011-04-19 06:00:00	SPY	ETF	130.59	130.59	130.41	130.49	31483.0
2011-04-19 07:00:00	SPY	ETF	130.55	130.81	130.53	130.75	606883.0
2011-04-19 08:00:00	SPY	ETF	130.72	130.91	130.62	130.76	2147179.0
2011-04-19 09:00:00	SPY	ETF	130.76	131.07	130.53	130.79	18912982.0
2011-04-19 10:00:00	SPY	ETF	130.8	131.03	130.63	130.68	19937176.0
2011-04-19 11:00:00	SPY	ETF	130.68	130.725	130.44	130.65	15421056.0
2011-04-19 12:00:00	SPY	ETF	130.66	130.81	130.6	130.75	9345711.0
2011-04-19 13:00:00	SPY	ETF	130.75	131.22	130.745	131.12	19408210.0
2011-04-19 14:00:00	SPY	ETF	131.12	131.23	131.04	131.1	8744799.0
2011-04-19 15:00:00	SPY	ETF	131.09	131.35	131.09	131.29	19565343.0
2011-04-19 16:00:00	SPY	ETF	131.28	131.75	130.5801	131.55	8936882.0
2011-04-19 17:00:00	SPY	ETF	131.56	131.84	131.51	131.75	474550.0
2011-04-19 18:00:00	SPY	ETF	131.76	131.82	131.69	131.69	89713.0
2011-04-19 19:00:00	SPY	ETF	131.7	131.81	131.7	131.79	67996.0
2011-04-19 06:00:00	QQQ	ETF	56.29	56.29	56.26	56.26	500.0
2011-04-19 07:00:00	QQQ	ETF	56.27	56.4	56.27	56.38	56710.0
2011-04-19 08:00:00	QQQ	ETF	56.34	56.45	56.33	56.4	290769.0
2011-04-19 09:00:00	QQQ	ETF	56.4	56.46	56.2313	56.3	4278888.0
2011-04-19 10:00:00	QQQ	ETF	56.3	56.41	56.17	56.21	5302245.0
2011-04-19 11:00:00	QQQ	ETF	56.21	56.27	56.1	56.19	3063128.0
2011-04-19 12:00:00	QQQ	ETF	56.191	56.27	56.14	56.23	1951513.0
2011-04-19 13:00:00	QQQ	ETF	56.22	56.47	56.22	56.41	4327799.0
2011-04-19 14:00:00	QQQ	ETF	56.41	56.46	56.33	56.43	2833838.0
2011-04-19 15:00:00	QQQ	ETF	56.4399	56.6	56.43	56.6	6255699.0
2011-04-19 16:00:00	QQQ	ETF	56.6	57.11	56.4933	56.97	5844143.0
2011-04-19 17:00:00	QQQ	ETF	56.96	57.11	56.93	56.99	228000.0
2011-04-19 18:00:00	QQQ	ETF	57.02	57.04	56.99	57.01	42466.0
2011-04-19 19:00:00	QQQ	ETF	57.01	57.06	57.0	57.04	44060.0
2011-04-19 04:00:00	IWM	ETF	82.03	82.03	81.95	81.97	1300.0
2011-04-19 05:00:00	IWM	ETF	82.04	82.24	82.04	82.24	5200.0
2011-04-19 06:00:00	IWM	ETF	82.23	82.23	82.23	82.23	100.0
2011-04-19 07:00:00	IWM	ETF	82.27	82.42	82.27	82.37	109900.0
2011-04-19 08:00:00	IWM	ETF	82.35	82.53	82.35	82.45	208074.0
2011-04-19 09:00:00	IWM	ETF	82.44	82.695	82.14	82.25	4654123.0
2011-04-19 10:00:00	IWM	ETF	82.26	82.35	81.92	81.9725	4256369.0
2011-04-19 11:00:00	IWM	ETF	81.96	81.98	81.68	81.848	3400548.0
2011-04-19 12:00:00	IWM	ETF	81.84	81.89	81.67	81.8	2827824.0
2011-04-19 13:00:00	IWM	ETF	81.81	82.21	81.81	82.11	3117970.0
2011-04-19 14:00:00	IWM	ETF	82.12	82.17	81.94	82.05	2561656.0
2011-04-19 15:00:00	IWM	ETF	82.05	82.24	82.04	82.15	6082946.0
2011-04-19 16:00:00	IWM	ETF	82.15	82.52	82.05	82.46	1380187.0
2011-04-19 17:00:00	IWM	ETF	82.47	82.62	82.44	82.55	50286.0
2011-04-19 18:00:00	IWM	ETF	82.54	82.54	82.47	82.48	2200.0
2011-04-19 19:00:00	IWM	ETF	82.48	82.52	82.48	82.52	16600.0
2011-04-19 04:00:00	DIA	ETF	121.56	121.56	121.56	121.56	600.0
2011-04-19 07:00:00	DIA	ETF	121.82	121.91	121.82	121.91	3100.0
2011-04-19 08:00:00	DIA	ETF	122.01	122.1	121.95	122.02	72700.0
2011-04-19 09:00:00	DIA	ETF	121.97	122.23	121.899	122.07	716977.0

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

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