PREVIEW / etf_30min / 2016-03-21

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-21.parquet
  size:    387 KB
  rows:    13,239

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
2016-03-21 04:00:00	SPY	ETF	203.84	204.1	203.56	203.87	6796.0
2016-03-21 04:30:00	SPY	ETF	203.84	204.2	203.84	204.05	2764.0
2016-03-21 05:00:00	SPY	ETF	204.0	204.5	204.0	204.38	23769.0
2016-03-21 05:30:00	SPY	ETF	204.45	204.9	204.45	204.57	21714.0
2016-03-21 06:00:00	SPY	ETF	204.66	204.72	204.45	204.48	17148.0
2016-03-21 06:30:00	SPY	ETF	204.5	204.58	204.44	204.5	20761.0
2016-03-21 07:00:00	SPY	ETF	204.39	204.41	204.26	204.41	27543.0
2016-03-21 07:30:00	SPY	ETF	204.39	204.53	204.37	204.45	17192.0
2016-03-21 08:00:00	SPY	ETF	204.46	204.48	203.94	204.03	281997.0
2016-03-21 08:30:00	SPY	ETF	203.99	204.13	203.87	204.07	251537.0
2016-03-21 09:00:00	SPY	ETF	204.09	204.17	204.0	204.09	459627.0
2016-03-21 09:30:00	SPY	ETF	204.07	204.66	204.05	204.52	6867207.0
2016-03-21 10:00:00	SPY	ETF	204.52	204.65	203.96	204.055	6150059.0
2016-03-21 10:30:00	SPY	ETF	204.06	204.28	203.8	203.93	5508077.0
2016-03-21 11:00:00	SPY	ETF	203.925	204.54	203.92	204.46	4007474.0
2016-03-21 11:30:00	SPY	ETF	204.46	204.63	204.325	204.39	2797484.0
2016-03-21 12:00:00	SPY	ETF	204.38	204.49	204.18	204.315	2744641.0
2016-03-21 12:30:00	SPY	ETF	204.32	204.43	204.16	204.37	3476170.0
2016-03-21 13:00:00	SPY	ETF	204.38	204.8	204.31	204.79	3100641.0
2016-03-21 13:30:00	SPY	ETF	204.78	204.79	204.5	204.685	3208878.0
2016-03-21 14:00:00	SPY	ETF	204.6825	204.89	204.56	204.81	3608248.0
2016-03-21 14:30:00	SPY	ETF	204.81	204.94	204.7	204.865	6225589.0
2016-03-21 15:00:00	SPY	ETF	204.865	204.88	204.66	204.71	7214540.0
2016-03-21 15:30:00	SPY	ETF	204.705	204.76	204.47	204.68	10027692.0
2016-03-21 16:00:00	SPY	ETF	204.67	204.79	204.6	204.76	2923576.0
2016-03-21 16:30:00	SPY	ETF	204.76	204.88	204.6895	204.83	1078942.0
2016-03-21 17:00:00	SPY	ETF	204.8	204.85	204.67	204.85	1006680.0
2016-03-21 17:30:00	SPY	ETF	204.84	204.85	204.69	204.83	47084.0
2016-03-21 18:00:00	SPY	ETF	204.81	204.87	204.77	204.81	52212.0
2016-03-21 18:30:00	SPY	ETF	204.75	204.79	204.73	204.75	46302.0
2016-03-21 19:00:00	SPY	ETF	204.74	204.74	204.55	204.66	43295.0
2016-03-21 19:30:00	SPY	ETF	204.66	204.74	204.64	204.74	60329.0
2016-03-21 04:00:00	QQQ	ETF	106.9	106.9	106.9	106.9	100.0
2016-03-21 04:30:00	QQQ	ETF	107.2	107.2	107.2	107.2	120.0
2016-03-21 05:30:00	QQQ	ETF	107.66	107.66	107.58	107.58	1500.0
2016-03-21 06:00:00	QQQ	ETF	107.5	107.52	107.44	107.44	1099.0
2016-03-21 06:30:00	QQQ	ETF	107.41	107.41	107.41	107.41	300.0
2016-03-21 07:00:00	QQQ	ETF	107.3	107.32	107.3	107.32	6525.0
2016-03-21 07:30:00	QQQ	ETF	107.38	107.38	107.37	107.38	5772.0
2016-03-21 08:00:00	QQQ	ETF	107.36	107.39	107.13	107.16	39150.0
2016-03-21 08:30:00	QQQ	ETF	107.15	107.18	107.08	107.17	24896.0
2016-03-21 09:00:00	QQQ	ETF	107.17	107.23	107.15	107.17	101910.0
2016-03-21 09:30:00	QQQ	ETF	107.16	107.68	107.16	107.58	2145823.0
2016-03-21 10:00:00	QQQ	ETF	107.58	107.67	107.19	107.235	1636691.0
2016-03-21 10:30:00	QQQ	ETF	107.24	107.37	107.12	107.2199	1378670.0
2016-03-21 11:00:00	QQQ	ETF	107.22	107.6	107.2	107.54	1103334.0
2016-03-21 11:30:00	QQQ	ETF	107.552	107.64	107.49	107.5539	883706.0
2016-03-21 12:00:00	QQQ	ETF	107.56	107.56	107.375	107.46	502106.0
2016-03-21 12:30:00	QQQ	ETF	107.47	107.5656	107.37	107.51	787592.0
2016-03-21 13:00:00	QQQ	ETF	107.51	107.79	107.45	107.77	705333.0

> showing 50 of 13,239 rows — these rows as CSV

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