PREVIEW / etf_30min / 2013-02-13

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-13.parquet
  size:    300 KB
  rows:    10,308

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-02-13 04:00:00	SPY	ETF	152.23	152.23	152.23	152.23	100.0
2013-02-13 04:30:00	SPY	ETF	152.2	152.2	152.2	152.2	200.0
2013-02-13 05:00:00	SPY	ETF	152.11	152.13	152.1	152.13	12300.0
2013-02-13 05:30:00	SPY	ETF	152.16	152.18	152.13	152.13	38423.0
2013-02-13 06:00:00	SPY	ETF	152.13	152.2	152.13	152.18	28700.0
2013-02-13 06:30:00	SPY	ETF	152.27	152.34	152.23	152.32	31333.0
2013-02-13 07:00:00	SPY	ETF	152.31	152.37	152.28	152.37	72763.0
2013-02-13 07:30:00	SPY	ETF	152.37	152.4	152.32	152.35	272717.0
2013-02-13 08:00:00	SPY	ETF	152.33	152.41	152.27	152.41	259405.0
2013-02-13 08:30:00	SPY	ETF	152.38	152.38	152.23	152.3	344400.0
2013-02-13 09:00:00	SPY	ETF	152.3	152.39	152.28	152.33	302892.0
2013-02-13 09:30:00	SPY	ETF	152.33	152.51	152.13	152.47	11114068.0
2013-02-13 10:00:00	SPY	ETF	152.46	152.61	152.4	152.5	7691332.0
2013-02-13 10:30:00	SPY	ETF	152.5	152.51	152.24	152.34	4206384.0
2013-02-13 11:00:00	SPY	ETF	152.33	152.36	151.94	152.01	6269052.0
2013-02-13 11:30:00	SPY	ETF	152.01	152.07	151.9	152.0299	4281544.0
2013-02-13 12:00:00	SPY	ETF	152.03	152.12	152.01	152.04	4183989.0
2013-02-13 12:30:00	SPY	ETF	152.04	152.22	152.03	152.11	3725478.0
2013-02-13 13:00:00	SPY	ETF	152.11	152.2	152.1	152.17	2873508.0
2013-02-13 13:30:00	SPY	ETF	152.17	152.26	152.16	152.2099	1906824.0
2013-02-13 14:00:00	SPY	ETF	152.208	152.24	151.9	152.0	6545180.0
2013-02-13 14:30:00	SPY	ETF	152.0	152.01	151.72	151.81	6072481.0
2013-02-13 15:00:00	SPY	ETF	151.81	152.02	151.81	151.96	4893874.0
2013-02-13 15:30:00	SPY	ETF	151.96	152.17	151.86	152.16	10221014.0
2013-02-13 16:00:00	SPY	ETF	152.15	152.33	151.98	152.08	3698613.0
2013-02-13 16:30:00	SPY	ETF	152.08	152.1844	152.06	152.12	1243892.0
2013-02-13 17:00:00	SPY	ETF	152.13	152.14	152.05	152.08	127634.0
2013-02-13 17:30:00	SPY	ETF	152.07	152.09	152.04	152.07	28345.0
2013-02-13 18:00:00	SPY	ETF	152.05	152.07	152.02	152.07	25375.0
2013-02-13 18:30:00	SPY	ETF	152.05	152.05	151.97	152.02	27500.0
2013-02-13 19:00:00	SPY	ETF	152.02	152.05	151.98	152.0	19865.0
2013-02-13 19:30:00	SPY	ETF	152.01	152.03	151.97	151.99	33010.0
2013-02-13 06:00:00	QQQ	ETF	67.83	67.84	67.83	67.83	1200.0
2013-02-13 07:00:00	QQQ	ETF	67.91	67.91	67.91	67.91	100.0
2013-02-13 07:30:00	QQQ	ETF	67.92	67.95	67.9	67.9	54200.0
2013-02-13 08:00:00	QQQ	ETF	67.91	67.98	67.9	67.98	28900.0
2013-02-13 08:30:00	QQQ	ETF	67.9	67.92	67.73	67.9	109434.0
2013-02-13 09:00:00	QQQ	ETF	67.9	67.94	67.9	67.93	191018.0
2013-02-13 09:30:00	QQQ	ETF	67.93	68.1599	67.7845	68.15	2928451.0
2013-02-13 10:00:00	QQQ	ETF	68.155	68.23	68.1	68.155	3035227.0
2013-02-13 10:30:00	QQQ	ETF	68.15	68.2	68.06	68.13	1954636.0
2013-02-13 11:00:00	QQQ	ETF	68.13	68.14	67.82	67.87	2312809.0
2013-02-13 11:30:00	QQQ	ETF	67.87	67.9201	67.77	67.8437	1381761.0
2013-02-13 12:00:00	QQQ	ETF	67.84	67.89	67.82	67.8699	726521.0
2013-02-13 12:30:00	QQQ	ETF	67.87	67.98	67.85	67.89	1235624.0
2013-02-13 13:00:00	QQQ	ETF	67.882	67.97	67.8748	67.962	687322.0
2013-02-13 13:30:00	QQQ	ETF	67.97	68.07	67.97	68.02	497452.0
2013-02-13 14:00:00	QQQ	ETF	68.02	68.05	67.85	67.9	705150.0
2013-02-13 14:30:00	QQQ	ETF	67.89	67.9	67.765	67.8151	2020084.0
2013-02-13 15:00:00	QQQ	ETF	67.82	67.91	67.79	67.86	1030980.0

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

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