PREVIEW / etf_30min / 2013-02-08

all etf 30-min files

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

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-08 04:00:00	SPY	ETF	151.16	151.16	151.16	151.16	201.0
2013-02-08 05:00:00	SPY	ETF	150.9	150.95	150.88	150.89	40250.0
2013-02-08 05:30:00	SPY	ETF	150.95	151.04	150.95	151.04	12550.0
2013-02-08 06:00:00	SPY	ETF	150.94	150.97	150.93	150.95	23358.0
2013-02-08 06:30:00	SPY	ETF	151.01	151.06	150.99	151.06	29200.0
2013-02-08 07:00:00	SPY	ETF	151.05	151.08	150.98	151.01	31429.0
2013-02-08 07:30:00	SPY	ETF	151.0	151.11	150.92	150.94	85908.0
2013-02-08 08:00:00	SPY	ETF	151.05	151.05	150.82	150.84	214046.0
2013-02-08 08:30:00	SPY	ETF	150.85	151.16	150.85	151.16	341358.0
2013-02-08 09:00:00	SPY	ETF	151.16	151.26	151.11	151.22	432960.0
2013-02-08 09:30:00	SPY	ETF	151.22	151.84	151.22	151.75	17821131.0
2013-02-08 10:00:00	SPY	ETF	151.74	151.84	151.64	151.655	8245458.0
2013-02-08 10:30:00	SPY	ETF	151.66	151.89	151.645	151.76	6518832.0
2013-02-08 11:00:00	SPY	ETF	151.76	151.8	151.611	151.65	5261039.0
2013-02-08 11:30:00	SPY	ETF	151.64	151.77	151.54	151.74	4617655.0
2013-02-08 12:00:00	SPY	ETF	151.75	151.8	151.65	151.67	3691200.0
2013-02-08 12:30:00	SPY	ETF	151.672	151.69	151.56	151.68	3593222.0
2013-02-08 13:00:00	SPY	ETF	151.67	151.77	151.62	151.63	2854516.0
2013-02-08 13:30:00	SPY	ETF	151.63	151.78	151.6101	151.73	2227851.0
2013-02-08 14:00:00	SPY	ETF	151.74	151.8	151.7	151.76	2487716.0
2013-02-08 14:30:00	SPY	ETF	151.77	151.83	151.71	151.7365	4184077.0
2013-02-08 15:00:00	SPY	ETF	151.74	151.78	151.63	151.65	4750935.0
2013-02-08 15:30:00	SPY	ETF	151.66	151.79	151.52	151.78	16323397.0
2013-02-08 16:00:00	SPY	ETF	151.77	151.8401	151.6195	151.69	10028435.0
2013-02-08 16:30:00	SPY	ETF	151.69	151.84	150.9864	151.78	1475184.0
2013-02-08 17:00:00	SPY	ETF	151.78	151.82	151.75	151.79	55020.0
2013-02-08 17:30:00	SPY	ETF	151.78	151.8	151.71	151.71	3074004.0
2013-02-08 18:00:00	SPY	ETF	151.75	151.8	151.75	151.75	13000.0
2013-02-08 18:30:00	SPY	ETF	151.75	151.78	151.75	151.78	5112.0
2013-02-08 19:00:00	SPY	ETF	151.78	151.78	151.74	151.77	1500.0
2013-02-08 19:30:00	SPY	ETF	151.76	151.76	151.7	151.75	9250.0
2013-02-08 05:00:00	QQQ	ETF	67.32	67.32	67.32	67.32	4900.0
2013-02-08 05:30:00	QQQ	ETF	67.34	67.34	67.34	67.34	200.0
2013-02-08 06:00:00	QQQ	ETF	67.35	67.35	67.35	67.35	5500.0
2013-02-08 06:30:00	QQQ	ETF	67.36	67.36	67.36	67.36	500.0
2013-02-08 07:00:00	QQQ	ETF	67.34	67.34	67.34	67.34	1700.0
2013-02-08 07:30:00	QQQ	ETF	67.35	67.39	67.35	67.36	16801.0
2013-02-08 08:00:00	QQQ	ETF	67.35	67.4	67.33	67.33	169584.0
2013-02-08 08:30:00	QQQ	ETF	67.36	67.53	67.36	67.5	320652.0
2013-02-08 09:00:00	QQQ	ETF	67.5	67.65	67.5	67.64	240594.0
2013-02-08 09:30:00	QQQ	ETF	67.64	68.088	67.63	68.05	6302589.0
2013-02-08 10:00:00	QQQ	ETF	68.05	68.13	67.97	68.0	4426604.0
2013-02-08 10:30:00	QQQ	ETF	68.0	68.12	67.98	68.1	1712173.0
2013-02-08 11:00:00	QQQ	ETF	68.091	68.13	68.045	68.06	2064033.0
2013-02-08 11:30:00	QQQ	ETF	68.06	68.08	68.0	68.06	1420279.0
2013-02-08 12:00:00	QQQ	ETF	68.06	68.09	68.02	68.03	1000412.0
2013-02-08 12:30:00	QQQ	ETF	68.04	68.05	67.95	68.03	1317975.0
2013-02-08 13:00:00	QQQ	ETF	68.035	68.1	68.02	68.02	1188458.0
2013-02-08 13:30:00	QQQ	ETF	68.025	68.13	68.019	68.075	753042.0
2013-02-08 14:00:00	QQQ	ETF	68.07	68.125	68.06	68.091	733950.0

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

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