PREVIEW / etf_30min / 2013-11-20

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-20.parquet
  size:    332 KB
  rows:    11,028

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-20 04:00:00	SPY	ETF	179.1	179.13	179.0	179.0	25780.0
2013-11-20 04:30:00	SPY	ETF	179.03	179.09	179.03	179.05	1467.0
2013-11-20 05:00:00	SPY	ETF	179.04	179.05	178.96	179.05	6100.0
2013-11-20 05:30:00	SPY	ETF	178.97	178.99	178.75	178.78	40984.0
2013-11-20 06:00:00	SPY	ETF	178.76	178.81	178.71	178.8	37950.0
2013-11-20 06:30:00	SPY	ETF	178.78	178.94	178.78	178.94	40119.0
2013-11-20 07:00:00	SPY	ETF	178.92	178.98	178.92	178.94	64331.0
2013-11-20 07:30:00	SPY	ETF	178.95	179.04	178.91	178.91	61354.0
2013-11-20 08:00:00	SPY	ETF	178.91	179.1	178.88	179.02	188223.0
2013-11-20 08:30:00	SPY	ETF	179.02	179.42	179.0	179.42	776572.0
2013-11-20 09:00:00	SPY	ETF	179.42	179.45	179.31	179.41	978569.0
2013-11-20 09:30:00	SPY	ETF	179.39	179.54	179.09	179.342	9556122.0
2013-11-20 10:00:00	SPY	ETF	179.35	179.93	179.1	179.62	10304117.0
2013-11-20 10:30:00	SPY	ETF	179.62	179.67	179.15	179.525	9377754.0
2013-11-20 11:00:00	SPY	ETF	179.53	179.6	179.31	179.51	4059142.0
2013-11-20 11:30:00	SPY	ETF	179.51	179.6	179.36	179.45	2897751.0
2013-11-20 12:00:00	SPY	ETF	179.45	179.6	179.4299	179.475	4086019.0
2013-11-20 12:30:00	SPY	ETF	179.485	179.52	179.32	179.32	2521153.0
2013-11-20 13:00:00	SPY	ETF	179.31	179.42	179.24	179.3	2253835.0
2013-11-20 13:30:00	SPY	ETF	179.31	179.479	179.3	179.37	2580623.0
2013-11-20 14:00:00	SPY	ETF	179.38	179.4	178.53	178.9499	22089924.0
2013-11-20 14:30:00	SPY	ETF	178.95	179.0	178.38	178.5703	11742655.0
2013-11-20 15:00:00	SPY	ETF	178.58	178.58	177.98	178.3278	14461804.0
2013-11-20 15:30:00	SPY	ETF	178.325	178.57	178.11	178.44	14621036.0
2013-11-20 16:00:00	SPY	ETF	178.45	179.51	178.1	178.5	5447206.0
2013-11-20 16:30:00	SPY	ETF	178.49	178.56	178.47	178.53	798210.0
2013-11-20 17:00:00	SPY	ETF	178.53	178.57	178.49	178.49	2994883.0
2013-11-20 17:30:00	SPY	ETF	178.48	178.53	178.46	178.48	35850.0
2013-11-20 18:00:00	SPY	ETF	178.49	178.55	178.4	178.48	74604.0
2013-11-20 18:30:00	SPY	ETF	178.48	178.51	178.47	178.48	10721.0
2013-11-20 19:00:00	SPY	ETF	178.49	178.49	178.38	178.39	25800.0
2013-11-20 19:30:00	SPY	ETF	178.41	178.54	178.41	178.51	64860.0
2013-11-20 04:30:00	QQQ	ETF	82.94	82.94	82.94	82.94	2600.0
2013-11-20 05:30:00	QQQ	ETF	82.82	82.82	82.77	82.78	9300.0
2013-11-20 06:00:00	QQQ	ETF	82.78	82.82	82.78	82.82	7600.0
2013-11-20 06:30:00	QQQ	ETF	82.87	82.87	82.87	82.87	6500.0
2013-11-20 07:00:00	QQQ	ETF	82.92	82.95	82.92	82.92	12048.0
2013-11-20 07:30:00	QQQ	ETF	82.97	82.97	82.92	82.92	8200.0
2013-11-20 08:00:00	QQQ	ETF	82.95	83.05	82.9	83.04	22495.0
2013-11-20 08:30:00	QQQ	ETF	83.02	83.17	83.02	83.16	212482.0
2013-11-20 09:00:00	QQQ	ETF	83.17	83.18	83.12	83.15	29151.0
2013-11-20 09:30:00	QQQ	ETF	83.14	83.34	82.97	83.11	3745110.0
2013-11-20 10:00:00	QQQ	ETF	83.11	83.4301	82.97	83.25	2719493.0
2013-11-20 10:30:00	QQQ	ETF	83.26	83.29	82.99	83.27	2331321.0
2013-11-20 11:00:00	QQQ	ETF	83.27	83.32	83.14	83.25	1237332.0
2013-11-20 11:30:00	QQQ	ETF	83.26	83.3474	83.22	83.23	667481.0
2013-11-20 12:00:00	QQQ	ETF	83.23	83.3399	83.23	83.25	675333.0
2013-11-20 12:30:00	QQQ	ETF	83.26	83.26	83.14	83.15	810142.0
2013-11-20 13:00:00	QQQ	ETF	83.14	83.2	83.07	83.115	790640.0
2013-11-20 13:30:00	QQQ	ETF	83.12	83.23	83.12	83.17	522131.0

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

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