PREVIEW / etf_30min / 2013-04-30

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-30.parquet
  size:    311 KB
  rows:    10,515

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-30 04:30:00	SPY	ETF	159.11	159.11	159.1	159.1	300.0
2013-04-30 05:00:00	SPY	ETF	159.16	159.31	159.16	159.2	4400.0
2013-04-30 05:30:00	SPY	ETF	159.29	159.32	159.14	159.14	3600.0
2013-04-30 06:00:00	SPY	ETF	159.19	159.19	159.04	159.04	23100.0
2013-04-30 06:30:00	SPY	ETF	159.02	159.11	159.01	159.11	64300.0
2013-04-30 07:00:00	SPY	ETF	159.1	159.14	159.08	159.11	33115.0
2013-04-30 07:30:00	SPY	ETF	159.11	159.16	159.05	159.11	83993.0
2013-04-30 08:00:00	SPY	ETF	159.09	159.16	159.05	159.16	242424.0
2013-04-30 08:30:00	SPY	ETF	159.14	159.28	159.12	159.25	345767.0
2013-04-30 09:00:00	SPY	ETF	159.25	159.3	159.15	159.26	581499.0
2013-04-30 09:30:00	SPY	ETF	159.27	159.37	158.77	158.8	14868050.0
2013-04-30 10:00:00	SPY	ETF	158.81	159.06	158.61	158.72	15770594.0
2013-04-30 10:30:00	SPY	ETF	158.725	159.21	158.63	159.15	8376523.0
2013-04-30 11:00:00	SPY	ETF	159.15	159.27	159.11	159.22	4898810.0
2013-04-30 11:30:00	SPY	ETF	159.22	159.55	159.2	159.45	7597100.0
2013-04-30 12:00:00	SPY	ETF	159.46	159.49	159.31	159.33	3768719.0
2013-04-30 12:30:00	SPY	ETF	159.33	159.64	159.3	159.615	4377611.0
2013-04-30 13:00:00	SPY	ETF	159.62	159.65	159.55	159.55	4601662.0
2013-04-30 13:30:00	SPY	ETF	159.55	159.67	159.5	159.66	2826630.0
2013-04-30 14:00:00	SPY	ETF	159.66	159.67	159.34	159.46	4773640.0
2013-04-30 14:30:00	SPY	ETF	159.46	159.6	159.32	159.6	5444213.0
2013-04-30 15:00:00	SPY	ETF	159.6	159.6	159.35	159.5	5348599.0
2013-04-30 15:30:00	SPY	ETF	159.495	159.72	159.46	159.7	19396992.0
2013-04-30 16:00:00	SPY	ETF	159.71	159.81	158.7129	159.76	9258491.0
2013-04-30 16:30:00	SPY	ETF	159.75	159.83	159.74	159.81	311842.0
2013-04-30 17:00:00	SPY	ETF	159.82	159.87	159.78	159.79	184708.0
2013-04-30 17:30:00	SPY	ETF	159.79	159.86	159.79	159.83	80062.0
2013-04-30 18:00:00	SPY	ETF	159.83	159.83	159.68	159.79	63065.0
2013-04-30 18:30:00	SPY	ETF	159.79	159.79	159.72	159.74	35942.0
2013-04-30 19:00:00	SPY	ETF	159.74	159.8	159.74	159.8	11377.0
2013-04-30 19:30:00	SPY	ETF	159.77	159.84	159.75	159.75	31816.0
2013-04-30 04:30:00	QQQ	ETF	70.19	70.19	70.19	70.19	5600.0
2013-04-30 05:00:00	QQQ	ETF	70.23	70.23	70.22	70.22	1700.0
2013-04-30 05:30:00	QQQ	ETF	70.22	70.22	70.19	70.19	1600.0
2013-04-30 06:30:00	QQQ	ETF	70.13	70.14	70.12	70.13	2200.0
2013-04-30 07:00:00	QQQ	ETF	70.16	70.16	70.16	70.16	3900.0
2013-04-30 07:30:00	QQQ	ETF	70.17	70.19	70.16	70.16	10695.0
2013-04-30 08:00:00	QQQ	ETF	70.17	70.18	70.13	70.17	33816.0
2013-04-30 08:30:00	QQQ	ETF	70.18	70.23	70.17	70.22	35195.0
2013-04-30 09:00:00	QQQ	ETF	70.22	70.3	70.19	70.3	128937.0
2013-04-30 09:30:00	QQQ	ETF	70.29	70.33	70.07	70.12	4608276.0
2013-04-30 10:00:00	QQQ	ETF	70.12	70.24	70.04	70.09	3066445.0
2013-04-30 10:30:00	QQQ	ETF	70.08	70.42	70.045	70.35	2595828.0
2013-04-30 11:00:00	QQQ	ETF	70.35	70.4637	70.32	70.43	1424328.0
2013-04-30 11:30:00	QQQ	ETF	70.43	70.54	70.4	70.49	1655755.0
2013-04-30 12:00:00	QQQ	ETF	70.49	70.51	70.43	70.4801	809237.0
2013-04-30 12:30:00	QQQ	ETF	70.485	70.69	70.48	70.67	2212270.0
2013-04-30 13:00:00	QQQ	ETF	70.67	70.73	70.66	70.67	855925.0
2013-04-30 13:30:00	QQQ	ETF	70.68	70.72	70.62	70.69	856522.0
2013-04-30 14:00:00	QQQ	ETF	70.69	70.7	70.54	70.629	901495.0

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

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