PREVIEW / etf_30min / 2012-06-01

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-01.parquet
  size:    309 KB
  rows:    10,382

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-06-01 04:00:00	SPY	ETF	131.0	131.0	130.6	130.6	525.0
2012-06-01 04:30:00	SPY	ETF	130.4	130.43	130.17	130.17	2000.0
2012-06-01 05:00:00	SPY	ETF	130.15	130.15	129.84	130.05	13488.0
2012-06-01 05:30:00	SPY	ETF	130.08	130.08	129.87	129.94	22788.0
2012-06-01 06:00:00	SPY	ETF	129.99	129.99	129.75	129.85	30547.0
2012-06-01 06:30:00	SPY	ETF	129.87	130.08	129.84	130.01	132963.0
2012-06-01 07:00:00	SPY	ETF	130.0	130.21	129.92	130.15	276530.0
2012-06-01 07:30:00	SPY	ETF	130.14	130.17	129.91	130.0	459790.0
2012-06-01 08:00:00	SPY	ETF	130.0	130.86	129.75	130.0	2261312.0
2012-06-01 08:30:00	SPY	ETF	129.9	129.9	128.61	129.18	7381591.0
2012-06-01 09:00:00	SPY	ETF	129.17	131.49	128.93	129.41	4221033.0
2012-06-01 09:30:00	SPY	ETF	129.41	129.8599	129.11	129.26	28389185.0
2012-06-01 10:00:00	SPY	ETF	129.27	129.76	129.04	129.1575	23447775.0
2012-06-01 10:30:00	SPY	ETF	129.15	129.23	128.95	129.01	12505234.0
2012-06-01 11:00:00	SPY	ETF	129.01	129.09	128.74	129.0	13772895.0
2012-06-01 11:30:00	SPY	ETF	128.99	129.18	128.86	129.15	8670285.0
2012-06-01 12:00:00	SPY	ETF	129.15	129.32	128.85	128.92	8871080.0
2012-06-01 12:30:00	SPY	ETF	128.9175	129.02	128.77	128.87	7591438.0
2012-06-01 13:00:00	SPY	ETF	128.87	128.98	128.66	128.688	7657844.0
2012-06-01 13:30:00	SPY	ETF	128.68	128.851	128.41	128.54	14720715.0
2012-06-01 14:00:00	SPY	ETF	128.5375	131.5042	128.2	128.47	16124576.0
2012-06-01 14:30:00	SPY	ETF	128.47	128.8	128.35	128.41	12404563.0
2012-06-01 15:00:00	SPY	ETF	128.41	128.65	128.21	128.3199	12736774.0
2012-06-01 15:30:00	SPY	ETF	128.315	128.485	128.17	128.22	38713552.0
2012-06-01 16:00:00	SPY	ETF	128.22	131.5042	127.96	128.1	18961582.0
2012-06-01 16:30:00	SPY	ETF	128.1	128.12	128.0107	128.07	3327083.0
2012-06-01 17:00:00	SPY	ETF	128.08	128.24	128.08	128.2	326447.0
2012-06-01 17:30:00	SPY	ETF	128.2	129.0167	128.12	128.13	54674.0
2012-06-01 18:00:00	SPY	ETF	128.13	128.13	128.0	128.02	62243.0
2012-06-01 18:30:00	SPY	ETF	128.05	128.16	127.95	127.95	42566.0
2012-06-01 19:00:00	SPY	ETF	127.96	127.98	127.93	127.93	28035.0
2012-06-01 19:30:00	SPY	ETF	127.95	128.02	127.91	128.01	48594.0
2012-06-01 04:00:00	QQQ	ETF	61.59	61.59	61.59	61.59	100.0
2012-06-01 04:30:00	QQQ	ETF	61.64	61.64	61.5	61.5	1125.0
2012-06-01 05:30:00	QQQ	ETF	61.41	61.43	61.37	61.42	5200.0
2012-06-01 06:00:00	QQQ	ETF	61.39	61.39	61.38	61.38	1100.0
2012-06-01 06:30:00	QQQ	ETF	61.34	61.35	61.34	61.35	200.0
2012-06-01 07:00:00	QQQ	ETF	61.37	61.43	61.36	61.43	5700.0
2012-06-01 07:30:00	QQQ	ETF	61.43	61.43	61.32	61.39	30635.0
2012-06-01 08:00:00	QQQ	ETF	61.39	62.06	61.2	61.24	960459.0
2012-06-01 08:30:00	QQQ	ETF	61.21	61.35	60.68	60.98	1942904.0
2012-06-01 09:00:00	QQQ	ETF	60.96	61.09	60.86	60.97	2288781.0
2012-06-01 09:30:00	QQQ	ETF	60.97	61.32	60.89	61.09	8836418.0
2012-06-01 10:00:00	QQQ	ETF	61.09	61.28	60.92	60.9625	7812766.0
2012-06-01 10:30:00	QQQ	ETF	60.97	61.06	60.8376	60.9123	3988283.0
2012-06-01 11:00:00	QQQ	ETF	60.92	60.935	60.75	60.89	4312950.0
2012-06-01 11:30:00	QQQ	ETF	60.9	60.91	60.76	60.8301	2679648.0
2012-06-01 12:00:00	QQQ	ETF	60.83	60.9299	60.76	60.8	1790867.0
2012-06-01 12:30:00	QQQ	ETF	60.8097	60.835	60.74	60.75	1857783.0
2012-06-01 13:00:00	QQQ	ETF	60.75	60.79	60.63	60.64	2828315.0

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

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