PREVIEW / etf_30min / 2013-10-22

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-22.parquet
  size:    339 KB
  rows:    11,395

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
2013-10-22 04:00:00	SPY	ETF	174.27	174.31	174.26	174.28	1038.0
2013-10-22 04:30:00	SPY	ETF	174.26	174.28	174.2	174.27	2262.0
2013-10-22 05:00:00	SPY	ETF	174.26	174.26	174.24	174.24	500.0
2013-10-22 05:30:00	SPY	ETF	174.25	174.25	174.21	174.21	10663.0
2013-10-22 06:00:00	SPY	ETF	174.24	174.26	174.2	174.23	17587.0
2013-10-22 06:30:00	SPY	ETF	174.22	174.24	174.18	174.24	8200.0
2013-10-22 07:00:00	SPY	ETF	174.23	174.34	174.21	174.34	64557.0
2013-10-22 07:30:00	SPY	ETF	174.34	174.4	174.28	174.3	50818.0
2013-10-22 08:00:00	SPY	ETF	174.31	174.68	174.3	174.57	248806.0
2013-10-22 08:30:00	SPY	ETF	174.56	175.0	174.32	174.78	2060541.0
2013-10-22 09:00:00	SPY	ETF	174.78	174.96	174.78	174.91	560230.0
2013-10-22 09:30:00	SPY	ETF	174.91	175.46	174.85	175.39	13276273.0
2013-10-22 10:00:00	SPY	ETF	175.39	175.93	175.35	175.71	15161790.0
2013-10-22 10:30:00	SPY	ETF	175.7	175.73	174.66	175.06	15685835.0
2013-10-22 11:00:00	SPY	ETF	175.05	175.23	174.81	174.95	9599236.0
2013-10-22 11:30:00	SPY	ETF	174.95	175.36	174.81	175.36	7223257.0
2013-10-22 12:00:00	SPY	ETF	175.36	175.39	175.06	175.12	4216136.0
2013-10-22 12:30:00	SPY	ETF	175.12	175.17	174.94	175.11	3688405.0
2013-10-22 13:00:00	SPY	ETF	175.1	175.26	175.04	175.17	3168455.0
2013-10-22 13:30:00	SPY	ETF	175.17	175.44	175.098	175.379	6499035.0
2013-10-22 14:00:00	SPY	ETF	175.3794	175.52	175.15	175.23	6346786.0
2013-10-22 14:30:00	SPY	ETF	175.24	175.64	175.19	175.48	7167737.0
2013-10-22 15:00:00	SPY	ETF	175.48	175.81	175.475	175.66	7206589.0
2013-10-22 15:30:00	SPY	ETF	175.67	175.68	175.34	175.43	13792740.0
2013-10-22 16:00:00	SPY	ETF	175.41	175.5	174.4262	175.43	4604523.0
2013-10-22 16:30:00	SPY	ETF	175.42	175.47	175.36	175.46	643879.0
2013-10-22 17:00:00	SPY	ETF	175.46	175.5	175.42	175.46	19788.0
2013-10-22 17:30:00	SPY	ETF	175.47	175.48	175.43	175.45	20535.0
2013-10-22 18:00:00	SPY	ETF	175.42	175.42	175.24	175.3	100263.0
2013-10-22 18:30:00	SPY	ETF	175.29	175.29	175.27	175.27	12274.0
2013-10-22 19:00:00	SPY	ETF	175.3	175.33	175.29	175.32	6009.0
2013-10-22 19:30:00	SPY	ETF	175.32	175.34	175.32	175.32	8050.0
2013-10-22 04:00:00	QQQ	ETF	82.37	82.37	82.36	82.36	1400.0
2013-10-22 04:30:00	QQQ	ETF	82.35	82.37	82.35	82.37	2200.0
2013-10-22 05:00:00	QQQ	ETF	82.36	82.36	82.35	82.36	25500.0
2013-10-22 05:30:00	QQQ	ETF	82.36	82.36	82.36	82.36	16000.0
2013-10-22 06:00:00	QQQ	ETF	82.37	82.37	82.37	82.37	900.0
2013-10-22 06:30:00	QQQ	ETF	82.36	82.36	82.36	82.36	200.0
2013-10-22 07:00:00	QQQ	ETF	82.37	82.38	82.36	82.37	21800.0
2013-10-22 07:30:00	QQQ	ETF	82.38	82.42	82.35	82.35	14900.0
2013-10-22 08:00:00	QQQ	ETF	82.35	82.55	82.35	82.53	61915.0
2013-10-22 08:30:00	QQQ	ETF	82.51	82.69	82.4	82.6	223772.0
2013-10-22 09:00:00	QQQ	ETF	82.61	82.66	82.61	82.61	163858.0
2013-10-22 09:30:00	QQQ	ETF	82.61	82.77	82.59	82.6799	4676850.0
2013-10-22 10:00:00	QQQ	ETF	82.6799	82.9	82.63	82.78	4431966.0
2013-10-22 10:30:00	QQQ	ETF	82.78	82.79	81.93	82.27	8099972.0
2013-10-22 11:00:00	QQQ	ETF	82.27	82.41	82.079	82.21	4941803.0
2013-10-22 11:30:00	QQQ	ETF	82.2	82.54	82.07	82.52	2075633.0
2013-10-22 12:00:00	QQQ	ETF	82.53	82.5501	82.33	82.38	1421715.0
2013-10-22 12:30:00	QQQ	ETF	82.37	82.37	82.185	82.3	1288140.0

> showing 50 of 11,395 rows — these rows as CSV

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