PREVIEW / etf_30min / 2013-02-11

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-11.parquet
  size:    293 KB
  rows:    10,157

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-11 04:00:00	SPY	ETF	151.75	151.85	151.75	151.85	300.0
2013-02-11 04:30:00	SPY	ETF	151.9	152.05	151.9	152.05	15600.0
2013-02-11 05:00:00	SPY	ETF	152.03	152.03	151.94	151.94	1600.0
2013-02-11 06:00:00	SPY	ETF	151.93	151.96	151.88	151.88	3199.0
2013-02-11 06:30:00	SPY	ETF	151.97	151.97	151.93	151.93	13600.0
2013-02-11 07:00:00	SPY	ETF	151.93	151.99	151.89	151.89	67463.0
2013-02-11 07:30:00	SPY	ETF	151.9	152.04	151.9	152.03	42998.0
2013-02-11 08:00:00	SPY	ETF	152.03	152.04	151.88	151.93	334915.0
2013-02-11 08:30:00	SPY	ETF	151.91	151.91	151.67	151.74	361275.0
2013-02-11 09:00:00	SPY	ETF	151.74	151.84	151.71	151.75	251184.0
2013-02-11 09:30:00	SPY	ETF	151.74	151.77	151.49	151.6	10883980.0
2013-02-11 10:00:00	SPY	ETF	151.61	151.72	151.3938	151.6	8145093.0
2013-02-11 10:30:00	SPY	ETF	151.599	151.78	151.495	151.76	5888690.0
2013-02-11 11:00:00	SPY	ETF	151.76	151.86	151.7	151.73	4470655.0
2013-02-11 11:30:00	SPY	ETF	151.72	151.8	151.71	151.785	2418708.0
2013-02-11 12:00:00	SPY	ETF	151.789	151.795	151.58	151.68	3075921.0
2013-02-11 12:30:00	SPY	ETF	151.69	151.695	151.5	151.64	2369079.0
2013-02-11 13:00:00	SPY	ETF	151.64	151.76	151.61	151.638	2640138.0
2013-02-11 13:30:00	SPY	ETF	151.64	151.67	151.55	151.61	1751312.0
2013-02-11 14:00:00	SPY	ETF	151.605	151.705	151.59	151.6731	2500482.0
2013-02-11 14:30:00	SPY	ETF	151.67	151.74	151.58	151.6	2218492.0
2013-02-11 15:00:00	SPY	ETF	151.605	151.8	151.595	151.741	3411750.0
2013-02-11 15:30:00	SPY	ETF	151.741	151.9	151.72	151.76	7227929.0
2013-02-11 16:00:00	SPY	ETF	151.77	151.83	151.635	151.74	6715315.0
2013-02-11 16:30:00	SPY	ETF	151.74	151.845	151.73	151.78	718871.0
2013-02-11 17:00:00	SPY	ETF	151.77	151.78	151.69	151.71	43170.0
2013-02-11 17:30:00	SPY	ETF	151.7	151.72	151.69	151.69	17218.0
2013-02-11 18:00:00	SPY	ETF	151.69	151.73	151.67	151.73	66850.0
2013-02-11 18:30:00	SPY	ETF	151.73	151.73	151.7	151.7	3411.0
2013-02-11 19:00:00	SPY	ETF	151.69	151.69	151.66	151.67	14190.0
2013-02-11 19:30:00	SPY	ETF	151.69	151.7	151.66	151.68	16541.0
2013-02-11 04:00:00	QQQ	ETF	68.11	68.11	68.11	68.11	198.0
2013-02-11 04:30:00	QQQ	ETF	68.12	68.19	68.11	68.19	800.0
2013-02-11 05:00:00	QQQ	ETF	68.19	68.19	68.13	68.13	400.0
2013-02-11 07:00:00	QQQ	ETF	68.11	68.11	68.1	68.11	647.0
2013-02-11 07:30:00	QQQ	ETF	68.1	68.12	68.1	68.11	461.0
2013-02-11 08:00:00	QQQ	ETF	68.11	68.12	68.06	68.07	37460.0
2013-02-11 08:30:00	QQQ	ETF	68.07	68.07	68.02	68.06	46270.0
2013-02-11 09:00:00	QQQ	ETF	68.05	68.06	68.02	68.03	94458.0
2013-02-11 09:30:00	QQQ	ETF	68.02	68.05	67.8	67.85	3060619.0
2013-02-11 10:00:00	QQQ	ETF	67.86	67.94	67.78	67.93	2677520.0
2013-02-11 10:30:00	QQQ	ETF	67.92	68.0	67.83	68.0	1411200.0
2013-02-11 11:00:00	QQQ	ETF	67.99	68.06	67.967	67.989	1239279.0
2013-02-11 11:30:00	QQQ	ETF	67.99	68.03	67.97	68.01	783459.0
2013-02-11 12:00:00	QQQ	ETF	68.01	68.01	67.91	67.9248	845774.0
2013-02-11 12:30:00	QQQ	ETF	67.929	67.931	67.8205	67.905	739547.0
2013-02-11 13:00:00	QQQ	ETF	67.91	67.96	67.862	67.9	637656.0
2013-02-11 13:30:00	QQQ	ETF	67.91	67.92	67.85	67.88	545750.0
2013-02-11 14:00:00	QQQ	ETF	67.88	67.95	67.86	67.94	449122.0
2013-02-11 14:30:00	QQQ	ETF	67.93	67.951	67.87	67.88	697223.0

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

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