PREVIEW / etf_30min / 2013-10-16

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-16.parquet
  size:    331 KB
  rows:    11,163

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-16 04:00:00	SPY	ETF	170.4	170.45	170.3	170.35	18878.0
2013-10-16 04:30:00	SPY	ETF	170.35	170.49	170.35	170.43	11246.0
2013-10-16 05:00:00	SPY	ETF	170.41	170.51	170.41	170.45	14984.0
2013-10-16 05:30:00	SPY	ETF	170.45	170.45	170.34	170.42	20581.0
2013-10-16 06:00:00	SPY	ETF	170.37	170.39	170.24	170.36	34066.0
2013-10-16 06:30:00	SPY	ETF	170.35	170.35	170.2	170.33	18118.0
2013-10-16 07:00:00	SPY	ETF	170.31	170.49	170.3	170.43	167278.0
2013-10-16 07:30:00	SPY	ETF	170.42	170.42	170.27	170.3	149447.0
2013-10-16 08:00:00	SPY	ETF	170.3	170.69	170.3	170.65	488256.0
2013-10-16 08:30:00	SPY	ETF	170.65	170.87	169.72	170.8	730892.0
2013-10-16 09:00:00	SPY	ETF	170.81	170.88	170.71	170.72	937062.0
2013-10-16 09:30:00	SPY	ETF	170.72	171.84	170.635	171.665	21129993.0
2013-10-16 10:00:00	SPY	ETF	171.66	171.81	171.31	171.56	17585423.0
2013-10-16 10:30:00	SPY	ETF	171.56	171.98	171.48	171.95	11562013.0
2013-10-16 11:00:00	SPY	ETF	171.95	172.16	171.73	171.76	12684656.0
2013-10-16 11:30:00	SPY	ETF	171.77	172.05	171.745	171.935	6824669.0
2013-10-16 12:00:00	SPY	ETF	171.93	172.15	171.83	171.845	9455635.0
2013-10-16 12:30:00	SPY	ETF	171.84	171.94	171.65	171.768	8231227.0
2013-10-16 13:00:00	SPY	ETF	171.76	171.95	171.63	171.93	5738244.0
2013-10-16 13:30:00	SPY	ETF	171.93	172.04	171.79	171.8	4809345.0
2013-10-16 14:00:00	SPY	ETF	171.79	171.84	171.53	171.559	5019530.0
2013-10-16 14:30:00	SPY	ETF	171.56	171.72	171.47	171.61	5942012.0
2013-10-16 15:00:00	SPY	ETF	171.61	171.84	171.46	171.68	7005936.0
2013-10-16 15:30:00	SPY	ETF	171.68	172.14	171.61	172.07	15706633.0
2013-10-16 16:00:00	SPY	ETF	172.09	172.1085	169.7638	171.78	12717579.0
2013-10-16 16:30:00	SPY	ETF	171.78	172.05	171.68	171.7	5332060.0
2013-10-16 17:00:00	SPY	ETF	171.69	172.05	171.68	171.75	4019226.0
2013-10-16 17:30:00	SPY	ETF	171.76	171.82	171.7	171.7	114810.0
2013-10-16 18:00:00	SPY	ETF	171.68	171.73	171.62	171.64	178004.0
2013-10-16 18:30:00	SPY	ETF	171.64	171.65	171.6	171.63	267548.0
2013-10-16 19:00:00	SPY	ETF	171.65	171.97	171.65	171.95	127052.0
2013-10-16 19:30:00	SPY	ETF	171.96	171.96	171.79	171.9	56769.0
2013-10-16 04:00:00	QQQ	ETF	79.71	79.71	79.66	79.66	9200.0
2013-10-16 04:30:00	QQQ	ETF	79.67	79.72	79.65	79.7	29200.0
2013-10-16 05:00:00	QQQ	ETF	79.71	79.74	79.68	79.68	35400.0
2013-10-16 05:30:00	QQQ	ETF	79.68	79.68	79.62	79.64	7200.0
2013-10-16 06:00:00	QQQ	ETF	79.63	79.65	79.6	79.63	4700.0
2013-10-16 06:30:00	QQQ	ETF	79.64	79.64	79.59	79.64	6500.0
2013-10-16 07:00:00	QQQ	ETF	79.63	79.79	79.63	79.77	17205.0
2013-10-16 07:30:00	QQQ	ETF	79.78	79.78	79.72	79.74	22018.0
2013-10-16 08:00:00	QQQ	ETF	79.73	79.89	79.73	79.87	52444.0
2013-10-16 08:30:00	QQQ	ETF	79.86	79.96	79.48	79.92	40552.0
2013-10-16 09:00:00	QQQ	ETF	79.93	79.95	79.83	79.84	159143.0
2013-10-16 09:30:00	QQQ	ETF	79.83	80.259	79.79	80.2	6616359.0
2013-10-16 10:00:00	QQQ	ETF	80.2	80.3299	80.08	80.25	5518537.0
2013-10-16 10:30:00	QQQ	ETF	80.259	80.35	80.18	80.33	1939653.0
2013-10-16 11:00:00	QQQ	ETF	80.33	80.42	80.27	80.29	3124560.0
2013-10-16 11:30:00	QQQ	ETF	80.3	80.36	80.25	80.3201	1747440.0
2013-10-16 12:00:00	QQQ	ETF	80.32	80.41	80.27	80.33	3064166.0
2013-10-16 12:30:00	QQQ	ETF	80.33	80.395	80.25	80.3199	3378971.0

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

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