PREVIEW / etf_30min / 2012-03-21

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-21.parquet
  size:    278 KB
  rows:    9,383

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
2012-03-21 04:00:00	SPY	ETF	140.64	140.95	140.64	140.95	3230.0
2012-03-21 04:30:00	SPY	ETF	140.9	140.97	140.9	140.92	41000.0
2012-03-21 05:00:00	SPY	ETF	140.9	140.9	140.7	140.75	24300.0
2012-03-21 05:30:00	SPY	ETF	140.85	140.9	140.85	140.9	10600.0
2012-03-21 06:00:00	SPY	ETF	140.83	140.83	140.78	140.8	26075.0
2012-03-21 06:30:00	SPY	ETF	140.8	140.8	140.71	140.74	7310.0
2012-03-21 07:00:00	SPY	ETF	140.74	140.78	140.69	140.75	45337.0
2012-03-21 07:30:00	SPY	ETF	140.7	140.82	140.69	140.81	76186.0
2012-03-21 08:00:00	SPY	ETF	140.8	140.85	140.4287	140.53	1276912.0
2012-03-21 08:30:00	SPY	ETF	140.53	140.57	140.44	140.53	439546.0
2012-03-21 09:00:00	SPY	ETF	140.51	140.6	140.49	140.54	665804.0
2012-03-21 09:30:00	SPY	ETF	140.52	140.65	140.28	140.375	13807072.0
2012-03-21 10:00:00	SPY	ETF	140.37	140.38	140.06	140.31	14894098.0
2012-03-21 10:30:00	SPY	ETF	140.31	140.44	139.99	140.031	12182909.0
2012-03-21 11:00:00	SPY	ETF	140.035	140.2	139.92	140.14	10138245.0
2012-03-21 11:30:00	SPY	ETF	140.1405	140.36	140.1405	140.195	6973066.0
2012-03-21 12:00:00	SPY	ETF	140.2	140.53	140.19	140.49	5813461.0
2012-03-21 12:30:00	SPY	ETF	140.49	140.56	140.43	140.51	2832130.0
2012-03-21 13:00:00	SPY	ETF	140.51	140.52	140.31	140.39	3551389.0
2012-03-21 13:30:00	SPY	ETF	140.395	140.41	140.24	140.355	3726125.0
2012-03-21 14:00:00	SPY	ETF	140.36	140.49	140.33	140.43	6276049.0
2012-03-21 14:30:00	SPY	ETF	140.43	140.57	140.35	140.455	5157110.0
2012-03-21 15:00:00	SPY	ETF	140.46	140.63	140.425	140.555	6743533.0
2012-03-21 15:30:00	SPY	ETF	140.56	140.6	140.21	140.21	17124948.0
2012-03-21 16:00:00	SPY	ETF	140.2	140.28	140.07	140.19	8323818.0
2012-03-21 16:30:00	SPY	ETF	140.19	140.24	140.1699	140.18	539782.0
2012-03-21 17:00:00	SPY	ETF	140.18	140.18	140.12	140.14	40066.0
2012-03-21 17:30:00	SPY	ETF	140.17	140.2	140.17	140.19	45270.0
2012-03-21 18:00:00	SPY	ETF	140.18	140.31	140.18	140.31	83850.0
2012-03-21 18:30:00	SPY	ETF	140.29	140.29	140.22	140.28	18662.0
2012-03-21 19:00:00	SPY	ETF	140.27	140.27	140.23	140.26	10354.0
2012-03-21 19:30:00	SPY	ETF	140.26	140.35	140.25	140.34	29709.0
2012-03-21 06:00:00	QQQ	ETF	67.2	67.26	67.2	67.26	4000.0
2012-03-21 07:00:00	QQQ	ETF	67.22	67.23	67.2	67.21	20400.0
2012-03-21 07:30:00	QQQ	ETF	67.19	67.27	67.19	67.27	103300.0
2012-03-21 08:00:00	QQQ	ETF	67.27	67.28	67.09	67.14	496932.0
2012-03-21 08:30:00	QQQ	ETF	67.12	67.17	67.11	67.12	34849.0
2012-03-21 09:00:00	QQQ	ETF	67.11	67.17	67.11	67.12	165615.0
2012-03-21 09:30:00	QQQ	ETF	67.13	67.32	67.12	67.23	4645668.0
2012-03-21 10:00:00	QQQ	ETF	67.22	67.225	67.1101	67.21	5685488.0
2012-03-21 10:30:00	QQQ	ETF	67.21	67.3	67.06	67.082	2747864.0
2012-03-21 11:00:00	QQQ	ETF	67.08	67.19	67.03	67.18	2151036.0
2012-03-21 11:30:00	QQQ	ETF	67.18	67.25	67.16	67.1709	1600454.0
2012-03-21 12:00:00	QQQ	ETF	67.18	67.35	67.17	67.34	1528375.0
2012-03-21 12:30:00	QQQ	ETF	67.338	67.4	67.3	67.3814	1680428.0
2012-03-21 13:00:00	QQQ	ETF	67.385	67.39	67.25	67.31	1571679.0
2012-03-21 13:30:00	QQQ	ETF	67.31	67.35	67.23	67.34	803722.0
2012-03-21 14:00:00	QQQ	ETF	67.34	67.43	67.32	67.38	1316847.0
2012-03-21 14:30:00	QQQ	ETF	67.37	67.4601	67.35	67.41	2533826.0
2012-03-21 15:00:00	QQQ	ETF	67.41	67.49	67.39	67.44	1167647.0

> showing 50 of 9,383 rows — these rows as CSV

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