PREVIEW / etf_30min / 2013-05-24

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-24.parquet
  size:    309 KB
  rows:    10,484

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-05-24 04:00:00	SPY	ETF	165.35	165.46	165.35	165.45	94430.0
2013-05-24 04:30:00	SPY	ETF	165.73	165.73	165.56	165.56	36000.0
2013-05-24 05:00:00	SPY	ETF	165.53	165.53	165.3	165.3	6100.0
2013-05-24 05:30:00	SPY	ETF	165.17	165.17	164.97	164.97	44600.0
2013-05-24 06:00:00	SPY	ETF	165.02	165.02	164.85	164.97	57350.0
2013-05-24 06:30:00	SPY	ETF	164.94	164.98	164.61	164.7	96120.0
2013-05-24 07:00:00	SPY	ETF	164.7	164.75	164.4	164.58	192142.0
2013-05-24 07:30:00	SPY	ETF	164.58	164.83	164.44	164.77	339731.0
2013-05-24 08:00:00	SPY	ETF	164.78	164.94	164.48	164.88	596100.0
2013-05-24 08:30:00	SPY	ETF	164.88	165.45	164.63	164.7	1644075.0
2013-05-24 09:00:00	SPY	ETF	164.7	164.7	164.38	164.46	1718244.0
2013-05-24 09:30:00	SPY	ETF	164.47	164.76	164.19	164.32	20673506.0
2013-05-24 10:00:00	SPY	ETF	164.32	164.34	163.98	164.26	13234185.0
2013-05-24 10:30:00	SPY	ETF	164.26	164.59	164.16	164.58	11654180.0
2013-05-24 11:00:00	SPY	ETF	164.58	164.76	164.35	164.48	9428196.0
2013-05-24 11:30:00	SPY	ETF	164.48	164.88	164.4	164.79	7003567.0
2013-05-24 12:00:00	SPY	ETF	164.8	165.3805	164.7302	164.885	7713347.0
2013-05-24 12:30:00	SPY	ETF	164.89	164.9	164.54	164.73	4585814.0
2013-05-24 13:00:00	SPY	ETF	164.735	165.12	164.72	165.1	5403444.0
2013-05-24 13:30:00	SPY	ETF	165.095	165.15	164.92	165.065	3824763.0
2013-05-24 14:00:00	SPY	ETF	165.065	165.3805	164.93	165.199	6416937.0
2013-05-24 14:30:00	SPY	ETF	165.195	165.23	165.02	165.14	5937544.0
2013-05-24 15:00:00	SPY	ETF	165.14	165.28	165.04	165.08	5582391.0
2013-05-24 15:30:00	SPY	ETF	165.08	165.33	164.82	165.32	16059227.0
2013-05-24 16:00:00	SPY	ETF	165.33	165.63	164.03	165.59	23984194.0
2013-05-24 16:30:00	SPY	ETF	165.59	165.62	165.33	165.53	2454810.0
2013-05-24 17:00:00	SPY	ETF	165.51	165.59	165.5	165.55	1197567.0
2013-05-24 17:30:00	SPY	ETF	165.53	165.55	165.3	165.37	215004.0
2013-05-24 18:00:00	SPY	ETF	165.38	165.45	165.38	165.41	10450.0
2013-05-24 18:30:00	SPY	ETF	165.42	165.44	165.4	165.44	2264.0
2013-05-24 19:00:00	SPY	ETF	165.43	165.45	165.39	165.4	9147.0
2013-05-24 19:30:00	SPY	ETF	165.44	165.47	165.39	165.41	24529.0
2013-05-24 05:00:00	QQQ	ETF	73.5	73.5	73.5	73.5	300.0
2013-05-24 05:30:00	QQQ	ETF	73.35	73.35	73.29	73.29	1300.0
2013-05-24 06:00:00	QQQ	ETF	73.2	73.2	73.18	73.18	2800.0
2013-05-24 06:30:00	QQQ	ETF	73.14	73.14	73.03	73.09	14400.0
2013-05-24 07:00:00	QQQ	ETF	73.08	73.08	72.95	73.05	27200.0
2013-05-24 07:30:00	QQQ	ETF	73.09	73.13	73.04	73.11	23130.0
2013-05-24 08:00:00	QQQ	ETF	73.13	73.18	73.11	73.18	9400.0
2013-05-24 08:30:00	QQQ	ETF	73.2	73.29	73.08	73.09	87866.0
2013-05-24 09:00:00	QQQ	ETF	73.08	73.11	72.94	72.97	171153.0
2013-05-24 09:30:00	QQQ	ETF	72.96	73.15	72.8775	72.95	3650632.0
2013-05-24 10:00:00	QQQ	ETF	72.94	72.9672	72.76	72.95	3445986.0
2013-05-24 10:30:00	QQQ	ETF	72.95	73.1	72.93	73.09	2597138.0
2013-05-24 11:00:00	QQQ	ETF	73.1	73.1625	73.0	73.02	2154054.0
2013-05-24 11:30:00	QQQ	ETF	73.01	73.2	72.98	73.18	1723701.0
2013-05-24 12:00:00	QQQ	ETF	73.185	73.26	73.1684	73.24	1419088.0
2013-05-24 12:30:00	QQQ	ETF	73.23	73.232	73.08	73.18	689979.0
2013-05-24 13:00:00	QQQ	ETF	73.175	73.32	73.175	73.297	730651.0
2013-05-24 13:30:00	QQQ	ETF	73.3	73.319	73.215	73.27	905166.0

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

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