PREVIEW / etf_30min / 2011-09-26

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-26.parquet
  size:    292 KB
  rows:    9,790

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-09-26 04:00:00	SPY	ETF	113.6	114.21	113.25	114.06	18691.0
2011-09-26 04:30:00	SPY	ETF	113.89	114.55	113.83	114.55	8100.0
2011-09-26 05:00:00	SPY	ETF	114.46	114.8	114.46	114.59	22765.0
2011-09-26 05:30:00	SPY	ETF	114.55	114.61	114.33	114.46	14200.0
2011-09-26 06:00:00	SPY	ETF	114.36	114.74	114.28	114.74	111428.0
2011-09-26 06:30:00	SPY	ETF	114.81	115.09	114.63	114.86	102205.0
2011-09-26 07:00:00	SPY	ETF	114.89	115.69	114.88	115.43	654002.0
2011-09-26 07:30:00	SPY	ETF	115.45	115.59	115.06	115.1	595359.0
2011-09-26 08:00:00	SPY	ETF	115.5	115.5	113.26	115.15	1373507.0
2011-09-26 08:30:00	SPY	ETF	115.16	115.2	114.77	114.98	1428344.0
2011-09-26 09:00:00	SPY	ETF	114.98	115.16	114.43	114.62	2069363.0
2011-09-26 09:30:00	SPY	ETF	114.61	114.86	113.71	113.73	25235754.0
2011-09-26 10:00:00	SPY	ETF	113.73	113.94	113.02	113.74	22082534.0
2011-09-26 10:30:00	SPY	ETF	113.72	114.05	112.98	113.91	23487611.0
2011-09-26 11:00:00	SPY	ETF	113.91	114.58	113.81	114.54	15561726.0
2011-09-26 11:30:00	SPY	ETF	114.54	115.07	113.3515	114.97	14498280.0
2011-09-26 12:00:00	SPY	ETF	114.97	115.0	114.46	114.65	13703530.0
2011-09-26 12:30:00	SPY	ETF	114.64	114.79	114.04	114.3201	14820989.0
2011-09-26 13:00:00	SPY	ETF	114.32	114.325	113.72	114.02	15643264.0
2011-09-26 13:30:00	SPY	ETF	114.02	114.28	113.76	114.21	10858980.0
2011-09-26 14:00:00	SPY	ETF	114.21	114.84	114.09	114.48	16905850.0
2011-09-26 14:30:00	SPY	ETF	114.4899	115.04	114.33	114.98	13030559.0
2011-09-26 15:00:00	SPY	ETF	114.99	115.56	114.96	115.53	18196561.0
2011-09-26 15:30:00	SPY	ETF	115.53	116.4	115.35	116.21	32008204.0
2011-09-26 16:00:00	SPY	ETF	116.2	116.48	113.3515	116.32	13275766.0
2011-09-26 16:30:00	SPY	ETF	116.33	116.47	116.31	116.43	557116.0
2011-09-26 17:00:00	SPY	ETF	116.43	116.43	116.28	116.36	179656.0
2011-09-26 17:30:00	SPY	ETF	116.37	116.41	116.231	116.34	826577.0
2011-09-26 18:00:00	SPY	ETF	116.34	116.37	116.25	116.37	107824.0
2011-09-26 18:30:00	SPY	ETF	116.35	116.39	116.29	116.32	26471.0
2011-09-26 19:00:00	SPY	ETF	116.33	116.37	116.28	116.29	28313.0
2011-09-26 19:30:00	SPY	ETF	116.29	116.32	116.14	116.16	196942.0
2011-09-26 04:00:00	QQQ	ETF	53.91	53.91	53.91	53.91	439.0
2011-09-26 05:00:00	QQQ	ETF	54.41	54.5	54.41	54.5	889.0
2011-09-26 06:00:00	QQQ	ETF	54.45	54.45	54.45	54.45	200.0
2011-09-26 06:30:00	QQQ	ETF	54.55	54.7	54.55	54.65	32175.0
2011-09-26 07:00:00	QQQ	ETF	54.71	54.92	54.66	54.85	346448.0
2011-09-26 07:30:00	QQQ	ETF	54.85	54.93	54.66	54.66	388515.0
2011-09-26 08:00:00	QQQ	ETF	54.68	54.75	54.51	54.65	396760.0
2011-09-26 08:30:00	QQQ	ETF	54.67	54.67	54.53	54.62	264616.0
2011-09-26 09:00:00	QQQ	ETF	54.62	54.72	54.27	54.42	716016.0
2011-09-26 09:30:00	QQQ	ETF	54.41	54.51	53.75	53.7699	9652822.0
2011-09-26 10:00:00	QQQ	ETF	53.76	53.86	53.28	53.61	12510265.0
2011-09-26 10:30:00	QQQ	ETF	53.6	53.847	53.21	53.8	8629084.0
2011-09-26 11:00:00	QQQ	ETF	53.8	54.15	53.72	54.13	5628182.0
2011-09-26 11:30:00	QQQ	ETF	54.14	54.4398	53.99	54.3501	5704593.0
2011-09-26 12:00:00	QQQ	ETF	54.36	54.38	54.04	54.09	4305667.0
2011-09-26 12:30:00	QQQ	ETF	54.1	54.18	53.73	53.8401	4708664.0
2011-09-26 13:00:00	QQQ	ETF	53.8499	53.85	53.53	53.71	3983408.0
2011-09-26 13:30:00	QQQ	ETF	53.71	53.83	53.5	53.71	5173641.0

> showing 50 of 9,790 rows — these rows as CSV

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