PREVIEW / etf_30min / 2013-10-03

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-03.parquet
  size:    329 KB
  rows:    10,830

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-03 04:00:00	SPY	ETF	168.47	168.61	168.46	168.46	52544.0
2013-10-03 04:30:00	SPY	ETF	168.48	168.48	168.34	168.46	3202.0
2013-10-03 05:00:00	SPY	ETF	168.46	168.54	168.42	168.5	12700.0
2013-10-03 05:30:00	SPY	ETF	168.48	168.48	168.22	168.24	3803.0
2013-10-03 06:00:00	SPY	ETF	168.24	168.29	168.24	168.28	23620.0
2013-10-03 06:30:00	SPY	ETF	168.3	168.39	168.26	168.37	50957.0
2013-10-03 07:00:00	SPY	ETF	168.36	168.46	168.31	168.45	137354.0
2013-10-03 07:30:00	SPY	ETF	168.45	168.57	168.4	168.53	78062.0
2013-10-03 08:00:00	SPY	ETF	168.5	168.56	168.31	168.52	288381.0
2013-10-03 08:30:00	SPY	ETF	168.52	168.87	168.49	168.82	794947.0
2013-10-03 09:00:00	SPY	ETF	168.81	168.89	168.75	168.79	454045.0
2013-10-03 09:30:00	SPY	ETF	168.79	168.94	168.25	168.35	13150941.0
2013-10-03 10:00:00	SPY	ETF	168.35	168.35	167.66	167.86	12873298.0
2013-10-03 10:30:00	SPY	ETF	167.86	167.9	167.53	167.77	11740909.0
2013-10-03 11:00:00	SPY	ETF	167.76	167.93	167.5	167.51	8004510.0
2013-10-03 11:30:00	SPY	ETF	167.51	167.7548	166.89	166.99	16099274.0
2013-10-03 12:00:00	SPY	ETF	166.99	167.2	166.84	167.18	11824292.0
2013-10-03 12:30:00	SPY	ETF	167.18	167.64	167.07	167.59	15126878.0
2013-10-03 13:00:00	SPY	ETF	167.6	168.09	167.465	168.09	12198008.0
2013-10-03 13:30:00	SPY	ETF	168.08	168.24	167.6624	168.18	10079527.0
2013-10-03 14:00:00	SPY	ETF	168.18	168.18	167.35	167.94	13448901.0
2013-10-03 14:30:00	SPY	ETF	167.94	168.115	167.645	167.87	7975415.0
2013-10-03 15:00:00	SPY	ETF	167.8799	168.04	167.74	168.02	7671876.0
2013-10-03 15:30:00	SPY	ETF	168.01	168.06	167.56	167.67	15320595.0
2013-10-03 16:00:00	SPY	ETF	167.67	169.2295	167.33	167.33	9105235.0
2013-10-03 16:30:00	SPY	ETF	167.34	167.38	167.27	167.285	1873485.0
2013-10-03 17:00:00	SPY	ETF	167.285	167.7261	167.28	167.7261	1182660.0
2013-10-03 17:30:00	SPY	ETF	167.32	167.37	167.32	167.33	46250.0
2013-10-03 18:00:00	SPY	ETF	167.35	167.55	167.33	167.46	106376.0
2013-10-03 18:30:00	SPY	ETF	167.46	167.47	167.42	167.44	8096.0
2013-10-03 19:00:00	SPY	ETF	167.48	167.5	167.44	167.46	5470.0
2013-10-03 19:30:00	SPY	ETF	167.46	167.5	167.43	167.46	14955.0
2013-10-03 04:00:00	QQQ	ETF	79.45	79.45	79.39	79.39	14400.0
2013-10-03 04:30:00	QQQ	ETF	79.4	79.4	79.34	79.4	7800.0
2013-10-03 05:00:00	QQQ	ETF	79.41	79.45	79.39	79.43	21100.0
2013-10-03 05:30:00	QQQ	ETF	79.42	79.42	79.3	79.3	13000.0
2013-10-03 06:00:00	QQQ	ETF	79.31	79.32	79.3	79.32	2600.0
2013-10-03 06:30:00	QQQ	ETF	79.33	79.36	79.32	79.36	53100.0
2013-10-03 07:00:00	QQQ	ETF	79.35	79.41	79.35	79.4	12750.0
2013-10-03 07:30:00	QQQ	ETF	79.39	79.45	79.38	79.41	12390.0
2013-10-03 08:00:00	QQQ	ETF	79.4	79.42	79.35	79.41	89010.0
2013-10-03 08:30:00	QQQ	ETF	79.41	79.59	79.41	79.58	84475.0
2013-10-03 09:00:00	QQQ	ETF	79.57	79.6	79.52	79.54	145233.0
2013-10-03 09:30:00	QQQ	ETF	79.54	79.72	79.31	79.39	3193704.0
2013-10-03 10:00:00	QQQ	ETF	79.39	79.39	78.91	78.99	3392486.0
2013-10-03 10:30:00	QQQ	ETF	78.98	79.06	78.8	78.9996	2727772.0
2013-10-03 11:00:00	QQQ	ETF	78.99	79.11	78.85	78.86	1528401.0
2013-10-03 11:30:00	QQQ	ETF	78.85	78.96	78.32	78.37	4420582.0
2013-10-03 12:00:00	QQQ	ETF	78.36	78.515	78.3	78.5	1802467.0
2013-10-03 12:30:00	QQQ	ETF	78.4901	78.68	78.36	78.6499	2832839.0

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

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