PREVIEW / etf_1hour / 2011-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-05.parquet
  size:    186 KB
  rows:    5,699

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-05-05 04:00:00	SPY	ETF	135.08	135.19	134.79	134.79	3900.0
2011-05-05 05:00:00	SPY	ETF	134.82	134.9	134.54	134.55	25000.0
2011-05-05 06:00:00	SPY	ETF	134.55	134.57	134.01	134.2	220030.0
2011-05-05 07:00:00	SPY	ETF	134.25	134.35	134.11	134.31	686181.0
2011-05-05 08:00:00	SPY	ETF	134.33	134.34	133.76	133.98	4092890.0
2011-05-05 09:00:00	SPY	ETF	133.98	134.35	133.68	134.24	21401206.0
2011-05-05 10:00:00	SPY	ETF	134.25	134.5	133.95	134.16	25168503.0
2011-05-05 11:00:00	SPY	ETF	134.17	134.7	133.69	134.62	31761818.0
2011-05-05 12:00:00	SPY	ETF	134.62	134.95	134.51	134.6	16145994.0
2011-05-05 13:00:00	SPY	ETF	134.6	134.8	134.35	134.51	11371087.0
2011-05-05 14:00:00	SPY	ETF	134.51	134.75	134.17	134.19	13503655.0
2011-05-05 15:00:00	SPY	ETF	134.18	134.22	133.02	133.64	74419351.0
2011-05-05 16:00:00	SPY	ETF	133.65	134.8639	133.638	133.98	25946344.0
2011-05-05 17:00:00	SPY	ETF	133.99	134.1	133.94	134.06	172833.0
2011-05-05 18:00:00	SPY	ETF	134.06	134.17	133.63	134.03	177405.0
2011-05-05 19:00:00	SPY	ETF	134.04	134.06	133.77	133.88	141633.0
2011-05-05 06:00:00	QQQ	ETF	58.4	58.4	58.33	58.39	1500.0
2011-05-05 07:00:00	QQQ	ETF	58.39	58.44	58.33	58.43	75450.0
2011-05-05 08:00:00	QQQ	ETF	58.42	58.46	58.21	58.31	607749.0
2011-05-05 09:00:00	QQQ	ETF	58.31	58.61	58.15	58.575	8360711.0
2011-05-05 10:00:00	QQQ	ETF	58.5726	58.73	58.43	58.59	9266780.0
2011-05-05 11:00:00	QQQ	ETF	58.58	58.84	58.355	58.81	11541871.0
2011-05-05 12:00:00	QQQ	ETF	58.81	58.97	58.655	58.729	7322269.0
2011-05-05 13:00:00	QQQ	ETF	58.73	58.84	58.66	58.78	2716298.0
2011-05-05 14:00:00	QQQ	ETF	58.78	58.88	58.54	58.55	6508337.0
2011-05-05 15:00:00	QQQ	ETF	58.55	58.58	58.08	58.28	15495343.0
2011-05-05 16:00:00	QQQ	ETF	58.29	58.5	58.27	58.44	2522708.0
2011-05-05 17:00:00	QQQ	ETF	58.43	58.47	58.42	58.42	38131.0
2011-05-05 18:00:00	QQQ	ETF	58.45	58.5	58.3	58.44	188185.0
2011-05-05 19:00:00	QQQ	ETF	58.42	58.42	58.33	58.33	31300.0
2011-05-05 04:00:00	IWM	ETF	83.4	83.54	83.4	83.54	400.0
2011-05-05 05:00:00	IWM	ETF	83.13	83.13	83.13	83.13	300.0
2011-05-05 06:00:00	IWM	ETF	83.07	83.07	82.88	82.88	10300.0
2011-05-05 07:00:00	IWM	ETF	82.95	83.0	82.94	83.0	22500.0
2011-05-05 08:00:00	IWM	ETF	82.98	83.01	82.53	82.64	870311.0
2011-05-05 09:00:00	IWM	ETF	82.64	82.93	82.4	82.77	9489485.0
2011-05-05 10:00:00	IWM	ETF	82.77	83.25	82.69	83.07	11661624.0
2011-05-05 11:00:00	IWM	ETF	83.06	83.73	82.73	83.65	10855151.0
2011-05-05 12:00:00	IWM	ETF	83.65	84.08	83.34	83.44	9117495.0
2011-05-05 13:00:00	IWM	ETF	83.44	83.69	83.37	83.61	5117169.0
2011-05-05 14:00:00	IWM	ETF	83.61	83.97	83.39	83.54	5381632.0
2011-05-05 15:00:00	IWM	ETF	83.538	83.5507	82.41	82.8	23175543.0
2011-05-05 16:00:00	IWM	ETF	82.81	83.09	82.79	83.03	1551747.0
2011-05-05 17:00:00	IWM	ETF	83.04	83.2143	83.02	83.04	524906.0
2011-05-05 18:00:00	IWM	ETF	83.09	83.11	83.02	83.04	10349.0
2011-05-05 19:00:00	IWM	ETF	83.08	83.08	82.89	82.91	6095.0
2011-05-05 04:00:00	DIA	ETF	127.13	127.13	127.13	127.13	1400.0
2011-05-05 05:00:00	DIA	ETF	126.9	126.9	126.84	126.85	3400.0
2011-05-05 06:00:00	DIA	ETF	126.72	126.72	126.6	126.6	3800.0
2011-05-05 07:00:00	DIA	ETF	126.65	126.69	126.54	126.63	13200.0

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

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