PREVIEW / etf_30min / 2013-11-08

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-08.parquet
  size:    334 KB
  rows:    11,172

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-11-08 04:00:00	SPY	ETF	175.45	175.56	175.45	175.5	41600.0
2013-11-08 04:30:00	SPY	ETF	175.49	175.55	175.49	175.49	2301.0
2013-11-08 05:00:00	SPY	ETF	175.47	175.5	175.42	175.5	7365.0
2013-11-08 05:30:00	SPY	ETF	175.49	175.5	175.4	175.45	30631.0
2013-11-08 06:00:00	SPY	ETF	175.45	175.46	175.39	175.39	13750.0
2013-11-08 06:30:00	SPY	ETF	175.37	175.37	175.27	175.32	21053.0
2013-11-08 07:00:00	SPY	ETF	175.32	175.45	175.29	175.41	64795.0
2013-11-08 07:30:00	SPY	ETF	175.39	175.39	175.09	175.13	178839.0
2013-11-08 08:00:00	SPY	ETF	175.14	175.42	175.04	175.3	687376.0
2013-11-08 08:30:00	SPY	ETF	175.32	175.5	174.15	174.76	5545205.0
2013-11-08 09:00:00	SPY	ETF	174.74	175.28	174.66	174.85	2965670.0
2013-11-08 09:30:00	SPY	ETF	174.87	175.53	174.85	175.01	16944431.0
2013-11-08 10:00:00	SPY	ETF	175.01	175.98	174.98	175.94	12320577.0
2013-11-08 10:30:00	SPY	ETF	175.94	176.27	175.9	176.192	12081642.0
2013-11-08 11:00:00	SPY	ETF	176.2	176.29	175.97	176.125	6145354.0
2013-11-08 11:30:00	SPY	ETF	176.12	176.37	176.06	176.23	6874332.0
2013-11-08 12:00:00	SPY	ETF	176.24	176.53	176.23	176.51	5617696.0
2013-11-08 12:30:00	SPY	ETF	176.51	176.53	176.38	176.48	2956694.0
2013-11-08 13:00:00	SPY	ETF	176.475	176.68	176.31	176.61	5686642.0
2013-11-08 13:30:00	SPY	ETF	176.62	176.78	176.51	176.57	4664008.0
2013-11-08 14:00:00	SPY	ETF	176.5689	176.74	176.53	176.715	3463843.0
2013-11-08 14:30:00	SPY	ETF	176.72	176.75	176.58	176.685	4611594.0
2013-11-08 15:00:00	SPY	ETF	176.68	176.74	176.4	176.61	7267094.0
2013-11-08 15:30:00	SPY	ETF	176.6099	177.25	176.57	177.23	24921226.0
2013-11-08 16:00:00	SPY	ETF	177.24	177.31	176.5	177.16	9197412.0
2013-11-08 16:30:00	SPY	ETF	177.17	177.23	176.4	177.05	1587762.0
2013-11-08 17:00:00	SPY	ETF	177.05	177.24	177.05	177.24	884191.0
2013-11-08 17:30:00	SPY	ETF	177.22	177.24	177.11	177.11	39853.0
2013-11-08 18:00:00	SPY	ETF	177.16	177.16	177.1	177.14	3604.0
2013-11-08 18:30:00	SPY	ETF	177.14	177.18	177.12	177.14	5214.0
2013-11-08 19:00:00	SPY	ETF	177.17	177.17	177.15	177.16	5670.0
2013-11-08 19:30:00	SPY	ETF	177.17	177.25	177.16	177.19	17005.0
2013-11-08 04:00:00	QQQ	ETF	81.74	81.81	81.74	81.78	19000.0
2013-11-08 04:30:00	QQQ	ETF	81.79	81.8	81.78	81.78	2000.0
2013-11-08 05:00:00	QQQ	ETF	81.77	81.79	81.77	81.79	1700.0
2013-11-08 05:30:00	QQQ	ETF	81.78	81.79	81.77	81.78	4000.0
2013-11-08 06:00:00	QQQ	ETF	81.77	81.77	81.75	81.76	4700.0
2013-11-08 06:30:00	QQQ	ETF	81.75	81.75	81.72	81.75	6100.0
2013-11-08 07:00:00	QQQ	ETF	81.76	81.79	81.75	81.78	19325.0
2013-11-08 07:30:00	QQQ	ETF	81.77	81.77	81.63	81.64	46100.0
2013-11-08 08:00:00	QQQ	ETF	81.63	81.81	81.56	81.58	231235.0
2013-11-08 08:30:00	QQQ	ETF	81.6	81.69	81.28	81.57	830524.0
2013-11-08 09:00:00	QQQ	ETF	81.56	81.82	81.54	81.72	429002.0
2013-11-08 09:30:00	QQQ	ETF	81.73	81.93	81.51	81.6	5147788.0
2013-11-08 10:00:00	QQQ	ETF	81.6	82.11	81.59	82.07	4393465.0
2013-11-08 10:30:00	QQQ	ETF	82.07	82.25	81.99	82.13	3162621.0
2013-11-08 11:00:00	QQQ	ETF	82.125	82.2	82.03	82.16	1587580.0
2013-11-08 11:30:00	QQQ	ETF	82.16	82.33	82.12	82.28	1404026.0
2013-11-08 12:00:00	QQQ	ETF	82.28	82.39	82.28	82.38	1425316.0
2013-11-08 12:30:00	QQQ	ETF	82.39	82.4	82.3	82.35	798549.0

> showing 50 of 11,172 rows — these rows as CSV

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