PREVIEW / etf_30min / 2015-04-22

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-22.parquet
  size:    377 KB
  rows:    12,667

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
2015-04-22 04:00:00	SPY	ETF	209.82	209.82	208.72	209.12	53146.0
2015-04-22 04:30:00	SPY	ETF	208.9	209.06	208.76	208.83	7130.0
2015-04-22 05:00:00	SPY	ETF	208.81	208.96	208.59	208.86	31898.0
2015-04-22 05:30:00	SPY	ETF	208.9	209.19	208.9	209.13	14211.0
2015-04-22 06:00:00	SPY	ETF	209.01	209.01	208.54	208.97	53002.0
2015-04-22 06:30:00	SPY	ETF	208.93	208.96	208.83	208.94	55886.0
2015-04-22 07:00:00	SPY	ETF	208.97	209.21	208.95	209.15	131653.0
2015-04-22 07:30:00	SPY	ETF	209.21	209.28	209.1	209.19	91005.0
2015-04-22 08:00:00	SPY	ETF	209.19	210.15	208.99	209.16	215384.0
2015-04-22 08:30:00	SPY	ETF	209.17	209.75	209.169	209.73	443312.0
2015-04-22 09:00:00	SPY	ETF	209.73	210.09	209.73	210.04	789698.0
2015-04-22 09:30:00	SPY	ETF	210.01	210.1	209.28	209.535	9501638.0
2015-04-22 10:00:00	SPY	ETF	209.54	209.76	208.9	209.4	10238702.0
2015-04-22 10:30:00	SPY	ETF	209.39	210.16	209.28	210.08	8993452.0
2015-04-22 11:00:00	SPY	ETF	210.08	210.24	209.92	210.04	4092145.0
2015-04-22 11:30:00	SPY	ETF	210.035	210.22	209.925	210.21	2965086.0
2015-04-22 12:00:00	SPY	ETF	210.2099	210.22	209.91	210.16	2390450.0
2015-04-22 12:30:00	SPY	ETF	210.1601	210.37	210.08	210.26	3719537.0
2015-04-22 13:00:00	SPY	ETF	210.26	210.36	210.12	210.28	2017678.0
2015-04-22 13:30:00	SPY	ETF	210.27	210.67	210.2501	210.58	3606553.0
2015-04-22 14:00:00	SPY	ETF	210.59	210.77	210.53	210.64	4205559.0
2015-04-22 14:30:00	SPY	ETF	210.645	210.74	210.55	210.58	2609647.0
2015-04-22 15:00:00	SPY	ETF	210.59	210.85	210.59	210.8	5190495.0
2015-04-22 15:30:00	SPY	ETF	210.8	210.84	210.0753	210.64	11880615.0
2015-04-22 16:00:00	SPY	ETF	210.64	210.66	210.39	210.54	3309191.0
2015-04-22 16:30:00	SPY	ETF	210.53	210.66	210.0753	210.43	1051831.0
2015-04-22 17:00:00	SPY	ETF	210.46	210.47	210.39	210.43	45517.0
2015-04-22 17:30:00	SPY	ETF	210.431	210.48	210.431	210.45	60819.0
2015-04-22 18:00:00	SPY	ETF	210.45	210.56	210.44	210.54	66416.0
2015-04-22 18:30:00	SPY	ETF	210.53	210.55	210.46	210.54	68319.0
2015-04-22 19:00:00	SPY	ETF	210.55	210.58	210.54	210.54	6830.0
2015-04-22 19:30:00	SPY	ETF	210.58	210.58	210.51	210.54	20882.0
2015-04-22 20:00:00	SPY	ETF	210.6421	210.6421	210.6421	210.6421	59000.0
2015-04-22 04:00:00	QQQ	ETF	107.99	107.99	107.61	107.61	8400.0
2015-04-22 05:00:00	QQQ	ETF	107.43	107.63	107.42	107.63	400.0
2015-04-22 05:30:00	QQQ	ETF	107.68	107.72	107.68	107.72	300.0
2015-04-22 06:00:00	QQQ	ETF	107.57	107.63	107.45	107.51	9000.0
2015-04-22 06:30:00	QQQ	ETF	107.68	107.72	107.66	107.72	23800.0
2015-04-22 07:00:00	QQQ	ETF	107.78	107.91	107.78	107.91	17710.0
2015-04-22 07:30:00	QQQ	ETF	107.92	107.96	107.88	107.9	48882.0
2015-04-22 08:00:00	QQQ	ETF	107.92	107.93	107.89	107.89	10310.0
2015-04-22 08:30:00	QQQ	ETF	107.9	108.24	107.9	108.23	86622.0
2015-04-22 09:00:00	QQQ	ETF	108.25	108.39	108.25	108.34	107388.0
2015-04-22 09:30:00	QQQ	ETF	108.34	108.42	107.88	108.0249	2709171.0
2015-04-22 10:00:00	QQQ	ETF	108.03	108.1	107.64	107.88	2254613.0
2015-04-22 10:30:00	QQQ	ETF	107.88	108.22	107.78	108.198	1753598.0
2015-04-22 11:00:00	QQQ	ETF	108.195	108.38	108.16	108.24	1150756.0
2015-04-22 11:30:00	QQQ	ETF	108.24	108.369	108.2	108.369	754296.0
2015-04-22 12:00:00	QQQ	ETF	108.36	108.37	108.21	108.35	425727.0
2015-04-22 12:30:00	QQQ	ETF	108.35	108.41	108.3	108.35	486831.0

> showing 50 of 12,667 rows — these rows as CSV

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