PREVIEW / etf_30min / 2011-08-23

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-23.parquet
  size:    298 KB
  rows:    9,816

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-23 04:00:00	SPY	ETF	114.5	115.1	114.5	114.72	10691.0
2011-08-23 04:30:00	SPY	ETF	114.72	114.75	114.49	114.58	4846.0
2011-08-23 05:00:00	SPY	ETF	114.52	114.59	114.3	114.54	2600.0
2011-08-23 05:30:00	SPY	ETF	114.8	114.8	114.53	114.65	1600.0
2011-08-23 06:00:00	SPY	ETF	114.69	114.7	114.31	114.31	124100.0
2011-08-23 06:30:00	SPY	ETF	114.43	114.68	114.31	114.36	116056.0
2011-08-23 07:00:00	SPY	ETF	114.41	114.72	114.38	114.67	315874.0
2011-08-23 07:30:00	SPY	ETF	114.62	114.62	113.83	113.9	822766.0
2011-08-23 08:00:00	SPY	ETF	113.88	114.68	113.73	114.06	2840812.0
2011-08-23 08:30:00	SPY	ETF	114.04	114.09	112.73	113.34	3771321.0
2011-08-23 09:00:00	SPY	ETF	113.34	113.63	112.73	113.14	4823502.0
2011-08-23 09:30:00	SPY	ETF	113.15	113.65	112.58	113.17	39340646.0
2011-08-23 10:00:00	SPY	ETF	113.18	114.38	113.11	114.15	35216715.0
2011-08-23 10:30:00	SPY	ETF	114.14	114.5	113.86	113.87	19532522.0
2011-08-23 11:00:00	SPY	ETF	113.87	114.27	113.75	114.255	14885463.0
2011-08-23 11:30:00	SPY	ETF	114.26	115.31	114.24	115.24	22410351.0
2011-08-23 12:00:00	SPY	ETF	115.24	115.25	114.84	114.95	12847239.0
2011-08-23 12:30:00	SPY	ETF	114.96	115.519	114.94	115.37	13166399.0
2011-08-23 13:00:00	SPY	ETF	115.37	115.59	115.05	115.16	10694554.0
2011-08-23 13:30:00	SPY	ETF	115.15	115.25	114.38	114.73	22475384.0
2011-08-23 14:00:00	SPY	ETF	114.73	115.1	114.36	115.06	20146069.0
2011-08-23 14:30:00	SPY	ETF	115.07	115.48	114.97	115.41	14838556.0
2011-08-23 15:00:00	SPY	ETF	115.42	116.44	115.41	115.89	27499030.0
2011-08-23 15:30:00	SPY	ETF	115.89	116.54	115.7	116.48	39285561.0
2011-08-23 16:00:00	SPY	ETF	116.48	116.61	116.0	116.49	13987562.0
2011-08-23 16:30:00	SPY	ETF	116.48	116.6	116.39	116.57	3694521.0
2011-08-23 17:00:00	SPY	ETF	116.57	116.69	112.7152	116.54	2284784.0
2011-08-23 17:30:00	SPY	ETF	116.55	116.61	112.7152	116.54	1019241.0
2011-08-23 18:00:00	SPY	ETF	116.54	116.54	116.36	116.37	741925.0
2011-08-23 18:30:00	SPY	ETF	116.35	116.35	116.28	116.28	82485.0
2011-08-23 19:00:00	SPY	ETF	116.3	116.32	116.07	116.18	158965.0
2011-08-23 19:30:00	SPY	ETF	116.17	116.31	116.14	116.16	114381.0
2011-08-23 04:00:00	QQQ	ETF	51.09	51.13	50.97	50.97	5082.0
2011-08-23 04:30:00	QQQ	ETF	51.04	51.05	50.93	50.93	1791.0
2011-08-23 06:00:00	QQQ	ETF	50.93	50.93	50.87	50.87	900.0
2011-08-23 07:00:00	QQQ	ETF	50.84	51.02	50.84	50.98	33000.0
2011-08-23 07:30:00	QQQ	ETF	50.95	50.97	50.67	50.69	130485.0
2011-08-23 08:00:00	QQQ	ETF	50.7	50.86	50.62	50.77	204180.0
2011-08-23 08:30:00	QQQ	ETF	50.77	50.77	50.46	50.52	256493.0
2011-08-23 09:00:00	QQQ	ETF	50.53	50.66	50.47	50.55	465159.0
2011-08-23 09:30:00	QQQ	ETF	50.56	50.94	50.34	50.79	10111761.0
2011-08-23 10:00:00	QQQ	ETF	50.78	51.22	50.74	51.14	8037566.0
2011-08-23 10:30:00	QQQ	ETF	51.13	51.285	50.99	51.0	4239243.0
2011-08-23 11:00:00	QQQ	ETF	51.0	51.12	50.89	51.12	3613546.0
2011-08-23 11:30:00	QQQ	ETF	51.12	51.58	51.11	51.55	4148684.0
2011-08-23 12:00:00	QQQ	ETF	51.55	51.57	51.4	51.464	2314674.0
2011-08-23 12:30:00	QQQ	ETF	51.46	51.74	51.46	51.661	3323548.0
2011-08-23 13:00:00	QQQ	ETF	51.67	51.79	51.55	51.6	2885365.0
2011-08-23 13:30:00	QQQ	ETF	51.6	51.67	51.27	51.44	5802087.0
2011-08-23 14:00:00	QQQ	ETF	51.45	51.65	51.3207	51.63	4449914.0

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

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