PREVIEW / etf_30min / 2013-11-27

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-27.parquet
  size:    317 KB
  rows:    10,834

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-27 04:00:00	SPY	ETF	180.72	180.92	180.72	180.9	4717.0
2013-11-27 04:30:00	SPY	ETF	180.88	180.92	180.86	180.92	1280.0
2013-11-27 05:00:00	SPY	ETF	180.93	180.93	180.86	180.92	38039.0
2013-11-27 05:30:00	SPY	ETF	180.89	180.89	180.85	180.85	6268.0
2013-11-27 06:00:00	SPY	ETF	180.85	180.85	180.8	180.82	10962.0
2013-11-27 06:30:00	SPY	ETF	180.85	180.93	180.85	180.88	25817.0
2013-11-27 07:00:00	SPY	ETF	180.9	180.94	180.89	180.91	53032.0
2013-11-27 07:30:00	SPY	ETF	180.85	180.91	180.83	180.84	18760.0
2013-11-27 08:00:00	SPY	ETF	180.87	180.89	180.82	180.89	71020.0
2013-11-27 08:30:00	SPY	ETF	180.88	180.95	180.74	180.88	273419.0
2013-11-27 09:00:00	SPY	ETF	180.92	180.95	180.88	180.88	528493.0
2013-11-27 09:30:00	SPY	ETF	180.87	181.24	180.75	181.11	8735461.0
2013-11-27 10:00:00	SPY	ETF	181.12	181.18	181.0	181.05	5295554.0
2013-11-27 10:30:00	SPY	ETF	181.06	181.215	181.04	181.0605	3396526.0
2013-11-27 11:00:00	SPY	ETF	181.07	181.23	181.06	181.18	3658633.0
2013-11-27 11:30:00	SPY	ETF	181.175	181.23	181.03	181.09	2670358.0
2013-11-27 12:00:00	SPY	ETF	181.085	181.09	180.93	181.01	3593497.0
2013-11-27 12:30:00	SPY	ETF	181.0	181.01	180.68	180.691	2922421.0
2013-11-27 13:00:00	SPY	ETF	180.69	180.8	180.65	180.8	2724183.0
2013-11-27 13:30:00	SPY	ETF	180.8	180.92	180.76	180.8699	2073797.0
2013-11-27 14:00:00	SPY	ETF	180.86	180.95	180.84	180.93	2024138.0
2013-11-27 14:30:00	SPY	ETF	180.93	181.16	180.92	181.11	4070407.0
2013-11-27 15:00:00	SPY	ETF	181.11	181.17	181.04	181.135	3533282.0
2013-11-27 15:30:00	SPY	ETF	181.14	181.21	181.04	181.14	7086834.0
2013-11-27 16:00:00	SPY	ETF	181.12	181.14	180.6674	180.93	3445265.0
2013-11-27 16:30:00	SPY	ETF	180.93	181.004	180.92	180.96	294328.0
2013-11-27 17:00:00	SPY	ETF	180.96	181.12	180.9	180.95	889309.0
2013-11-27 17:30:00	SPY	ETF	180.95	180.98	180.95	180.98	1300.0
2013-11-27 18:00:00	SPY	ETF	180.98	181.23	180.98	181.18	172721.0
2013-11-27 18:30:00	SPY	ETF	181.18	181.22	181.12	181.12	11400.0
2013-11-27 19:00:00	SPY	ETF	181.12	181.14	181.07	181.07	363975.0
2013-11-27 19:30:00	SPY	ETF	181.1	181.1	181.07	181.08	13614.0
2013-11-27 04:00:00	QQQ	ETF	84.67	84.75	84.67	84.75	500.0
2013-11-27 04:30:00	QQQ	ETF	84.74	84.76	84.74	84.76	7000.0
2013-11-27 05:00:00	QQQ	ETF	84.73	84.73	84.73	84.73	1400.0
2013-11-27 05:30:00	QQQ	ETF	84.74	84.74	84.74	84.74	15000.0
2013-11-27 06:00:00	QQQ	ETF	84.74	84.74	84.7	84.7	3200.0
2013-11-27 06:30:00	QQQ	ETF	84.73	84.76	84.73	84.76	2800.0
2013-11-27 07:00:00	QQQ	ETF	84.75	84.76	84.72	84.75	34000.0
2013-11-27 07:30:00	QQQ	ETF	84.74	84.75	84.72	84.75	17995.0
2013-11-27 08:00:00	QQQ	ETF	84.75	84.77	84.73	84.76	84470.0
2013-11-27 08:30:00	QQQ	ETF	84.73	84.78	84.7	84.78	65190.0
2013-11-27 09:00:00	QQQ	ETF	84.78	84.82	84.78	84.81	66314.0
2013-11-27 09:30:00	QQQ	ETF	84.79	85.13	84.73	85.06	3970945.0
2013-11-27 10:00:00	QQQ	ETF	85.06	85.129	85.0	85.0501	1967482.0
2013-11-27 10:30:00	QQQ	ETF	85.06	85.13	84.97	85.0201	1255779.0
2013-11-27 11:00:00	QQQ	ETF	85.03	85.13	85.0	85.11	986680.0
2013-11-27 11:30:00	QQQ	ETF	85.11	85.16	85.04	85.09	1293516.0
2013-11-27 12:00:00	QQQ	ETF	85.09	85.1	85.0	85.07	724602.0
2013-11-27 12:30:00	QQQ	ETF	85.07	85.1	84.9699	84.975	773145.0

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

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