PREVIEW / etf_30min / 2013-05-16

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-16.parquet
  size:    314 KB
  rows:    10,821

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-16 04:00:00	SPY	ETF	165.9	165.9	165.57	165.57	3185.0
2013-05-16 04:30:00	SPY	ETF	165.68	165.83	165.68	165.79	3300.0
2013-05-16 05:30:00	SPY	ETF	165.71	165.73	165.65	165.71	4800.0
2013-05-16 06:00:00	SPY	ETF	165.71	165.84	165.71	165.8	55290.0
2013-05-16 06:30:00	SPY	ETF	165.88	165.92	165.86	165.91	20490.0
2013-05-16 07:00:00	SPY	ETF	165.91	166.02	165.85	165.94	191258.0
2013-05-16 07:30:00	SPY	ETF	165.9	166.05	165.89	166.05	124434.0
2013-05-16 08:00:00	SPY	ETF	166.03	166.15	165.75	166.03	459308.0
2013-05-16 08:30:00	SPY	ETF	165.98	165.98	165.56	165.77	1375056.0
2013-05-16 09:00:00	SPY	ETF	165.76	165.78	165.65	165.76	758747.0
2013-05-16 09:30:00	SPY	ETF	165.78	166.27	165.76	166.15	11477500.0
2013-05-16 10:00:00	SPY	ETF	166.15	166.16	165.57	165.83	12091057.0
2013-05-16 10:30:00	SPY	ETF	165.82	166.14	165.75	165.95	7372328.0
2013-05-16 11:00:00	SPY	ETF	165.955	166.36	165.95	166.15	7166037.0
2013-05-16 11:30:00	SPY	ETF	166.16	166.35	166.14	166.17	4659993.0
2013-05-16 12:00:00	SPY	ETF	166.17	166.19	166.05	166.06	2864449.0
2013-05-16 12:30:00	SPY	ETF	166.06	166.12	165.95	166.0829	3003836.0
2013-05-16 13:00:00	SPY	ETF	166.0899	166.1528	165.95	165.99	5026660.0
2013-05-16 13:30:00	SPY	ETF	165.99	166.09	165.94	165.96	3950044.0
2013-05-16 14:00:00	SPY	ETF	165.97	166.27	165.96	166.1699	3383616.0
2013-05-16 14:30:00	SPY	ETF	166.17	166.18	165.74	165.74	4847302.0
2013-05-16 15:00:00	SPY	ETF	165.75	165.86	165.35	165.51	8777862.0
2013-05-16 15:30:00	SPY	ETF	165.51	165.53	165.09	165.31	21196897.0
2013-05-16 16:00:00	SPY	ETF	165.31	166.0	165.15	165.37	8484764.0
2013-05-16 16:30:00	SPY	ETF	165.37	165.5	165.3236	165.45	577495.0
2013-05-16 17:00:00	SPY	ETF	165.46	165.48	165.37	165.39	106163.0
2013-05-16 17:30:00	SPY	ETF	165.4	165.43	165.39	165.4	42524.0
2013-05-16 18:00:00	SPY	ETF	165.41	165.42	165.3236	165.39	80064.0
2013-05-16 18:30:00	SPY	ETF	165.41	165.42	165.41	165.41	5240.0
2013-05-16 19:00:00	SPY	ETF	165.42	165.48	165.39	165.45	20446.0
2013-05-16 19:30:00	SPY	ETF	165.42	165.46	165.4	165.46	27988.0
2013-05-16 05:00:00	QQQ	ETF	73.65	73.69	73.65	73.69	4500.0
2013-05-16 06:00:00	QQQ	ETF	73.63	73.63	73.63	73.63	300.0
2013-05-16 06:30:00	QQQ	ETF	73.67	73.73	73.67	73.73	4100.0
2013-05-16 07:00:00	QQQ	ETF	73.7	73.77	73.7	73.73	24750.0
2013-05-16 07:30:00	QQQ	ETF	73.73	73.84	73.73	73.82	132045.0
2013-05-16 08:00:00	QQQ	ETF	73.83	73.9	73.83	73.86	114622.0
2013-05-16 08:30:00	QQQ	ETF	73.86	73.86	73.71	73.8	115135.0
2013-05-16 09:00:00	QQQ	ETF	73.76	73.83	73.73	73.75	170335.0
2013-05-16 09:30:00	QQQ	ETF	73.76	73.98	73.71	73.93	2877561.0
2013-05-16 10:00:00	QQQ	ETF	73.93	73.93	73.67	73.73	4036141.0
2013-05-16 10:30:00	QQQ	ETF	73.74	73.89	73.7299	73.81	1483970.0
2013-05-16 11:00:00	QQQ	ETF	73.8151	73.96	73.81	73.89	955953.0
2013-05-16 11:30:00	QQQ	ETF	73.8901	74.02	73.8901	73.9699	858004.0
2013-05-16 12:00:00	QQQ	ETF	73.9625	73.969	73.81	73.82	1038752.0
2013-05-16 12:30:00	QQQ	ETF	73.83	73.9	73.8	73.87	512290.0
2013-05-16 13:00:00	QQQ	ETF	73.862	73.89	73.82	73.848	400550.0
2013-05-16 13:30:00	QQQ	ETF	73.85	73.92	73.84	73.85	568175.0
2013-05-16 14:00:00	QQQ	ETF	73.86	74.095	73.86	74.03	1812307.0
2013-05-16 14:30:00	QQQ	ETF	74.04	74.04	73.8	73.81	1241995.0

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

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