PREVIEW / etf_30min / 2011-12-02

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-02.parquet
  size:    286 KB
  rows:    9,640

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-12-02 04:00:00	SPY	ETF	125.95	126.28	125.95	126.09	48139.0
2011-12-02 04:30:00	SPY	ETF	126.03	126.39	126.0	126.27	8290.0
2011-12-02 05:00:00	SPY	ETF	126.26	126.39	126.26	126.27	3771.0
2011-12-02 05:30:00	SPY	ETF	126.26	126.4	126.14	126.4	10546.0
2011-12-02 06:00:00	SPY	ETF	126.25	126.32	126.19	126.3	19401.0
2011-12-02 06:30:00	SPY	ETF	126.25	126.5	126.23	126.36	60800.0
2011-12-02 07:00:00	SPY	ETF	126.3	126.7	126.14	126.47	433302.0
2011-12-02 07:30:00	SPY	ETF	126.46	126.75	126.36	126.36	837061.0
2011-12-02 08:00:00	SPY	ETF	126.37	126.6	126.33	126.45	2690709.0
2011-12-02 08:30:00	SPY	ETF	126.37	126.83	126.06	126.3	6317911.0
2011-12-02 09:00:00	SPY	ETF	126.3	126.35	126.01	126.12	1869748.0
2011-12-02 09:30:00	SPY	ETF	126.12	126.19	125.7	126.03	21101954.0
2011-12-02 10:00:00	SPY	ETF	126.03	126.5	125.98	126.39	18358658.0
2011-12-02 10:30:00	SPY	ETF	126.39	126.5	126.15	126.2199	14116742.0
2011-12-02 11:00:00	SPY	ETF	126.21	126.31	125.61	125.91	18499575.0
2011-12-02 11:30:00	SPY	ETF	125.91	126.06	125.22	125.52	17891352.0
2011-12-02 12:00:00	SPY	ETF	125.52	125.72	125.32	125.56	11973199.0
2011-12-02 12:30:00	SPY	ETF	125.56	125.8	125.47	125.7	5885434.0
2011-12-02 13:00:00	SPY	ETF	125.69	125.75	125.36	125.48	6120852.0
2011-12-02 13:30:00	SPY	ETF	125.47	125.68	125.36	125.5	7741915.0
2011-12-02 14:00:00	SPY	ETF	125.51	125.56	125.18	125.42	12635193.0
2011-12-02 14:30:00	SPY	ETF	125.42	125.46	125.08	125.14	10235062.0
2011-12-02 15:00:00	SPY	ETF	125.14	125.42	125.08	125.2	9972923.0
2011-12-02 15:30:00	SPY	ETF	125.19	125.34	124.78	124.83	23558829.0
2011-12-02 16:00:00	SPY	ETF	124.84	125.661	124.82	124.95	18352503.0
2011-12-02 16:30:00	SPY	ETF	124.95	125.02	124.9056	125.0	1621726.0
2011-12-02 17:00:00	SPY	ETF	125.0	125.03	124.9	124.97	1262129.0
2011-12-02 17:30:00	SPY	ETF	124.97	125.0	124.92	124.92	161397.0
2011-12-02 18:00:00	SPY	ETF	124.92	125.04	124.86	125.02	243177.0
2011-12-02 18:30:00	SPY	ETF	125.03	125.05	124.92	124.97	58657.0
2011-12-02 19:00:00	SPY	ETF	124.97	124.99	124.92	124.95	22084.0
2011-12-02 19:30:00	SPY	ETF	124.98	125.0	124.92	124.92	17024.0
2011-12-02 04:00:00	QQQ	ETF	57.17	57.45	57.17	57.35	1652.0
2011-12-02 04:30:00	QQQ	ETF	57.34	57.49	57.34	57.44	600.0
2011-12-02 05:00:00	QQQ	ETF	57.48	57.48	57.46	57.46	200.0
2011-12-02 05:30:00	QQQ	ETF	57.41	57.43	57.41	57.43	2000.0
2011-12-02 06:30:00	QQQ	ETF	57.45	57.48	57.45	57.47	2300.0
2011-12-02 07:00:00	QQQ	ETF	57.45	57.56	57.4	57.47	26374.0
2011-12-02 07:30:00	QQQ	ETF	57.49	57.62	57.48	57.49	61489.0
2011-12-02 08:00:00	QQQ	ETF	57.46	57.543	57.16	57.49	286230.0
2011-12-02 08:30:00	QQQ	ETF	57.36	57.66	57.3	57.35	754595.0
2011-12-02 09:00:00	QQQ	ETF	57.37	57.4	57.25	57.32	1460093.0
2011-12-02 09:30:00	QQQ	ETF	57.33	57.34	56.99	57.18	5079019.0
2011-12-02 10:00:00	QQQ	ETF	57.18	57.32	57.15	57.2393	4348061.0
2011-12-02 10:30:00	QQQ	ETF	57.24	57.3	57.13	57.175	1772567.0
2011-12-02 11:00:00	QQQ	ETF	57.16	57.215	56.9	57.04	3259713.0
2011-12-02 11:30:00	QQQ	ETF	57.05	57.095	56.76	56.885	2566337.0
2011-12-02 12:00:00	QQQ	ETF	56.88	56.94	56.78	56.86	1244355.0
2011-12-02 12:30:00	QQQ	ETF	56.86	56.965	56.83	56.925	683881.0
2011-12-02 13:00:00	QQQ	ETF	56.92	56.95	56.77	56.85	1011284.0

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

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