PREVIEW / etf_30min / 2013-12-04

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-04.parquet
  size:    335 KB
  rows:    11,251

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-12-04 04:00:00	SPY	ETF	179.99	180.08	179.94	180.02	2274.0
2013-12-04 04:30:00	SPY	ETF	179.99	180.0	179.92	179.97	5618.0
2013-12-04 05:00:00	SPY	ETF	179.97	179.97	179.87	179.9	5198.0
2013-12-04 05:30:00	SPY	ETF	179.85	179.85	179.75	179.79	3945.0
2013-12-04 06:00:00	SPY	ETF	179.81	179.86	179.78	179.78	4998.0
2013-12-04 06:30:00	SPY	ETF	179.75	179.76	179.69	179.72	12100.0
2013-12-04 07:00:00	SPY	ETF	179.69	179.76	179.69	179.73	52295.0
2013-12-04 07:30:00	SPY	ETF	179.72	179.73	179.34	179.4	210316.0
2013-12-04 08:00:00	SPY	ETF	179.41	179.95	179.08	179.35	997432.0
2013-12-04 08:30:00	SPY	ETF	179.33	179.49	179.27	179.33	394481.0
2013-12-04 09:00:00	SPY	ETF	179.33	179.33	179.08	179.1	779454.0
2013-12-04 09:30:00	SPY	ETF	179.1	179.45	179.03	179.32	12054581.0
2013-12-04 10:00:00	SPY	ETF	179.32	180.48	179.3	180.36	15002426.0
2013-12-04 10:30:00	SPY	ETF	180.35	180.47	180.18	180.418	6989999.0
2013-12-04 11:00:00	SPY	ETF	180.41	180.41	179.93	179.95	5644436.0
2013-12-04 11:30:00	SPY	ETF	179.96	180.1	179.88	179.99	3540157.0
2013-12-04 12:00:00	SPY	ETF	179.98	179.99	179.29	179.38	8594982.0
2013-12-04 12:30:00	SPY	ETF	179.39	179.68	179.36	179.52	4678907.0
2013-12-04 13:00:00	SPY	ETF	179.52	179.69	178.65	178.66	7974831.0
2013-12-04 13:30:00	SPY	ETF	178.66	178.84	178.35	178.79	11360552.0
2013-12-04 14:00:00	SPY	ETF	178.78	179.26	178.73	179.16	7025768.0
2013-12-04 14:30:00	SPY	ETF	179.1683	179.45	179.16	179.385	5514405.0
2013-12-04 15:00:00	SPY	ETF	179.38	179.77	179.22	179.7481	6066444.0
2013-12-04 15:30:00	SPY	ETF	179.74	180.13	179.61	179.7	14188487.0
2013-12-04 16:00:00	SPY	ETF	179.68	179.9784	179.64	179.75	8528943.0
2013-12-04 16:30:00	SPY	ETF	179.75	179.83	179.5659	179.83	674782.0
2013-12-04 17:00:00	SPY	ETF	179.8	179.8	179.77	179.78	44346.0
2013-12-04 17:30:00	SPY	ETF	179.78	179.79	179.75	179.78	71573.0
2013-12-04 18:00:00	SPY	ETF	179.79	179.79	179.74	179.79	6140.0
2013-12-04 18:30:00	SPY	ETF	179.78	179.78	179.76	179.76	500.0
2013-12-04 19:00:00	SPY	ETF	179.77	179.8	179.75	179.75	38290.0
2013-12-04 19:30:00	SPY	ETF	179.73	179.78	179.73	179.76	37491.0
2013-12-04 04:00:00	QQQ	ETF	85.47	85.54	85.47	85.53	6415.0
2013-12-04 04:30:00	QQQ	ETF	85.5	85.54	85.5	85.54	134200.0
2013-12-04 05:00:00	QQQ	ETF	85.5	85.5	85.47	85.47	2200.0
2013-12-04 05:30:00	QQQ	ETF	85.46	85.46	85.44	85.44	1300.0
2013-12-04 06:00:00	QQQ	ETF	85.44	85.47	85.44	85.44	3100.0
2013-12-04 06:30:00	QQQ	ETF	85.41	85.41	85.4	85.41	2200.0
2013-12-04 07:30:00	QQQ	ETF	85.38	85.38	85.22	85.22	17800.0
2013-12-04 08:00:00	QQQ	ETF	85.24	85.24	85.13	85.2	31918.0
2013-12-04 08:30:00	QQQ	ETF	85.21	85.27	85.16	85.16	91672.0
2013-12-04 09:00:00	QQQ	ETF	85.19	85.19	85.04	85.06	409555.0
2013-12-04 09:30:00	QQQ	ETF	85.05	85.32	85.0	85.26	3552836.0
2013-12-04 10:00:00	QQQ	ETF	85.26	85.71	85.25	85.66	5675968.0
2013-12-04 10:30:00	QQQ	ETF	85.66	85.77	85.6207	85.77	1870392.0
2013-12-04 11:00:00	QQQ	ETF	85.765	85.765	85.48	85.48	1408806.0
2013-12-04 11:30:00	QQQ	ETF	85.49	85.58	85.48	85.51	741018.0
2013-12-04 12:00:00	QQQ	ETF	85.51	85.51	85.2	85.29	2768249.0
2013-12-04 12:30:00	QQQ	ETF	85.3	85.43	85.27	85.36	1151777.0
2013-12-04 13:00:00	QQQ	ETF	85.36	85.44	85.03	85.04	3100907.0

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

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