PREVIEW / etf_30min / 2017-05-25

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-25.parquet
  size:    437 KB
  rows:    14,975

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-25 04:00:00	SPY	ETF	241.01	241.13	241.01	241.01	9162.0
2017-05-25 04:30:00	SPY	ETF	240.97	241.12	240.97	241.12	26200.0
2017-05-25 05:00:00	SPY	ETF	241.12	241.27	241.12	241.2	12945.0
2017-05-25 05:30:00	SPY	ETF	241.31	241.34	241.2	241.27	10275.0
2017-05-25 06:00:00	SPY	ETF	241.3	241.3	241.23	241.28	73640.0
2017-05-25 06:30:00	SPY	ETF	241.25	241.29	241.16	241.19	134655.0
2017-05-25 07:00:00	SPY	ETF	241.18	241.27	241.15	241.18	118645.0
2017-05-25 07:30:00	SPY	ETF	241.18	241.19	241.01	241.09	166900.0
2017-05-25 08:00:00	SPY	ETF	241.09	241.21	240.98	241.09	190564.0
2017-05-25 08:30:00	SPY	ETF	241.08	241.24	241.06	241.19	237320.0
2017-05-25 09:00:00	SPY	ETF	241.21	241.24	241.16	241.2	171946.0
2017-05-25 09:30:00	SPY	ETF	241.2	241.52	240.96	241.41	5950487.0
2017-05-25 10:00:00	SPY	ETF	241.415	241.68	241.35	241.61	5732615.0
2017-05-25 10:30:00	SPY	ETF	241.61	241.79	241.6	241.665	3232353.0
2017-05-25 11:00:00	SPY	ETF	241.659	241.96	241.65	241.84	7396405.0
2017-05-25 11:30:00	SPY	ETF	241.84	241.9	241.42	241.4592	4515097.0
2017-05-25 12:00:00	SPY	ETF	241.46	241.705	241.36	241.65	3102009.0
2017-05-25 12:30:00	SPY	ETF	241.6599	241.88	241.62	241.86	2404965.0
2017-05-25 13:00:00	SPY	ETF	241.87	241.88	241.67	241.695	2654063.0
2017-05-25 13:30:00	SPY	ETF	241.69	241.82	241.57	241.81	2016315.0
2017-05-25 14:00:00	SPY	ETF	241.81	241.875	241.7	241.79	1931168.0
2017-05-25 14:30:00	SPY	ETF	241.79	241.98	241.77	241.87	2503257.0
2017-05-25 15:00:00	SPY	ETF	241.87	241.92	241.72	241.755	2179330.0
2017-05-25 15:30:00	SPY	ETF	241.75	242.08	241.62	241.71	12037578.0
2017-05-25 16:00:00	SPY	ETF	241.7	241.82	239.8739	241.69	5325787.0
2017-05-25 16:30:00	SPY	ETF	241.68	241.71	241.58	241.67	290304.0
2017-05-25 17:00:00	SPY	ETF	241.66	241.66	241.6	241.63	55891.0
2017-05-25 17:30:00	SPY	ETF	241.63	241.76	241.6	241.65	28252.0
2017-05-25 18:00:00	SPY	ETF	241.66	241.7	241.61	241.66	26763.0
2017-05-25 18:30:00	SPY	ETF	241.65	241.65	241.5	241.57	52433.0
2017-05-25 19:00:00	SPY	ETF	241.56	241.58	241.55	241.56	6704.0
2017-05-25 19:30:00	SPY	ETF	241.57	241.64	241.56	241.62	14081.0
2017-05-25 04:00:00	QQQ	ETF	140.1	140.19	140.08	140.08	43720.0
2017-05-25 04:30:00	QQQ	ETF	140.06	140.06	140.06	140.06	5000.0
2017-05-25 05:00:00	QQQ	ETF	140.21	140.25	140.21	140.25	1900.0
2017-05-25 05:30:00	QQQ	ETF	140.26	140.26	140.25	140.25	1325.0
2017-05-25 06:00:00	QQQ	ETF	140.29	140.29	140.29	140.29	800.0
2017-05-25 06:30:00	QQQ	ETF	140.29	140.31	140.2	140.2	21400.0
2017-05-25 07:00:00	QQQ	ETF	140.25	140.29	140.22	140.27	131130.0
2017-05-25 07:30:00	QQQ	ETF	140.27	140.28	140.19	140.22	57299.0
2017-05-25 08:00:00	QQQ	ETF	140.22	140.27	140.19	140.27	66291.0
2017-05-25 08:30:00	QQQ	ETF	140.25	140.38	140.24	140.35	102938.0
2017-05-25 09:00:00	QQQ	ETF	140.35	140.36	140.31	140.31	63093.0
2017-05-25 09:30:00	QQQ	ETF	140.315	140.34	140.01	140.29	2911277.0
2017-05-25 10:00:00	QQQ	ETF	140.29	140.62	140.23	140.54	1856178.0
2017-05-25 10:30:00	QQQ	ETF	140.54	140.715	140.54	140.67	1174053.0
2017-05-25 11:00:00	QQQ	ETF	140.67	140.91	140.645	140.88	972449.0
2017-05-25 11:30:00	QQQ	ETF	140.88	140.935	140.65	140.78	844263.0
2017-05-25 12:00:00	QQQ	ETF	140.7801	141.005	140.74	140.955	813943.0
2017-05-25 12:30:00	QQQ	ETF	140.94	141.16	140.93	141.15	1375236.0

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

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