PREVIEW / etf_30min / 2011-11-23

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-23.parquet
  size:    290 KB
  rows:    9,780

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-11-23 04:00:00	SPY	ETF	118.19	118.29	117.77	118.29	160666.0
2011-11-23 04:30:00	SPY	ETF	118.25	118.3	118.01	118.01	3387.0
2011-11-23 05:00:00	SPY	ETF	118.27	118.31	117.38	117.52	46709.0
2011-11-23 05:30:00	SPY	ETF	117.45	117.87	117.37	117.87	35449.0
2011-11-23 06:00:00	SPY	ETF	117.84	118.19	117.77	118.08	15227.0
2011-11-23 06:30:00	SPY	ETF	118.19	118.39	118.04	118.1	138156.0
2011-11-23 07:00:00	SPY	ETF	118.07	118.14	117.67	117.8	333219.0
2011-11-23 07:30:00	SPY	ETF	117.78	118.04	117.73	117.87	346700.0
2011-11-23 08:00:00	SPY	ETF	117.9	118.42	117.55	117.8	1963692.0
2011-11-23 08:30:00	SPY	ETF	117.85	118.15	117.63	117.78	2015584.0
2011-11-23 09:00:00	SPY	ETF	117.8	118.24	117.76	118.06	1982253.0
2011-11-23 09:30:00	SPY	ETF	118.07	118.21	117.41	117.43	24882044.0
2011-11-23 10:00:00	SPY	ETF	117.43	117.58	117.08	117.18	21667353.0
2011-11-23 10:30:00	SPY	ETF	117.18	117.425	117.0	117.3	13144208.0
2011-11-23 11:00:00	SPY	ETF	117.3001	117.45	116.86	116.8765	15984740.0
2011-11-23 11:30:00	SPY	ETF	116.88	117.2	116.71	117.06	12643514.0
2011-11-23 12:00:00	SPY	ETF	117.05	117.34	117.05	117.05	9230665.0
2011-11-23 12:30:00	SPY	ETF	117.05	117.55	116.93	117.45	11060884.0
2011-11-23 13:00:00	SPY	ETF	117.45	117.525	117.23	117.465	8014070.0
2011-11-23 13:30:00	SPY	ETF	117.47	119.19	116.99	117.08	9193762.0
2011-11-23 14:00:00	SPY	ETF	117.08	117.15	116.69	116.8503	13235487.0
2011-11-23 14:30:00	SPY	ETF	116.856	117.1	116.84	116.93	7865456.0
2011-11-23 15:00:00	SPY	ETF	116.92	117.43	116.79	117.07	20193253.0
2011-11-23 15:30:00	SPY	ETF	117.07	117.58	116.56	116.63	29751245.0
2011-11-23 16:00:00	SPY	ETF	116.65	117.9	116.44	116.58	12933012.0
2011-11-23 16:30:00	SPY	ETF	116.59	119.19	116.47	116.56	2799651.0
2011-11-23 17:00:00	SPY	ETF	116.55	119.19	116.51	116.56	2115859.0
2011-11-23 17:30:00	SPY	ETF	116.56	116.59	116.52	116.59	30613.0
2011-11-23 18:00:00	SPY	ETF	116.6	116.7	116.56	116.62	389839.0
2011-11-23 18:30:00	SPY	ETF	116.6	116.67	116.55	116.67	19375.0
2011-11-23 19:00:00	SPY	ETF	116.69	116.82	116.61	116.74	88575.0
2011-11-23 19:30:00	SPY	ETF	116.75	116.81	116.7	116.76	103563.0
2011-11-23 04:00:00	QQQ	ETF	54.23	54.23	54.01	54.17	5200.0
2011-11-23 04:30:00	QQQ	ETF	54.22	54.22	54.22	54.22	200.0
2011-11-23 05:00:00	QQQ	ETF	54.15	54.15	53.93	53.93	2200.0
2011-11-23 05:30:00	QQQ	ETF	53.92	54.07	53.92	53.96	400.0
2011-11-23 06:00:00	QQQ	ETF	54.05	54.18	54.05	54.18	18330.0
2011-11-23 06:30:00	QQQ	ETF	54.23	54.23	54.17	54.19	7585.0
2011-11-23 07:00:00	QQQ	ETF	54.13	54.15	54.0	54.0	26677.0
2011-11-23 07:30:00	QQQ	ETF	54.05	54.1	54.03	54.03	6825.0
2011-11-23 08:00:00	QQQ	ETF	54.06	54.09	53.97	54.02	160725.0
2011-11-23 08:30:00	QQQ	ETF	54.0	54.16	53.96	54.04	212632.0
2011-11-23 09:00:00	QQQ	ETF	54.03	54.23	54.0	54.11	621613.0
2011-11-23 09:30:00	QQQ	ETF	54.11	54.17	53.73	53.73	5976380.0
2011-11-23 10:00:00	QQQ	ETF	53.73	53.8	53.5	53.54	5946566.0
2011-11-23 10:30:00	QQQ	ETF	53.55	53.67	53.42	53.63	3325067.0
2011-11-23 11:00:00	QQQ	ETF	53.62	53.69	53.39	53.4784	2640957.0
2011-11-23 11:30:00	QQQ	ETF	53.475	53.595	53.41	53.502	2682567.0
2011-11-23 12:00:00	QQQ	ETF	53.5	53.65	53.5	53.51	1148691.0
2011-11-23 12:30:00	QQQ	ETF	53.52	53.7	53.45	53.66	1519872.0

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

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