PREVIEW / etf_30min / 2011-09-22

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-22.parquet
  size:    318 KB
  rows:    10,810

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-22 04:00:00	SPY	ETF	115.27	115.27	114.46	114.54	60808.0
2011-09-22 04:30:00	SPY	ETF	114.48	114.59	114.27	114.5	13450.0
2011-09-22 05:00:00	SPY	ETF	114.48	114.48	114.05	114.17	35712.0
2011-09-22 05:30:00	SPY	ETF	114.24	114.49	114.15	114.23	31450.0
2011-09-22 06:00:00	SPY	ETF	114.25	114.3	113.95	114.0	113517.0
2011-09-22 06:30:00	SPY	ETF	114.0	114.02	113.3	113.4	313762.0
2011-09-22 07:00:00	SPY	ETF	113.45	113.6	113.18	113.53	671494.0
2011-09-22 07:30:00	SPY	ETF	113.5	113.76	113.35	113.73	1033389.0
2011-09-22 08:00:00	SPY	ETF	113.71	115.54	113.36	113.46	3386022.0
2011-09-22 08:30:00	SPY	ETF	113.42	113.67	112.65	112.96	5398158.0
2011-09-22 09:00:00	SPY	ETF	112.94	114.0	112.92	113.24	6497762.0
2011-09-22 09:30:00	SPY	ETF	113.25	113.89	112.665	112.73	49025553.0
2011-09-22 10:00:00	SPY	ETF	112.75	114.21	112.7	113.65	43555632.0
2011-09-22 10:30:00	SPY	ETF	113.65	114.09	113.25	113.3	27724016.0
2011-09-22 11:00:00	SPY	ETF	113.3085	113.55	112.9	113.04	26970317.0
2011-09-22 11:30:00	SPY	ETF	113.03	113.51	112.77	112.77	23952135.0
2011-09-22 12:00:00	SPY	ETF	112.77	112.92	112.37	112.7	22987764.0
2011-09-22 12:30:00	SPY	ETF	112.7	113.44	112.6275	113.36	20797975.0
2011-09-22 13:00:00	SPY	ETF	113.36	113.42	112.4	112.6	21087447.0
2011-09-22 13:30:00	SPY	ETF	112.61	112.8	111.8	111.82	24714645.0
2011-09-22 14:00:00	SPY	ETF	111.82	113.29	111.67	112.82	46800022.0
2011-09-22 14:30:00	SPY	ETF	112.81	112.91	112.0	112.01	28260274.0
2011-09-22 15:00:00	SPY	ETF	112.01	112.25	111.3	111.79	32775379.0
2011-09-22 15:30:00	SPY	ETF	111.79	113.55	111.67	112.9	68676386.0
2011-09-22 16:00:00	SPY	ETF	112.89	114.2	112.692	112.99	18460979.0
2011-09-22 16:30:00	SPY	ETF	112.99	116.601	112.75	113.38	18286933.0
2011-09-22 17:00:00	SPY	ETF	113.39	116.601	113.22	113.49	13719407.0
2011-09-22 17:30:00	SPY	ETF	113.48	113.5	112.8837	113.5	2595361.0
2011-09-22 18:00:00	SPY	ETF	113.5	113.65	112.8	113.54	492930.0
2011-09-22 18:30:00	SPY	ETF	113.55	113.62	113.3	113.3	210434.0
2011-09-22 19:00:00	SPY	ETF	113.38	113.5	113.15	113.2	130820.0
2011-09-22 19:30:00	SPY	ETF	113.19	113.75	113.16	113.66	163691.0
2011-09-22 04:00:00	QQQ	ETF	55.0	55.0	54.57	54.57	6990.0
2011-09-22 04:30:00	QQQ	ETF	54.48	54.58	54.48	54.58	200.0
2011-09-22 05:00:00	QQQ	ETF	54.42	54.42	54.33	54.35	4815.0
2011-09-22 05:30:00	QQQ	ETF	54.42	54.5	54.34	54.35	24200.0
2011-09-22 06:00:00	QQQ	ETF	54.26	54.35	54.25	54.26	8900.0
2011-09-22 06:30:00	QQQ	ETF	54.21	54.21	53.8	53.83	42750.0
2011-09-22 07:00:00	QQQ	ETF	53.91	54.0	53.77	54.0	64579.0
2011-09-22 07:30:00	QQQ	ETF	53.99	54.18	53.94	54.11	173665.0
2011-09-22 08:00:00	QQQ	ETF	54.15	54.21	53.88	54.06	533207.0
2011-09-22 08:30:00	QQQ	ETF	54.05	54.18	53.74	53.87	1128178.0
2011-09-22 09:00:00	QQQ	ETF	53.86	54.05	53.83	53.9	1359120.0
2011-09-22 09:30:00	QQQ	ETF	53.93	54.22	53.5	53.6	13107155.0
2011-09-22 10:00:00	QQQ	ETF	53.61	54.37	53.58	54.1493	13238623.0
2011-09-22 10:30:00	QQQ	ETF	54.14	54.46	54.02	54.025	8339442.0
2011-09-22 11:00:00	QQQ	ETF	54.02	54.13	53.81	53.87	7915402.0
2011-09-22 11:30:00	QQQ	ETF	53.87	54.15	53.75	53.7599	4555734.0
2011-09-22 12:00:00	QQQ	ETF	53.75	53.8208	53.51	53.7	5498109.0
2011-09-22 12:30:00	QQQ	ETF	53.7	54.05	53.68	53.97	3348961.0

> showing 50 of 10,810 rows — these rows as CSV

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