PREVIEW / etf_30min / 2013-07-09

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-09.parquet
  size:    318 KB
  rows:    10,937

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-07-09 04:00:00	SPY	ETF	164.86	164.92	164.84	164.9	36800.0
2013-07-09 04:30:00	SPY	ETF	164.88	164.88	164.73	164.8	18650.0
2013-07-09 05:00:00	SPY	ETF	164.73	164.8	164.73	164.74	11500.0
2013-07-09 05:30:00	SPY	ETF	164.77	164.8	164.66	164.66	8790.0
2013-07-09 06:00:00	SPY	ETF	164.68	164.7	164.6	164.61	30650.0
2013-07-09 06:30:00	SPY	ETF	164.65	164.65	164.4	164.5	12600.0
2013-07-09 07:00:00	SPY	ETF	164.5	164.62	164.5	164.6	57467.0
2013-07-09 07:30:00	SPY	ETF	164.62	164.72	164.58	164.65	205616.0
2013-07-09 08:00:00	SPY	ETF	164.65	164.67	164.45	164.65	351455.0
2013-07-09 08:30:00	SPY	ETF	164.66	164.92	164.64	164.89	431796.0
2013-07-09 09:00:00	SPY	ETF	164.89	165.09	163.94	164.97	1804021.0
2013-07-09 09:30:00	SPY	ETF	164.98	165.13	164.66	164.77	14644832.0
2013-07-09 10:00:00	SPY	ETF	164.77	164.77	164.29	164.351	13380205.0
2013-07-09 10:30:00	SPY	ETF	164.351	164.78	164.27	164.755	9443085.0
2013-07-09 11:00:00	SPY	ETF	164.755	164.94	164.735	164.9	10649847.0
2013-07-09 11:30:00	SPY	ETF	164.9	165.06	164.83	164.9	7532741.0
2013-07-09 12:00:00	SPY	ETF	164.9	165.04	164.87	165.02	3054563.0
2013-07-09 12:30:00	SPY	ETF	165.01	165.2	164.99	165.17	6155449.0
2013-07-09 13:00:00	SPY	ETF	165.18	165.27	165.07	165.08	4012392.0
2013-07-09 13:30:00	SPY	ETF	165.08	165.18	164.94	165.14	7237410.0
2013-07-09 14:00:00	SPY	ETF	165.14	165.33	165.1	165.265	5118433.0
2013-07-09 14:30:00	SPY	ETF	165.27	165.29	165.03	165.08	4236985.0
2013-07-09 15:00:00	SPY	ETF	165.07	165.32	165.05	165.24	7547481.0
2013-07-09 15:30:00	SPY	ETF	165.24	165.33	164.96	165.09	14351848.0
2013-07-09 16:00:00	SPY	ETF	165.08	165.255	163.9426	165.04	7223989.0
2013-07-09 16:30:00	SPY	ETF	165.04	165.04	164.97	165.03	270327.0
2013-07-09 17:00:00	SPY	ETF	165.04	165.14	165.03	165.14	270608.0
2013-07-09 17:30:00	SPY	ETF	165.15	165.19	165.13	165.15	46638.0
2013-07-09 18:00:00	SPY	ETF	165.15	165.19	165.15	165.18	44489.0
2013-07-09 18:30:00	SPY	ETF	165.18	165.18	165.11	165.15	14835.0
2013-07-09 19:00:00	SPY	ETF	165.15	165.16	165.11	165.13	12350.0
2013-07-09 19:30:00	SPY	ETF	165.16	165.16	165.11	165.11	14859.0
2013-07-09 04:00:00	QQQ	ETF	72.99	73.03	72.99	73.03	10700.0
2013-07-09 04:30:00	QQQ	ETF	73.0	73.0	72.94	72.94	2400.0
2013-07-09 05:30:00	QQQ	ETF	72.91	72.91	72.91	72.91	800.0
2013-07-09 06:00:00	QQQ	ETF	72.88	72.91	72.88	72.88	2800.0
2013-07-09 06:30:00	QQQ	ETF	72.85	72.87	72.8	72.8	6075.0
2013-07-09 07:00:00	QQQ	ETF	72.85	72.88	72.84	72.84	5200.0
2013-07-09 07:30:00	QQQ	ETF	72.88	72.88	72.88	72.88	1300.0
2013-07-09 08:00:00	QQQ	ETF	72.85	72.88	72.85	72.88	17200.0
2013-07-09 08:30:00	QQQ	ETF	72.88	73.01	72.88	72.99	33238.0
2013-07-09 09:00:00	QQQ	ETF	73.02	73.06	72.97	72.99	131149.0
2013-07-09 09:30:00	QQQ	ETF	72.99	73.05	72.75	72.81	3957115.0
2013-07-09 10:00:00	QQQ	ETF	72.8	72.83	72.65	72.7	2644054.0
2013-07-09 10:30:00	QQQ	ETF	72.7	72.935	72.68	72.9192	1937534.0
2013-07-09 11:00:00	QQQ	ETF	72.92	73.05	72.89	73.05	1657446.0
2013-07-09 11:30:00	QQQ	ETF	73.04	73.1	72.97	72.99	1755803.0
2013-07-09 12:00:00	QQQ	ETF	72.99	73.04	72.95	73.01	961917.0
2013-07-09 12:30:00	QQQ	ETF	73.01	73.12	73.0099	73.1	1085578.0
2013-07-09 13:00:00	QQQ	ETF	73.0987	73.14	73.02	73.0379	535945.0

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

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