PREVIEW / etf_30min / 2012-08-09

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-09.parquet
  size:    274 KB
  rows:    9,233

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
2012-08-09 04:00:00	SPY	ETF	140.45	140.55	140.45	140.47	1130.0
2012-08-09 05:00:00	SPY	ETF	140.5	140.55	140.5	140.55	310.0
2012-08-09 05:30:00	SPY	ETF	140.55	140.57	140.55	140.57	200.0
2012-08-09 06:00:00	SPY	ETF	140.63	140.65	140.42	140.45	35700.0
2012-08-09 06:30:00	SPY	ETF	140.33	140.35	140.29	140.29	2730.0
2012-08-09 07:00:00	SPY	ETF	140.25	140.4	140.15	140.22	80940.0
2012-08-09 07:30:00	SPY	ETF	140.22	140.24	140.0	140.21	124232.0
2012-08-09 08:00:00	SPY	ETF	140.21	140.38	140.1	140.37	1894891.0
2012-08-09 08:30:00	SPY	ETF	140.35	140.45	140.16	140.31	842361.0
2012-08-09 09:00:00	SPY	ETF	140.32	140.34	140.15	140.29	673010.0
2012-08-09 09:30:00	SPY	ETF	140.29	140.75	140.25	140.46	11705163.0
2012-08-09 10:00:00	SPY	ETF	140.46	140.82	140.46	140.63	6825090.0
2012-08-09 10:30:00	SPY	ETF	140.64	140.89	140.61	140.8	6067772.0
2012-08-09 11:00:00	SPY	ETF	140.8	140.825	140.58	140.64	6626815.0
2012-08-09 11:30:00	SPY	ETF	140.64	140.69	140.15	140.2604	8553722.0
2012-08-09 12:00:00	SPY	ETF	140.27	140.4	140.2	140.33	6311259.0
2012-08-09 12:30:00	SPY	ETF	140.32	140.65	140.3	140.65	5462272.0
2012-08-09 13:00:00	SPY	ETF	140.65	140.71	140.51	140.57	4375458.0
2012-08-09 13:30:00	SPY	ETF	140.56	140.63	140.51	140.55	2754982.0
2012-08-09 14:00:00	SPY	ETF	140.5509	140.64	140.51	140.6205	3220511.0
2012-08-09 14:30:00	SPY	ETF	140.62	140.78	140.62	140.6701	4540125.0
2012-08-09 15:00:00	SPY	ETF	140.67	140.73	140.55	140.6584	3593019.0
2012-08-09 15:30:00	SPY	ETF	140.65	140.71	140.45	140.58	8804303.0
2012-08-09 16:00:00	SPY	ETF	140.61	140.72	140.56	140.62	2229825.0
2012-08-09 16:30:00	SPY	ETF	140.63	140.69	140.4	140.63	92758.0
2012-08-09 17:00:00	SPY	ETF	140.64	140.64	140.51	140.51	135685.0
2012-08-09 17:30:00	SPY	ETF	140.56	140.58	140.54	140.54	4420587.0
2012-08-09 18:00:00	SPY	ETF	140.57	140.6	140.54	140.58	16845.0
2012-08-09 18:30:00	SPY	ETF	140.58	140.66	140.56	140.66	17200.0
2012-08-09 19:00:00	SPY	ETF	140.66	140.66	140.54	140.55	39550.0
2012-08-09 19:30:00	SPY	ETF	140.55	140.55	140.5	140.53	123219.0
2012-08-09 06:30:00	QQQ	ETF	66.59	66.59	66.59	66.59	100.0
2012-08-09 07:00:00	QQQ	ETF	66.58	66.63	66.55	66.56	6300.0
2012-08-09 07:30:00	QQQ	ETF	66.55	66.57	66.46	66.57	19925.0
2012-08-09 08:00:00	QQQ	ETF	66.55	66.73	66.49	66.65	136489.0
2012-08-09 08:30:00	QQQ	ETF	66.57	66.67	66.54	66.63	572302.0
2012-08-09 09:00:00	QQQ	ETF	66.64	66.64	66.57	66.63	76028.0
2012-08-09 09:30:00	QQQ	ETF	66.62	66.88	66.61	66.76	2159591.0
2012-08-09 10:00:00	QQQ	ETF	66.77	66.9	66.75	66.81	1902651.0
2012-08-09 10:30:00	QQQ	ETF	66.82	66.91	66.81	66.8499	1188743.0
2012-08-09 11:00:00	QQQ	ETF	66.85	66.86	66.73	66.77	945793.0
2012-08-09 11:30:00	QQQ	ETF	66.76	66.79	66.49	66.56	2177957.0
2012-08-09 12:00:00	QQQ	ETF	66.56	66.67	66.52	66.601	2081824.0
2012-08-09 12:30:00	QQQ	ETF	66.61	66.728	66.6	66.728	1054134.0
2012-08-09 13:00:00	QQQ	ETF	66.72	66.75	66.67	66.72	779575.0
2012-08-09 13:30:00	QQQ	ETF	66.72	66.76	66.68	66.72	387030.0
2012-08-09 14:00:00	QQQ	ETF	66.72	66.78	66.69	66.77	475641.0
2012-08-09 14:30:00	QQQ	ETF	66.77	66.82	66.75	66.77	746511.0
2012-08-09 15:00:00	QQQ	ETF	66.77	66.81	66.7	66.79	1767898.0
2012-08-09 15:30:00	QQQ	ETF	66.7957	66.815	66.7	66.79	3490305.0

> showing 50 of 9,233 rows — these rows as CSV

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