PREVIEW / etf_30min / 2017-08-10

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-10.parquet
  size:    465 KB
  rows:    15,838

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-08-10 04:00:00	SPY	ETF	247.04	247.04	246.7	246.7	1592.0
2017-08-10 04:30:00	SPY	ETF	246.72	246.75	246.59	246.61	80200.0
2017-08-10 05:00:00	SPY	ETF	246.52	246.52	246.39	246.47	44649.0
2017-08-10 05:30:00	SPY	ETF	246.48	246.66	246.48	246.55	52150.0
2017-08-10 06:00:00	SPY	ETF	246.56	246.69	246.55	246.58	29150.0
2017-08-10 06:30:00	SPY	ETF	246.58	246.59	246.35	246.49	26397.0
2017-08-10 07:00:00	SPY	ETF	246.47	246.58	246.3	246.53	217875.0
2017-08-10 07:30:00	SPY	ETF	246.56	246.62	246.48	246.55	66667.0
2017-08-10 08:00:00	SPY	ETF	246.45	246.58	246.3	246.58	131575.0
2017-08-10 08:30:00	SPY	ETF	246.6	246.61	246.35	246.41	210354.0
2017-08-10 09:00:00	SPY	ETF	246.4	246.44	246.19	246.3	422501.0
2017-08-10 09:30:00	SPY	ETF	246.29	246.44	245.73	245.87	9358372.0
2017-08-10 10:00:00	SPY	ETF	245.88	245.92	245.02	245.585	12203730.0
2017-08-10 10:30:00	SPY	ETF	245.59	245.77	245.429	245.44	5693807.0
2017-08-10 11:00:00	SPY	ETF	245.43	245.56	245.0	245.29	5195549.0
2017-08-10 11:30:00	SPY	ETF	245.285	245.43	244.89	245.04	6607937.0
2017-08-10 12:00:00	SPY	ETF	245.04	245.12	244.68	244.73	6474001.0
2017-08-10 12:30:00	SPY	ETF	244.74	244.91	244.44	244.89	6284071.0
2017-08-10 13:00:00	SPY	ETF	244.88	245.14	244.81	245.085	4849339.0
2017-08-10 13:30:00	SPY	ETF	245.09	245.13	244.63	244.82	2690211.0
2017-08-10 14:00:00	SPY	ETF	244.82	245.27	244.59	245.08	3921546.0
2017-08-10 14:30:00	SPY	ETF	245.08	245.47	244.88	244.9909	6572315.0
2017-08-10 15:00:00	SPY	ETF	244.99	245.11	244.14	244.35	8036116.0
2017-08-10 15:30:00	SPY	ETF	244.345	244.45	243.7	243.79	23095316.0
2017-08-10 16:00:00	SPY	ETF	243.79	244.15	243.75	243.77	13825499.0
2017-08-10 16:30:00	SPY	ETF	243.78	243.78	243.41	243.57	514909.0
2017-08-10 17:00:00	SPY	ETF	243.55	245.0505	243.4	243.47	250476.0
2017-08-10 17:30:00	SPY	ETF	243.47	243.54	243.43	243.54	174779.0
2017-08-10 18:00:00	SPY	ETF	243.54	243.76	243.39	243.76	309410.0
2017-08-10 18:30:00	SPY	ETF	243.62	243.79	243.55	243.79	53391.0
2017-08-10 19:00:00	SPY	ETF	243.72	243.78	243.7	243.74	40146.0
2017-08-10 19:30:00	SPY	ETF	243.75	243.79	243.71	243.75	33429.0
2017-08-10 04:00:00	QQQ	ETF	143.79	143.79	143.56	143.56	4924.0
2017-08-10 04:30:00	QQQ	ETF	143.63	143.69	143.57	143.57	23765.0
2017-08-10 05:00:00	QQQ	ETF	143.57	143.57	143.43	143.43	6277.0
2017-08-10 05:30:00	QQQ	ETF	143.47	143.59	143.47	143.53	41000.0
2017-08-10 06:00:00	QQQ	ETF	143.57	143.58	143.51	143.57	3500.0
2017-08-10 06:30:00	QQQ	ETF	143.56	143.56	143.34	143.4	14300.0
2017-08-10 07:00:00	QQQ	ETF	143.39	143.41	143.23	143.4	59148.0
2017-08-10 07:30:00	QQQ	ETF	143.41	143.44	143.36	143.41	182647.0
2017-08-10 08:00:00	QQQ	ETF	143.43	143.5	143.31	143.44	64937.0
2017-08-10 08:30:00	QQQ	ETF	143.47	143.47	143.33	143.34	48943.0
2017-08-10 09:00:00	QQQ	ETF	143.36	143.37	143.27	143.33	167777.0
2017-08-10 09:30:00	QQQ	ETF	143.33	143.4	142.76	142.88	5530266.0
2017-08-10 10:00:00	QQQ	ETF	142.89	142.92	142.11	142.7	7575710.0
2017-08-10 10:30:00	QQQ	ETF	142.71	142.84	142.54	142.62	1748095.0
2017-08-10 11:00:00	QQQ	ETF	142.61	142.72	142.25	142.42	1596995.0
2017-08-10 11:30:00	QQQ	ETF	142.42	142.49	141.88	141.98	2622850.0
2017-08-10 12:00:00	QQQ	ETF	141.993	142.12	141.68	141.75	2686513.0
2017-08-10 12:30:00	QQQ	ETF	141.75	141.84	141.36	141.79	4785839.0

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

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