PREVIEW / etf_30min / 2017-04-17

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-17.parquet
  size:    426 KB
  rows:    14,576

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-04-17 04:00:00	SPY	ETF	232.5	232.51	232.46	232.46	1635.0
2017-04-17 04:30:00	SPY	ETF	232.51	232.51	232.4	232.4	705.0
2017-04-17 05:00:00	SPY	ETF	232.4	232.4	232.4	232.4	304.0
2017-04-17 06:00:00	SPY	ETF	232.5	232.5	232.5	232.5	400.0
2017-04-17 06:30:00	SPY	ETF	232.51	232.52	232.43	232.48	4690.0
2017-04-17 07:00:00	SPY	ETF	232.5	232.53	232.43	232.51	20572.0
2017-04-17 07:30:00	SPY	ETF	232.52	233.01	232.52	233.01	133877.0
2017-04-17 08:00:00	SPY	ETF	233.01	233.1	232.46	233.06	223144.0
2017-04-17 08:30:00	SPY	ETF	233.01	233.2	232.98	233.14	483833.0
2017-04-17 09:00:00	SPY	ETF	233.14	233.24	233.06	233.1	256867.0
2017-04-17 09:30:00	SPY	ETF	233.11	233.34	232.88	233.22	6531720.0
2017-04-17 10:00:00	SPY	ETF	233.23	233.77	233.21	233.5	5353883.0
2017-04-17 10:30:00	SPY	ETF	233.5	233.66	233.34	233.62	3198697.0
2017-04-17 11:00:00	SPY	ETF	233.63	233.84	233.565	233.84	2418017.0
2017-04-17 11:30:00	SPY	ETF	233.835	233.95	233.57	233.58	2649826.0
2017-04-17 12:00:00	SPY	ETF	233.575	233.93	233.57	233.81	2095937.0
2017-04-17 12:30:00	SPY	ETF	233.82	233.855	233.66	233.736	1326945.0
2017-04-17 13:00:00	SPY	ETF	233.73	233.97	233.7	233.9	1861792.0
2017-04-17 13:30:00	SPY	ETF	233.9	233.96	233.75	233.86	1893909.0
2017-04-17 14:00:00	SPY	ETF	233.87	233.99	233.8	233.86	3423256.0
2017-04-17 14:30:00	SPY	ETF	233.8699	234.09	233.78	233.87	3128585.0
2017-04-17 15:00:00	SPY	ETF	233.86	234.455	233.81	234.38	4558457.0
2017-04-17 15:30:00	SPY	ETF	234.37	234.57	234.24	234.57	16509517.0
2017-04-17 16:00:00	SPY	ETF	234.56	234.62	234.41	234.57	8128389.0
2017-04-17 16:30:00	SPY	ETF	234.56	234.58	234.47	234.55	2629101.0
2017-04-17 17:00:00	SPY	ETF	234.55	234.59	234.52	234.55	257428.0
2017-04-17 17:30:00	SPY	ETF	234.55	234.6	234.54	234.56	71376.0
2017-04-17 18:00:00	SPY	ETF	234.55	234.58	234.45	234.48	107402.0
2017-04-17 18:30:00	SPY	ETF	234.47	234.55	234.47	234.5	26638.0
2017-04-17 19:00:00	SPY	ETF	234.5	234.52	234.45	234.45	29799.0
2017-04-17 19:30:00	SPY	ETF	234.45	234.5	234.45	234.49	23871.0
2017-04-17 04:00:00	QQQ	ETF	130.45	130.45	130.45	130.45	840.0
2017-04-17 04:30:00	QQQ	ETF	130.43	130.43	130.43	130.43	100.0
2017-04-17 05:30:00	QQQ	ETF	130.4	130.45	130.4	130.45	25138.0
2017-04-17 06:00:00	QQQ	ETF	130.5	130.51	130.5	130.51	5000.0
2017-04-17 06:30:00	QQQ	ETF	130.51	130.51	130.45	130.46	400.0
2017-04-17 07:00:00	QQQ	ETF	130.42	130.47	130.42	130.46	950.0
2017-04-17 07:30:00	QQQ	ETF	130.65	130.75	130.65	130.74	12190.0
2017-04-17 08:00:00	QQQ	ETF	130.69	130.77	130.68	130.76	98051.0
2017-04-17 08:30:00	QQQ	ETF	130.76	130.84	130.76	130.83	106165.0
2017-04-17 09:00:00	QQQ	ETF	130.83	130.88	130.765	130.8	121237.0
2017-04-17 09:30:00	QQQ	ETF	130.8	131.0153	130.73	130.9	1946060.0
2017-04-17 10:00:00	QQQ	ETF	130.895	131.31	130.87	131.0954	1483701.0
2017-04-17 10:30:00	QQQ	ETF	131.1	131.17	130.99	131.12	634356.0
2017-04-17 11:00:00	QQQ	ETF	131.115	131.24	131.05	131.18	539340.0
2017-04-17 11:30:00	QQQ	ETF	131.18	131.22	131.03	131.03	338655.0
2017-04-17 12:00:00	QQQ	ETF	131.0271	131.22	131.0	131.15	409755.0
2017-04-17 12:30:00	QQQ	ETF	131.155	131.18	131.06	131.09	342807.0
2017-04-17 13:00:00	QQQ	ETF	131.09	131.24	131.0764	131.19	391850.0
2017-04-17 13:30:00	QQQ	ETF	131.195	131.221	131.09	131.16	376365.0

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

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