PREVIEW / etf_30min / 2013-08-13

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-13.parquet
  size:    317 KB
  rows:    10,687

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-08-13 04:00:00	SPY	ETF	169.54	169.74	169.54	169.72	6700.0
2013-08-13 04:30:00	SPY	ETF	169.73	169.79	169.73	169.78	2600.0
2013-08-13 05:00:00	SPY	ETF	169.8	169.85	169.7	169.72	16800.0
2013-08-13 05:30:00	SPY	ETF	169.75	169.8	169.71	169.71	4106.0
2013-08-13 06:00:00	SPY	ETF	169.74	169.77	169.74	169.74	2100.0
2013-08-13 06:30:00	SPY	ETF	169.75	169.75	169.62	169.62	10100.0
2013-08-13 07:00:00	SPY	ETF	169.66	169.66	169.53	169.55	40337.0
2013-08-13 07:30:00	SPY	ETF	169.54	169.63	169.52	169.58	93971.0
2013-08-13 08:00:00	SPY	ETF	169.55	169.63	169.53	169.56	195942.0
2013-08-13 08:30:00	SPY	ETF	169.56	169.62	169.31	169.45	433333.0
2013-08-13 09:00:00	SPY	ETF	169.45	169.55	169.39	169.41	254948.0
2013-08-13 09:30:00	SPY	ETF	169.41	169.5	168.99	169.09	10022190.0
2013-08-13 10:00:00	SPY	ETF	169.09	169.1	168.41	168.67	11626506.0
2013-08-13 10:30:00	SPY	ETF	168.66	168.8642	168.48	168.64	6354064.0
2013-08-13 11:00:00	SPY	ETF	168.64	168.97	168.6	168.95	4130088.0
2013-08-13 11:30:00	SPY	ETF	168.96	169.09	168.94	168.94	3199475.0
2013-08-13 12:00:00	SPY	ETF	168.94	169.35	168.86	169.3299	3870748.0
2013-08-13 12:30:00	SPY	ETF	169.32	169.64	169.32	169.53	5298888.0
2013-08-13 13:00:00	SPY	ETF	169.535	169.9	169.49	169.81	4761587.0
2013-08-13 13:30:00	SPY	ETF	169.82	169.84	169.63	169.65	3300981.0
2013-08-13 14:00:00	SPY	ETF	169.65	169.8	169.61	169.74	2571280.0
2013-08-13 14:30:00	SPY	ETF	169.75	169.76	169.52	169.67	5639608.0
2013-08-13 15:00:00	SPY	ETF	169.665	169.83	169.59	169.77	3953437.0
2013-08-13 15:30:00	SPY	ETF	169.76	169.81	169.55	169.61	10294630.0
2013-08-13 16:00:00	SPY	ETF	169.61	169.72	169.2634	169.57	2986665.0
2013-08-13 16:30:00	SPY	ETF	169.56	169.6	169.55	169.55	120285.0
2013-08-13 17:00:00	SPY	ETF	169.55	169.58	169.55	169.56	12750.0
2013-08-13 17:30:00	SPY	ETF	169.58	169.58	169.2233	169.58	45676.0
2013-08-13 18:00:00	SPY	ETF	169.6	169.7	169.55	169.7	39704.0
2013-08-13 18:30:00	SPY	ETF	169.69	169.7	169.68	169.69	4250.0
2013-08-13 19:00:00	SPY	ETF	169.69	169.71	169.69	169.69	12730.0
2013-08-13 19:30:00	SPY	ETF	169.69	169.7	169.57	169.57	60530.0
2013-08-13 04:00:00	QQQ	ETF	76.81	76.92	76.81	76.92	11900.0
2013-08-13 04:30:00	QQQ	ETF	76.94	76.94	76.94	76.94	1000.0
2013-08-13 05:00:00	QQQ	ETF	76.96	76.98	76.94	76.94	4000.0
2013-08-13 05:30:00	QQQ	ETF	76.94	76.96	76.94	76.94	4299.0
2013-08-13 06:00:00	QQQ	ETF	76.96	76.96	76.94	76.96	3125.0
2013-08-13 06:30:00	QQQ	ETF	76.92	76.92	76.88	76.88	7200.0
2013-08-13 07:00:00	QQQ	ETF	76.87	76.88	76.84	76.85	8662.0
2013-08-13 07:30:00	QQQ	ETF	76.85	76.87	76.85	76.87	32200.0
2013-08-13 08:00:00	QQQ	ETF	76.85	76.87	76.8	76.8	47303.0
2013-08-13 08:30:00	QQQ	ETF	76.83	76.83	76.75	76.78	46263.0
2013-08-13 09:00:00	QQQ	ETF	76.78	76.84	76.74	76.77	78159.0
2013-08-13 09:30:00	QQQ	ETF	76.77	76.88	76.55	76.64	2636433.0
2013-08-13 10:00:00	QQQ	ETF	76.64	76.64	76.22	76.44	2613394.0
2013-08-13 10:30:00	QQQ	ETF	76.43	76.55	76.35	76.439	1392600.0
2013-08-13 11:00:00	QQQ	ETF	76.43	76.62	76.41	76.575	1058306.0
2013-08-13 11:30:00	QQQ	ETF	76.58	76.7	76.58	76.6095	861243.0
2013-08-13 12:00:00	QQQ	ETF	76.6	76.77	76.53	76.76	673783.0
2013-08-13 12:30:00	QQQ	ETF	76.77	76.94	76.77	76.86	1087520.0

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

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