PREVIEW / etf_30min / 2017-07-06

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-06.parquet
  size:    431 KB
  rows:    15,025

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-07-06 04:00:00	SPY	ETF	242.31	242.38	242.3	242.32	759.0
2017-07-06 04:30:00	SPY	ETF	242.34	242.34	242.3	242.3	700.0
2017-07-06 05:00:00	SPY	ETF	242.18	242.2	241.9	241.9	11767.0
2017-07-06 05:30:00	SPY	ETF	241.91	241.91	241.78	241.81	5306.0
2017-07-06 06:00:00	SPY	ETF	241.81	241.81	241.44	241.5	9563.0
2017-07-06 06:30:00	SPY	ETF	241.57	241.77	241.51	241.77	79117.0
2017-07-06 07:00:00	SPY	ETF	241.8	241.8	241.61	241.74	163885.0
2017-07-06 07:30:00	SPY	ETF	241.79	241.8	241.44	241.52	241857.0
2017-07-06 08:00:00	SPY	ETF	241.56	241.83	241.5	241.77	263867.0
2017-07-06 08:30:00	SPY	ETF	241.77	241.89	241.67	241.85	254249.0
2017-07-06 09:00:00	SPY	ETF	241.86	242.0	241.84	241.87	576048.0
2017-07-06 09:30:00	SPY	ETF	241.89	242.03	241.23	241.3	7299046.0
2017-07-06 10:00:00	SPY	ETF	241.3	241.49	240.84	241.19	6877262.0
2017-07-06 10:30:00	SPY	ETF	241.19	241.39	241.0201	241.24	3175707.0
2017-07-06 11:00:00	SPY	ETF	241.235	241.67	241.23	241.51	3493313.0
2017-07-06 11:30:00	SPY	ETF	241.51	241.75	241.48	241.72	2242435.0
2017-07-06 12:00:00	SPY	ETF	241.71	241.8	241.38	241.43	1526222.0
2017-07-06 12:30:00	SPY	ETF	241.42	241.77	241.39	241.655	1935422.0
2017-07-06 13:00:00	SPY	ETF	241.65	241.95	241.6	241.85	1986878.0
2017-07-06 13:30:00	SPY	ETF	241.85	241.8599	241.3	241.38	2490466.0
2017-07-06 14:00:00	SPY	ETF	241.38	241.38	240.95	241.15	3086399.0
2017-07-06 14:30:00	SPY	ETF	241.15	241.15	240.85	241.11	3874134.0
2017-07-06 15:00:00	SPY	ETF	241.11	241.36	240.62	240.625	4188063.0
2017-07-06 15:30:00	SPY	ETF	240.63	240.72	240.34	240.58	12945796.0
2017-07-06 16:00:00	SPY	ETF	240.57	240.76	240.55	240.6	6679088.0
2017-07-06 16:30:00	SPY	ETF	240.62	241.626	240.55	240.66	401919.0
2017-07-06 17:00:00	SPY	ETF	240.66	240.66	240.63	240.64	16522.0
2017-07-06 17:30:00	SPY	ETF	240.64	240.68	240.6	240.67	67246.0
2017-07-06 18:00:00	SPY	ETF	240.68	240.8	240.68	240.74	78540.0
2017-07-06 18:30:00	SPY	ETF	240.74	240.84	240.74	240.81	6706.0
2017-07-06 19:00:00	SPY	ETF	240.79	240.82	240.78	240.81	6096.0
2017-07-06 19:30:00	SPY	ETF	240.81	240.81	240.69	240.71	19838.0
2017-07-06 04:00:00	QQQ	ETF	137.28	137.28	137.17	137.17	1013.0
2017-07-06 04:30:00	QQQ	ETF	137.15	137.17	137.15	137.17	1100.0
2017-07-06 05:00:00	QQQ	ETF	137.07	137.07	136.7	136.7	25096.0
2017-07-06 05:30:00	QQQ	ETF	136.71	136.76	136.59	136.61	5685.0
2017-07-06 06:00:00	QQQ	ETF	136.54	136.54	136.34	136.49	8703.0
2017-07-06 06:30:00	QQQ	ETF	136.5	136.64	136.41	136.62	38862.0
2017-07-06 07:00:00	QQQ	ETF	136.6	136.6	136.42	136.53	21548.0
2017-07-06 07:30:00	QQQ	ETF	136.58	136.58	136.11	136.2	157322.0
2017-07-06 08:00:00	QQQ	ETF	136.65	136.65	136.09	136.29	132734.0
2017-07-06 08:30:00	QQQ	ETF	136.3	136.56	136.27	136.46	151379.0
2017-07-06 09:00:00	QQQ	ETF	136.53	136.56	136.38	136.45	183514.0
2017-07-06 09:30:00	QQQ	ETF	136.45	136.78	136.05	136.32	6860368.0
2017-07-06 10:00:00	QQQ	ETF	136.27	136.43	135.8	136.0	5304116.0
2017-07-06 10:30:00	QQQ	ETF	136.0	136.23	135.84	136.18	2624000.0
2017-07-06 11:00:00	QQQ	ETF	136.18	136.5161	136.09	136.51	3627084.0
2017-07-06 11:30:00	QQQ	ETF	136.5	136.87	136.5	136.72	1943889.0
2017-07-06 12:00:00	QQQ	ETF	136.72	136.79	136.525	136.54	1139553.0
2017-07-06 12:30:00	QQQ	ETF	136.5441	137.06	136.54	136.926	1878353.0

> showing 50 of 15,025 rows — these rows as CSV

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