PREVIEW / etf_30min / 2013-04-22

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-22.parquet
  size:    308 KB
  rows:    10,384

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-22 04:00:00	SPY	ETF	155.69	155.82	155.65	155.81	6524.0
2013-04-22 04:30:00	SPY	ETF	155.84	156.01	155.84	156.0	5000.0
2013-04-22 05:00:00	SPY	ETF	156.04	156.15	156.03	156.06	77200.0
2013-04-22 05:30:00	SPY	ETF	156.06	156.12	156.06	156.12	69340.0
2013-04-22 06:00:00	SPY	ETF	156.12	156.14	156.01	156.09	551645.0
2013-04-22 06:30:00	SPY	ETF	156.04	156.15	156.01	156.07	36703.0
2013-04-22 07:00:00	SPY	ETF	156.09	156.11	156.02	156.05	224667.0
2013-04-22 07:30:00	SPY	ETF	156.03	156.03	155.78	155.82	430010.0
2013-04-22 08:00:00	SPY	ETF	155.82	156.08	155.55	155.94	213457.0
2013-04-22 08:30:00	SPY	ETF	155.94	155.94	155.6	155.69	363352.0
2013-04-22 09:00:00	SPY	ETF	155.68	155.89	155.53	155.78	454921.0
2013-04-22 09:30:00	SPY	ETF	155.78	155.99	155.19	155.54	14028378.0
2013-04-22 10:00:00	SPY	ETF	155.53	155.56	154.83	155.03	15907354.0
2013-04-22 10:30:00	SPY	ETF	155.02	155.31	154.75	155.26	9711770.0
2013-04-22 11:00:00	SPY	ETF	155.26	155.32	155.05	155.18	4745292.0
2013-04-22 11:30:00	SPY	ETF	155.18	155.65	155.16	155.56	5709250.0
2013-04-22 12:00:00	SPY	ETF	155.56	155.83	155.56	155.73	3658566.0
2013-04-22 12:30:00	SPY	ETF	155.732	156.0	155.682	155.8	3517513.0
2013-04-22 13:00:00	SPY	ETF	155.809	155.835	155.7	155.81	3069348.0
2013-04-22 13:30:00	SPY	ETF	155.82	155.99	155.76	155.82	5927235.0
2013-04-22 14:00:00	SPY	ETF	155.81	156.39	155.81	156.31	6263422.0
2013-04-22 14:30:00	SPY	ETF	156.31	156.54	156.28	156.29	5420222.0
2013-04-22 15:00:00	SPY	ETF	156.29	156.39	156.24	156.31	3714135.0
2013-04-22 15:30:00	SPY	ETF	156.3	156.43	156.12	156.18	9818814.0
2013-04-22 16:00:00	SPY	ETF	156.18	156.24	155.8793	156.1	6057497.0
2013-04-22 16:30:00	SPY	ETF	156.1	156.27	156.1	156.26	298747.0
2013-04-22 17:00:00	SPY	ETF	156.25	156.3	156.22	156.23	167754.0
2013-04-22 17:30:00	SPY	ETF	156.23	156.25	156.21	156.25	4790.0
2013-04-22 18:00:00	SPY	ETF	156.2	156.2	156.06	156.11	43069.0
2013-04-22 18:30:00	SPY	ETF	156.11	156.11	156.08	156.08	19350.0
2013-04-22 19:00:00	SPY	ETF	156.08	156.08	156.05	156.07	3205.0
2013-04-22 19:30:00	SPY	ETF	156.07	156.08	156.0	156.03	27290.0
2013-04-22 04:00:00	QQQ	ETF	68.24	68.28	68.24	68.28	498.0
2013-04-22 04:30:00	QQQ	ETF	68.28	68.39	68.28	68.39	850.0
2013-04-22 05:00:00	QQQ	ETF	68.42	68.47	68.42	68.47	500.0
2013-04-22 06:00:00	QQQ	ETF	68.48	68.48	68.43	68.43	1600.0
2013-04-22 07:00:00	QQQ	ETF	68.43	68.46	68.43	68.44	3460.0
2013-04-22 07:30:00	QQQ	ETF	68.4	68.4	68.27	68.32	21582.0
2013-04-22 08:00:00	QQQ	ETF	68.33	68.38	68.18	68.38	68305.0
2013-04-22 08:30:00	QQQ	ETF	68.38	68.39	68.19	68.22	68690.0
2013-04-22 09:00:00	QQQ	ETF	68.21	68.43	68.17	68.33	223026.0
2013-04-22 09:30:00	QQQ	ETF	68.33	68.57	68.215	68.49	4923597.0
2013-04-22 10:00:00	QQQ	ETF	68.49	68.5	68.095	68.24	4028208.0
2013-04-22 10:30:00	QQQ	ETF	68.23	68.39	68.08	68.35	1904904.0
2013-04-22 11:00:00	QQQ	ETF	68.36	68.39	68.279	68.35	1173252.0
2013-04-22 11:30:00	QQQ	ETF	68.36	68.55	68.33	68.5	2047773.0
2013-04-22 12:00:00	QQQ	ETF	68.51	68.73	68.49	68.65	1749884.0
2013-04-22 12:30:00	QQQ	ETF	68.6401	68.75	68.6299	68.64	569499.0
2013-04-22 13:00:00	QQQ	ETF	68.64	68.66	68.57	68.61	521465.0
2013-04-22 13:30:00	QQQ	ETF	68.62	68.74	68.61	68.62	1301656.0

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

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