PREVIEW / etf_30min / 2011-09-07

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-07.parquet
  size:    284 KB
  rows:    9,427

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-07 04:00:00	SPY	ETF	117.79	118.43	117.79	118.03	8957.0
2011-09-07 04:30:00	SPY	ETF	118.16	118.32	118.08	118.13	21540.0
2011-09-07 05:00:00	SPY	ETF	118.29	118.3	117.91	117.96	28000.0
2011-09-07 05:30:00	SPY	ETF	117.94	117.94	117.94	117.94	300.0
2011-09-07 06:00:00	SPY	ETF	118.0	118.0	117.89	117.99	1550.0
2011-09-07 06:30:00	SPY	ETF	118.15	118.6	118.15	118.44	120840.0
2011-09-07 07:00:00	SPY	ETF	118.45	118.55	118.29	118.3	286073.0
2011-09-07 07:30:00	SPY	ETF	118.35	118.4	118.15	118.24	298076.0
2011-09-07 08:00:00	SPY	ETF	118.24	118.34	118.01	118.27	620260.0
2011-09-07 08:30:00	SPY	ETF	118.27	118.62	118.19	118.56	1171874.0
2011-09-07 09:00:00	SPY	ETF	118.56	118.85	118.53	118.75	3296769.0
2011-09-07 09:30:00	SPY	ETF	118.76	119.05	118.36	119.0	29345350.0
2011-09-07 10:00:00	SPY	ETF	118.99	119.19	118.81	118.82	19842824.0
2011-09-07 10:30:00	SPY	ETF	118.81	119.08	118.71	118.93	13512486.0
2011-09-07 11:00:00	SPY	ETF	118.93	119.48	118.8699	119.41	15356369.0
2011-09-07 11:30:00	SPY	ETF	119.415	119.48	119.24	119.37	7002260.0
2011-09-07 12:00:00	SPY	ETF	119.38	119.46	119.28	119.41	6640892.0
2011-09-07 12:30:00	SPY	ETF	119.41	119.7	119.4	119.57	9935492.0
2011-09-07 13:00:00	SPY	ETF	119.5691	119.86	119.5	119.79	7676410.0
2011-09-07 13:30:00	SPY	ETF	119.79	119.86	119.57	119.78	7771711.0
2011-09-07 14:00:00	SPY	ETF	119.78	120.13	119.71	120.11	13668294.0
2011-09-07 14:30:00	SPY	ETF	120.11	120.34	120.09	120.25	9379630.0
2011-09-07 15:00:00	SPY	ETF	120.25	120.28	119.96	120.07	12074851.0
2011-09-07 15:30:00	SPY	ETF	120.07	120.34	119.76	120.2899	31394631.0
2011-09-07 16:00:00	SPY	ETF	120.28	120.54	119.1114	120.47	11608165.0
2011-09-07 16:30:00	SPY	ETF	120.46	120.63	120.46	120.49	4428849.0
2011-09-07 17:00:00	SPY	ETF	120.48	120.6	120.42	120.59	173153.0
2011-09-07 17:30:00	SPY	ETF	120.59	120.62	120.55	120.55	71172.0
2011-09-07 18:00:00	SPY	ETF	120.55	120.63	120.51	120.6	52065.0
2011-09-07 18:30:00	SPY	ETF	120.57	120.75	120.27	120.7	197034.0
2011-09-07 19:00:00	SPY	ETF	120.68	120.75	120.61	120.61	47148.0
2011-09-07 19:30:00	SPY	ETF	120.63	120.72	120.61	120.71	31735.0
2011-09-07 04:00:00	QQQ	ETF	53.76	53.83	53.76	53.83	300.0
2011-09-07 04:30:00	QQQ	ETF	53.75	53.75	53.75	53.75	100.0
2011-09-07 05:00:00	QQQ	ETF	53.77	53.77	53.77	53.77	500.0
2011-09-07 06:00:00	QQQ	ETF	53.66	53.66	53.51	53.51	200.0
2011-09-07 06:30:00	QQQ	ETF	53.68	53.86	53.68	53.86	14900.0
2011-09-07 07:00:00	QQQ	ETF	53.87	53.87	53.73	53.76	20537.0
2011-09-07 07:30:00	QQQ	ETF	53.77	53.8	53.7	53.72	20750.0
2011-09-07 08:00:00	QQQ	ETF	53.74	53.81	53.66	53.79	127475.0
2011-09-07 08:30:00	QQQ	ETF	53.79	53.94	53.75	53.93	242426.0
2011-09-07 09:00:00	QQQ	ETF	53.93	54.04	53.91	54.02	561883.0
2011-09-07 09:30:00	QQQ	ETF	54.03	54.18	53.9	54.1	7428796.0
2011-09-07 10:00:00	QQQ	ETF	54.1	54.15	53.9	53.9893	4044096.0
2011-09-07 10:30:00	QQQ	ETF	53.98	54.08	53.92	53.989	2947257.0
2011-09-07 11:00:00	QQQ	ETF	53.98	54.2	53.94	54.17	3184109.0
2011-09-07 11:30:00	QQQ	ETF	54.1728	54.27	54.12	54.23	1398463.0
2011-09-07 12:00:00	QQQ	ETF	54.23	54.26	54.18	54.22	1369010.0
2011-09-07 12:30:00	QQQ	ETF	54.2215	54.32	54.2	54.26	1330436.0
2011-09-07 13:00:00	QQQ	ETF	54.26	54.44	54.24	54.41	2830421.0

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

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