PREVIEW / etf_30min / 2013-04-26

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-26.parquet
  size:    296 KB
  rows:    10,156

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-04-26 04:00:00	SPY	ETF	158.3	158.3	158.3	158.3	10000.0
2013-04-26 04:30:00	SPY	ETF	158.2	158.2	158.1	158.2	5299.0
2013-04-26 05:00:00	SPY	ETF	158.16	158.16	158.08	158.09	11885.0
2013-04-26 05:30:00	SPY	ETF	158.18	158.21	158.14	158.21	4850.0
2013-04-26 06:00:00	SPY	ETF	158.18	158.22	158.11	158.17	36600.0
2013-04-26 06:30:00	SPY	ETF	158.16	158.19	158.0	158.16	35220.0
2013-04-26 07:00:00	SPY	ETF	158.18	158.33	158.12	158.2	323200.0
2013-04-26 07:30:00	SPY	ETF	158.2	158.29	158.18	158.2	218050.0
2013-04-26 08:00:00	SPY	ETF	158.2	158.52	158.01	158.31	1445398.0
2013-04-26 08:30:00	SPY	ETF	158.23	158.24	157.91	158.2	812966.0
2013-04-26 09:00:00	SPY	ETF	158.2	158.61	158.15	158.33	613025.0
2013-04-26 09:30:00	SPY	ETF	158.33	158.55	158.1	158.53	13065556.0
2013-04-26 10:00:00	SPY	ETF	158.53	158.6	157.95	158.23	10100709.0
2013-04-26 10:30:00	SPY	ETF	158.23	158.28	157.93	158.06	7332518.0
2013-04-26 11:00:00	SPY	ETF	158.05	158.25	157.98	158.12	5355986.0
2013-04-26 11:30:00	SPY	ETF	158.13	158.35	157.79	157.879	5446865.0
2013-04-26 12:00:00	SPY	ETF	157.87	157.96	157.73	157.82	5329070.0
2013-04-26 12:30:00	SPY	ETF	157.8121	158.02	157.76	157.995	4047921.0
2013-04-26 13:00:00	SPY	ETF	157.99	158.27	157.925	158.22	4161021.0
2013-04-26 13:30:00	SPY	ETF	158.21	158.35	158.14	158.24	3947994.0
2013-04-26 14:00:00	SPY	ETF	158.24	158.32	158.12	158.19	3245306.0
2013-04-26 14:30:00	SPY	ETF	158.19	158.37	158.14	158.24	3318150.0
2013-04-26 15:00:00	SPY	ETF	158.24	158.57	158.24	158.525	5890831.0
2013-04-26 15:30:00	SPY	ETF	158.52	158.57	158.2	158.24	12923400.0
2013-04-26 16:00:00	SPY	ETF	158.25	158.4	158.07	158.12	5150188.0
2013-04-26 16:30:00	SPY	ETF	158.11	158.19	158.11	158.16	170257.0
2013-04-26 17:00:00	SPY	ETF	158.15	158.27	158.1	158.22	162283.0
2013-04-26 17:30:00	SPY	ETF	158.22	158.26	158.14	158.26	99575.0
2013-04-26 18:00:00	SPY	ETF	158.26	158.29	158.21	158.26	13194.0
2013-04-26 18:30:00	SPY	ETF	158.28	158.3	158.26	158.26	5174.0
2013-04-26 19:00:00	SPY	ETF	158.31	158.33	158.27	158.27	4412.0
2013-04-26 19:30:00	SPY	ETF	158.27	158.29	158.25	158.28	4703.0
2013-04-26 05:00:00	QQQ	ETF	69.56	69.56	69.56	69.56	500.0
2013-04-26 05:30:00	QQQ	ETF	69.59	69.65	69.59	69.65	9900.0
2013-04-26 06:00:00	QQQ	ETF	69.61	69.62	69.59	69.61	5100.0
2013-04-26 06:30:00	QQQ	ETF	69.58	69.61	69.53	69.61	2600.0
2013-04-26 07:00:00	QQQ	ETF	69.56	69.64	69.52	69.56	239700.0
2013-04-26 07:30:00	QQQ	ETF	69.55	69.57	69.53	69.57	176200.0
2013-04-26 08:00:00	QQQ	ETF	69.54	69.59	69.5	69.58	673410.0
2013-04-26 08:30:00	QQQ	ETF	69.52	69.64	69.45	69.6	173495.0
2013-04-26 09:00:00	QQQ	ETF	69.61	69.64	69.59	69.61	74568.0
2013-04-26 09:30:00	QQQ	ETF	69.62	69.72	69.54	69.69	3369700.0
2013-04-26 10:00:00	QQQ	ETF	69.7	69.7199	69.3176	69.49	2445018.0
2013-04-26 10:30:00	QQQ	ETF	69.49	69.56	69.41	69.48	1358641.0
2013-04-26 11:00:00	QQQ	ETF	69.48	69.55	69.43	69.47	808472.0
2013-04-26 11:30:00	QQQ	ETF	69.48	69.5	69.32	69.36	1921075.0
2013-04-26 12:00:00	QQQ	ETF	69.36	69.39	69.27	69.35	2219327.0
2013-04-26 12:30:00	QQQ	ETF	69.35	69.46	69.34	69.44	702697.0
2013-04-26 13:00:00	QQQ	ETF	69.44	69.61	69.42	69.585	997829.0
2013-04-26 13:30:00	QQQ	ETF	69.59	69.6	69.53	69.588	608190.0

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

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