PREVIEW / etf_30min / 2017-05-31

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-31.parquet
  size:    427 KB
  rows:    14,648

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
2017-05-31 04:00:00	SPY	ETF	241.66	241.66	241.53	241.56	500.0
2017-05-31 05:00:00	SPY	ETF	241.43	241.43	241.42	241.42	200.0
2017-05-31 05:30:00	SPY	ETF	241.52	241.52	241.52	241.52	300.0
2017-05-31 06:00:00	SPY	ETF	241.54	241.54	241.54	241.54	800.0
2017-05-31 06:30:00	SPY	ETF	241.62	241.71	241.62	241.69	11300.0
2017-05-31 07:00:00	SPY	ETF	241.74	241.8	241.7	241.75	56514.0
2017-05-31 07:30:00	SPY	ETF	241.75	241.93	241.75	241.86	155446.0
2017-05-31 08:00:00	SPY	ETF	241.85	242.04	241.73	242.0	354692.0
2017-05-31 08:30:00	SPY	ETF	242.01	242.01	241.88	241.95	249219.0
2017-05-31 09:00:00	SPY	ETF	241.95	241.99	241.83	241.83	287696.0
2017-05-31 09:30:00	SPY	ETF	241.84	241.88	240.91	240.97	6177131.0
2017-05-31 10:00:00	SPY	ETF	240.98	241.02	240.64	240.96	7289463.0
2017-05-31 10:30:00	SPY	ETF	240.96	241.38	240.85	241.35	5199063.0
2017-05-31 11:00:00	SPY	ETF	241.35	241.4	240.95	241.07	4713336.0
2017-05-31 11:30:00	SPY	ETF	241.07	241.13	240.79	241.09	4120588.0
2017-05-31 12:00:00	SPY	ETF	241.09	241.28	241.05	241.09	2117758.0
2017-05-31 12:30:00	SPY	ETF	241.09	241.15	240.96	241.005	1215272.0
2017-05-31 13:00:00	SPY	ETF	241.005	241.32	240.98	241.04	2866107.0
2017-05-31 13:30:00	SPY	ETF	241.03	241.13	240.93	241.02	2318363.0
2017-05-31 14:00:00	SPY	ETF	241.02	241.12	240.77	241.11	3045795.0
2017-05-31 14:30:00	SPY	ETF	241.105	241.25	241.04	241.085	5384244.0
2017-05-31 15:00:00	SPY	ETF	241.095	241.385	241.02	241.32	5750360.0
2017-05-31 15:30:00	SPY	ETF	241.315	241.52	241.31	241.42	15629952.0
2017-05-31 16:00:00	SPY	ETF	241.43	241.82	241.41	241.71	18326471.0
2017-05-31 16:30:00	SPY	ETF	241.71	241.84	241.3903	241.79	1404000.0
2017-05-31 17:00:00	SPY	ETF	241.76	241.77	241.39	241.73	2260582.0
2017-05-31 17:30:00	SPY	ETF	241.72	241.73	241.44	241.65	992003.0
2017-05-31 18:00:00	SPY	ETF	241.65	241.74	241.63	241.67	223273.0
2017-05-31 18:30:00	SPY	ETF	241.66	241.66	241.6	241.61	28757.0
2017-05-31 19:00:00	SPY	ETF	241.61	241.65	241.6	241.63	47494.0
2017-05-31 19:30:00	SPY	ETF	241.62	241.66	241.56	241.57	57926.0
2017-05-31 04:00:00	QQQ	ETF	141.31	141.43	141.31	141.4	1020.0
2017-05-31 04:30:00	QQQ	ETF	141.39	141.39	141.39	141.39	500.0
2017-05-31 05:00:00	QQQ	ETF	141.36	141.36	141.36	141.36	200.0
2017-05-31 05:30:00	QQQ	ETF	141.4	141.4	141.4	141.4	200.0
2017-05-31 06:30:00	QQQ	ETF	141.45	141.56	141.45	141.56	2310.0
2017-05-31 07:00:00	QQQ	ETF	141.56	141.65	141.56	141.61	75378.0
2017-05-31 07:30:00	QQQ	ETF	141.61	141.74	141.61	141.71	110186.0
2017-05-31 08:00:00	QQQ	ETF	141.64	141.91	141.61	141.88	205434.0
2017-05-31 08:30:00	QQQ	ETF	141.86	141.86	141.8	141.83	93828.0
2017-05-31 09:00:00	QQQ	ETF	141.83	141.91	141.77	141.77	59739.0
2017-05-31 09:30:00	QQQ	ETF	141.78	141.84	140.88	140.9101	5725593.0
2017-05-31 10:00:00	QQQ	ETF	140.91	140.93	140.57	140.87	3825741.0
2017-05-31 10:30:00	QQQ	ETF	140.87	141.196	140.77	141.16	1627741.0
2017-05-31 11:00:00	QQQ	ETF	141.15	141.26	140.98	141.06	1558227.0
2017-05-31 11:30:00	QQQ	ETF	141.07	141.15	140.87	141.12	972736.0
2017-05-31 12:00:00	QQQ	ETF	141.1264	141.245	141.05	141.08	896499.0
2017-05-31 12:30:00	QQQ	ETF	141.08	141.14	140.93	140.9499	567054.0
2017-05-31 13:00:00	QQQ	ETF	140.95	141.195	140.95	141.0542	739340.0
2017-05-31 13:30:00	QQQ	ETF	141.041	141.11	140.98	141.03	766909.0

> showing 50 of 14,648 rows — these rows as CSV

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