PREVIEW / etf_30min / 2013-11-11

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-11.parquet
  size:    303 KB
  rows:    10,652

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-11-11 04:00:00	SPY	ETF	176.94	177.1	176.91	177.1	6285.0
2013-11-11 04:30:00	SPY	ETF	177.05	177.11	177.02	177.11	3900.0
2013-11-11 05:00:00	SPY	ETF	177.09	177.27	177.09	177.27	14960.0
2013-11-11 05:30:00	SPY	ETF	177.27	177.35	177.27	177.29	49050.0
2013-11-11 06:00:00	SPY	ETF	177.26	177.26	177.24	177.25	3000.0
2013-11-11 06:30:00	SPY	ETF	177.24	177.24	177.14	177.18	49098.0
2013-11-11 07:00:00	SPY	ETF	177.13	177.23	177.12	177.21	90910.0
2013-11-11 07:30:00	SPY	ETF	177.23	177.38	177.23	177.33	158397.0
2013-11-11 08:00:00	SPY	ETF	177.32	177.38	177.15	177.24	196514.0
2013-11-11 08:30:00	SPY	ETF	177.27	177.28	177.13	177.2	268971.0
2013-11-11 09:00:00	SPY	ETF	177.19	177.23	177.09	177.13	337878.0
2013-11-11 09:30:00	SPY	ETF	177.12	177.53	176.91	177.42	10639450.0
2013-11-11 10:00:00	SPY	ETF	177.42	177.5	177.21	177.24	4794217.0
2013-11-11 10:30:00	SPY	ETF	177.25	177.42	177.12	177.41	6391051.0
2013-11-11 11:00:00	SPY	ETF	177.41	177.43	177.12	177.28	5093632.0
2013-11-11 11:30:00	SPY	ETF	177.28	177.38	177.19	177.31	4201210.0
2013-11-11 12:00:00	SPY	ETF	177.31	177.31	177.21	177.275	1608418.0
2013-11-11 12:30:00	SPY	ETF	177.28	177.31	177.16	177.27	3600037.0
2013-11-11 13:00:00	SPY	ETF	177.27	177.38	177.22	177.28	2304068.0
2013-11-11 13:30:00	SPY	ETF	177.28	177.35	177.24	177.29	1626936.0
2013-11-11 14:00:00	SPY	ETF	177.295	177.32	177.23	177.275	2192957.0
2013-11-11 14:30:00	SPY	ETF	177.275	177.34	177.24	177.3	1967484.0
2013-11-11 15:00:00	SPY	ETF	177.3	177.36	177.27	177.34	2328853.0
2013-11-11 15:30:00	SPY	ETF	177.34	177.36	177.24	177.3	6727127.0
2013-11-11 16:00:00	SPY	ETF	177.29	177.3431	177.2141	177.27	6622708.0
2013-11-11 16:30:00	SPY	ETF	177.27	177.3	177.25	177.27	106476.0
2013-11-11 17:00:00	SPY	ETF	177.28	177.3	177.28	177.29	39205.0
2013-11-11 17:30:00	SPY	ETF	177.28	177.29	177.28	177.28	33160.0
2013-11-11 18:00:00	SPY	ETF	177.28	177.31	177.24	177.27	52283.0
2013-11-11 18:30:00	SPY	ETF	177.26	177.28	177.25	177.28	1800.0
2013-11-11 19:00:00	SPY	ETF	177.27	177.3	177.26	177.3	76600.0
2013-11-11 19:30:00	SPY	ETF	177.28	177.38	177.28	177.36	183339.0
2013-11-11 04:00:00	QQQ	ETF	82.37	82.43	82.37	82.43	6400.0
2013-11-11 04:30:00	QQQ	ETF	82.42	82.42	82.42	82.42	1000.0
2013-11-11 05:00:00	QQQ	ETF	82.44	82.5	82.44	82.5	4500.0
2013-11-11 05:30:00	QQQ	ETF	82.53	82.53	82.48	82.48	4500.0
2013-11-11 06:00:00	QQQ	ETF	82.5	82.5	82.48	82.48	3000.0
2013-11-11 06:30:00	QQQ	ETF	82.46	82.47	82.45	82.47	9900.0
2013-11-11 07:00:00	QQQ	ETF	82.46	82.47	82.45	82.46	5007.0
2013-11-11 07:30:00	QQQ	ETF	82.46	82.56	82.46	82.56	26700.0
2013-11-11 08:00:00	QQQ	ETF	82.55	82.56	82.45	82.51	209614.0
2013-11-11 08:30:00	QQQ	ETF	82.51	82.51	82.42	82.44	127800.0
2013-11-11 09:00:00	QQQ	ETF	82.44	82.44	82.38	82.39	219093.0
2013-11-11 09:30:00	QQQ	ETF	82.39	82.64	82.22	82.575	3380147.0
2013-11-11 10:00:00	QQQ	ETF	82.58	82.6	82.33	82.39	2320271.0
2013-11-11 10:30:00	QQQ	ETF	82.38	82.47	82.25	82.39	5046378.0
2013-11-11 11:00:00	QQQ	ETF	82.39	82.39	82.14	82.34	3892187.0
2013-11-11 11:30:00	QQQ	ETF	82.34	82.47	82.305	82.45	726951.0
2013-11-11 12:00:00	QQQ	ETF	82.45	82.45	82.37	82.42	483728.0
2013-11-11 12:30:00	QQQ	ETF	82.405	82.5	82.37	82.48	669836.0

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

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