PREVIEW / etf_1hour / 2011-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-31.parquet
  size:    186 KB
  rows:    5,784

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-31 04:00:00	SPY	ETF	121.84	122.28	121.8	122.2	21590.0
2011-08-31 05:00:00	SPY	ETF	122.16	122.35	122.01	122.08	188790.0
2011-08-31 06:00:00	SPY	ETF	122.08	122.23	121.99	122.02	115148.0
2011-08-31 07:00:00	SPY	ETF	122.02	122.29	121.98	122.08	825685.0
2011-08-31 08:00:00	SPY	ETF	122.08	122.42	121.87	122.38	3536167.0
2011-08-31 09:00:00	SPY	ETF	122.37	123.28	122.33	123.05	39140925.0
2011-08-31 10:00:00	SPY	ETF	123.06	123.51	122.82	122.86	46405812.0
2011-08-31 11:00:00	SPY	ETF	122.86	123.05	122.29	122.29	34987870.0
2011-08-31 12:00:00	SPY	ETF	122.29	123.04	122.28	123.0299	20748008.0
2011-08-31 13:00:00	SPY	ETF	123.03	123.12	122.26	122.3	18948290.0
2011-08-31 14:00:00	SPY	ETF	122.3	122.41	121.52	121.86	32713304.0
2011-08-31 15:00:00	SPY	ETF	121.86	122.66	121.3	122.26	67334973.0
2011-08-31 16:00:00	SPY	ETF	122.26	123.15	121.7	122.37	26485630.0
2011-08-31 17:00:00	SPY	ETF	122.37	122.37	121.7075	122.3	1531847.0
2011-08-31 18:00:00	SPY	ETF	122.3	122.41	122.06	122.35	262457.0
2011-08-31 19:00:00	SPY	ETF	122.37	122.38	122.25	122.3	88180.0
2011-08-31 04:00:00	QQQ	ETF	55.06	55.26	55.06	55.21	3106.0
2011-08-31 05:00:00	QQQ	ETF	55.2	55.27	55.19	55.21	2940.0
2011-08-31 06:00:00	QQQ	ETF	55.22	55.22	55.16	55.2	14900.0
2011-08-31 07:00:00	QQQ	ETF	55.2	55.25	55.17	55.19	40261.0
2011-08-31 08:00:00	QQQ	ETF	55.22	55.28	55.13	55.25	343116.0
2011-08-31 09:00:00	QQQ	ETF	55.28	55.58	55.14	55.48	11456528.0
2011-08-31 10:00:00	QQQ	ETF	55.48	55.74	55.44	55.48	10875948.0
2011-08-31 11:00:00	QQQ	ETF	55.4781	55.54	55.01	55.01	7471750.0
2011-08-31 12:00:00	QQQ	ETF	55.02	55.4	55.01	55.39	4363753.0
2011-08-31 13:00:00	QQQ	ETF	55.39	55.43	54.96	54.97	4436189.0
2011-08-31 14:00:00	QQQ	ETF	54.97	55.025	54.64	54.8048	5948073.0
2011-08-31 15:00:00	QQQ	ETF	54.8	55.18	54.6	55.09	12606942.0
2011-08-31 16:00:00	QQQ	ETF	55.1	55.22	55.02	55.17	2422654.0
2011-08-31 17:00:00	QQQ	ETF	55.17	55.17	55.12	55.13	11900.0
2011-08-31 18:00:00	QQQ	ETF	55.15	55.18	55.06	55.18	25268.0
2011-08-31 19:00:00	QQQ	ETF	55.16	55.18	55.13	55.18	20290.0
2011-08-31 04:00:00	IWM	ETF	72.88	73.2	72.82	73.2	4043.0
2011-08-31 05:00:00	IWM	ETF	73.19	73.19	73.12	73.12	300.0
2011-08-31 07:00:00	IWM	ETF	73.04	73.2	73.02	73.04	22029.0
2011-08-31 08:00:00	IWM	ETF	73.05	73.18	72.95	73.15	392494.0
2011-08-31 09:00:00	IWM	ETF	73.15	73.67	73.07	73.36	9229316.0
2011-08-31 10:00:00	IWM	ETF	73.37	73.89	73.23	73.31	12000631.0
2011-08-31 11:00:00	IWM	ETF	73.32	73.3501	72.56	72.56	7784327.0
2011-08-31 12:00:00	IWM	ETF	72.55	73.35	72.55	73.29	4049078.0
2011-08-31 13:00:00	IWM	ETF	73.29	73.36	72.58	72.64	3960816.0
2011-08-31 14:00:00	IWM	ETF	72.65	72.73	71.9	72.13	7109094.0
2011-08-31 15:00:00	IWM	ETF	72.13	72.85	71.91	72.62	17274889.0
2011-08-31 16:00:00	IWM	ETF	72.61	72.9283	72.58	72.85	5011113.0
2011-08-31 17:00:00	IWM	ETF	72.87	72.87	72.73	72.73	66593.0
2011-08-31 18:00:00	IWM	ETF	72.73	72.89	72.73	72.89	12572.0
2011-08-31 19:00:00	IWM	ETF	72.89	72.96	72.83	72.88	42635.0
2011-08-31 07:00:00	DIA	ETF	115.72	115.86	115.7	115.77	2575.0
2011-08-31 08:00:00	DIA	ETF	115.77	116.02	115.61	115.99	28100.0
2011-08-31 09:00:00	DIA	ETF	116.0	116.69	115.95	116.6	1214524.0

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

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