PREVIEW / etf_30min / 2013-09-03

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-03.parquet
  size:    322 KB
  rows:    10,880

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-09-03 04:00:00	SPY	ETF	165.36	165.43	165.3	165.38	67772.0
2013-09-03 04:30:00	SPY	ETF	165.34	165.34	164.84	164.92	34800.0
2013-09-03 05:00:00	SPY	ETF	164.9	165.24	164.84	165.14	56400.0
2013-09-03 05:30:00	SPY	ETF	165.1	165.1	164.9	164.92	18450.0
2013-09-03 06:00:00	SPY	ETF	164.9	165.23	164.9	165.23	40050.0
2013-09-03 06:30:00	SPY	ETF	165.24	165.28	165.18	165.2	67048.0
2013-09-03 07:00:00	SPY	ETF	165.19	165.28	165.1	165.14	138311.0
2013-09-03 07:30:00	SPY	ETF	165.13	165.13	164.9	165.07	249701.0
2013-09-03 08:00:00	SPY	ETF	165.26	165.43	164.97	165.04	569166.0
2013-09-03 08:30:00	SPY	ETF	165.05	165.26	164.9	165.2	471389.0
2013-09-03 09:00:00	SPY	ETF	165.21	165.27	163.65	165.25	821620.0
2013-09-03 09:30:00	SPY	ETF	165.23	165.58	165.17	165.26	13760302.0
2013-09-03 10:00:00	SPY	ETF	165.26	165.45	164.97	165.13	12499063.0
2013-09-03 10:30:00	SPY	ETF	165.12	165.36	165.05	165.07	6484925.0
2013-09-03 11:00:00	SPY	ETF	165.07	165.27	164.38	164.42	7713311.0
2013-09-03 11:30:00	SPY	ETF	164.42	164.5701	164.23	164.41	8865765.0
2013-09-03 12:00:00	SPY	ETF	164.42	164.56	164.24	164.36	6926932.0
2013-09-03 12:30:00	SPY	ETF	164.36	164.42	163.94	163.9816	7325077.0
2013-09-03 13:00:00	SPY	ETF	163.985	164.1401	163.81	164.1	6777471.0
2013-09-03 13:30:00	SPY	ETF	164.1	164.16	163.77	163.815	4740998.0
2013-09-03 14:00:00	SPY	ETF	163.85	164.16	163.73	163.96	6550927.0
2013-09-03 14:30:00	SPY	ETF	163.97	164.1	163.7	164.09	7267001.0
2013-09-03 15:00:00	SPY	ETF	164.08	164.5	164.03	164.29	8868928.0
2013-09-03 15:30:00	SPY	ETF	164.29	164.55	164.1	164.38	16490616.0
2013-09-03 16:00:00	SPY	ETF	164.38	164.59	163.7034	164.53	7103494.0
2013-09-03 16:30:00	SPY	ETF	164.54	164.55	163.7033	164.44	9390196.0
2013-09-03 17:00:00	SPY	ETF	164.45	164.47	164.35	164.35	130390.0
2013-09-03 17:30:00	SPY	ETF	164.37	164.42	164.35	164.4	9264.0
2013-09-03 18:00:00	SPY	ETF	164.4	164.4	164.21	164.34	28886.0
2013-09-03 18:30:00	SPY	ETF	164.3	164.34	164.28	164.34	4330.0
2013-09-03 19:00:00	SPY	ETF	164.33	164.35	164.33	164.34	1700.0
2013-09-03 19:30:00	SPY	ETF	164.35	164.39	164.29	164.35	9502.0
2013-09-03 04:00:00	QQQ	ETF	76.33	76.34	76.31	76.32	51750.0
2013-09-03 04:30:00	QQQ	ETF	76.3	76.3	75.98	76.0	32750.0
2013-09-03 05:00:00	QQQ	ETF	75.98	76.06	75.96	76.04	29500.0
2013-09-03 05:30:00	QQQ	ETF	76.02	76.04	75.94	75.94	11500.0
2013-09-03 06:00:00	QQQ	ETF	75.96	76.09	75.96	76.09	11700.0
2013-09-03 06:30:00	QQQ	ETF	76.1	76.14	76.06	76.07	16700.0
2013-09-03 07:00:00	QQQ	ETF	76.09	76.09	76.02	76.06	49045.0
2013-09-03 07:30:00	QQQ	ETF	76.01	76.01	75.94	75.97	27640.0
2013-09-03 08:00:00	QQQ	ETF	75.98	76.08	75.96	75.98	50960.0
2013-09-03 08:30:00	QQQ	ETF	75.98	76.09	75.97	76.08	74060.0
2013-09-03 09:00:00	QQQ	ETF	76.09	76.12	76.04	76.09	269677.0
2013-09-03 09:30:00	QQQ	ETF	76.1	76.41	76.08	76.3	4073692.0
2013-09-03 10:00:00	QQQ	ETF	76.31	76.44	76.12	76.21	3063493.0
2013-09-03 10:30:00	QQQ	ETF	76.21	76.4	76.18	76.28	1628242.0
2013-09-03 11:00:00	QQQ	ETF	76.29	76.42	75.98	76.0	2120292.0
2013-09-03 11:30:00	QQQ	ETF	76.01	76.04	75.89	75.98	1908500.0
2013-09-03 12:00:00	QQQ	ETF	75.97	76.1	75.88	75.96	1061842.0
2013-09-03 12:30:00	QQQ	ETF	75.96	76.01	75.741	75.751	977152.0

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

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