PREVIEW / etf_30min / 2011-09-02

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-02.parquet
  size:    288 KB
  rows:    9,569

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
2011-09-02 04:00:00	SPY	ETF	120.28	120.28	119.75	119.75	18702.0
2011-09-02 04:30:00	SPY	ETF	119.86	119.9	119.65	119.9	11900.0
2011-09-02 05:00:00	SPY	ETF	119.86	119.86	119.65	119.75	14700.0
2011-09-02 05:30:00	SPY	ETF	119.86	119.86	119.76	119.76	2000.0
2011-09-02 06:00:00	SPY	ETF	119.76	119.8	119.6	119.65	32580.0
2011-09-02 06:30:00	SPY	ETF	119.6	119.72	119.55	119.66	86824.0
2011-09-02 07:00:00	SPY	ETF	119.71	119.82	119.65	119.8	280230.0
2011-09-02 07:30:00	SPY	ETF	119.78	119.95	119.77	119.79	213266.0
2011-09-02 08:00:00	SPY	ETF	119.81	120.29	119.48	120.29	1961193.0
2011-09-02 08:30:00	SPY	ETF	119.88	119.88	118.53	118.82	9071942.0
2011-09-02 09:00:00	SPY	ETF	118.82	118.95	118.36	118.41	3097276.0
2011-09-02 09:30:00	SPY	ETF	118.42	118.86	118.08	118.55	36828213.0
2011-09-02 10:00:00	SPY	ETF	118.54	119.08	118.42	118.68	22386772.0
2011-09-02 10:30:00	SPY	ETF	118.68	118.68	118.08	118.6	15668840.0
2011-09-02 11:00:00	SPY	ETF	118.6	120.8726	118.5	118.89	13129724.0
2011-09-02 11:30:00	SPY	ETF	118.89	119.05	118.62	118.68	12037419.0
2011-09-02 12:00:00	SPY	ETF	118.68	119.04	118.66	118.7385	7487787.0
2011-09-02 12:30:00	SPY	ETF	118.73	118.81	118.63	118.73	7091932.0
2011-09-02 13:00:00	SPY	ETF	118.74	118.83	118.29	118.33	7306310.0
2011-09-02 13:30:00	SPY	ETF	118.33	118.5	118.18	118.32	6670047.0
2011-09-02 14:00:00	SPY	ETF	118.33	118.41	117.77	117.8815	16256093.0
2011-09-02 14:30:00	SPY	ETF	117.89	117.89	117.49	117.71	12467867.0
2011-09-02 15:00:00	SPY	ETF	117.7	117.83	117.43	117.7385	12698364.0
2011-09-02 15:30:00	SPY	ETF	117.74	118.24	117.67	117.82	33226261.0
2011-09-02 16:00:00	SPY	ETF	117.82	120.8734	117.45	117.47	19000630.0
2011-09-02 16:30:00	SPY	ETF	117.46	120.8724	117.33	117.44	14903169.0
2011-09-02 17:00:00	SPY	ETF	117.42	117.45	117.4	117.4	150675.0
2011-09-02 17:30:00	SPY	ETF	117.42	117.44	117.4	117.4	36584.0
2011-09-02 18:00:00	SPY	ETF	117.38	117.84	117.37	117.39	265905.0
2011-09-02 18:30:00	SPY	ETF	117.39	117.4	117.37	117.38	58092.0
2011-09-02 19:00:00	SPY	ETF	117.37	117.44	117.36	117.44	37833.0
2011-09-02 19:30:00	SPY	ETF	117.42	117.44	117.39	117.42	36087.0
2011-09-02 04:00:00	QQQ	ETF	54.4	54.4	54.17	54.17	1313.0
2011-09-02 06:00:00	QQQ	ETF	54.17	54.17	54.01	54.06	700.0
2011-09-02 06:30:00	QQQ	ETF	54.05	54.05	54.0	54.0	950.0
2011-09-02 07:00:00	QQQ	ETF	54.03	54.11	54.03	54.11	37960.0
2011-09-02 07:30:00	QQQ	ETF	54.13	54.16	54.08	54.09	126582.0
2011-09-02 08:00:00	QQQ	ETF	54.11	54.29	54.03	54.29	509554.0
2011-09-02 08:30:00	QQQ	ETF	54.0	54.39	53.63	53.75	2091695.0
2011-09-02 09:00:00	QQQ	ETF	53.74	53.81	53.53	53.6	461200.0
2011-09-02 09:30:00	QQQ	ETF	53.58	54.6143	53.35	53.59	8976310.0
2011-09-02 10:00:00	QQQ	ETF	53.58	53.83	53.52	53.63	4531496.0
2011-09-02 10:30:00	QQQ	ETF	53.63	53.63	53.37	53.58	4241980.0
2011-09-02 11:00:00	QQQ	ETF	53.58	53.71	53.54	53.68	3968437.0
2011-09-02 11:30:00	QQQ	ETF	53.67	53.74	53.55	53.57	2254498.0
2011-09-02 12:00:00	QQQ	ETF	53.57	53.7	53.56	53.61	1285150.0
2011-09-02 12:30:00	QQQ	ETF	53.61	53.65	53.56	53.59	1405183.0
2011-09-02 13:00:00	QQQ	ETF	53.6	53.63	53.39	53.41	2292566.0
2011-09-02 13:30:00	QQQ	ETF	53.41	53.48	53.3	53.36	2208923.0
2011-09-02 14:00:00	QQQ	ETF	53.3501	53.39	53.13	53.231	4268526.0

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

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