PREVIEW / etf_30min / 2017-03-29

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-29.parquet
  size:    420 KB
  rows:    14,344

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-03-29 04:00:00	SPY	ETF	235.26	235.43	235.21	235.27	1370.0
2017-03-29 04:30:00	SPY	ETF	235.07	235.07	235.07	235.07	503.0
2017-03-29 05:00:00	SPY	ETF	235.03	235.08	234.95	234.95	2939.0
2017-03-29 05:30:00	SPY	ETF	235.0	235.0	234.89	234.93	2370.0
2017-03-29 06:00:00	SPY	ETF	234.96	234.96	234.87	234.91	2267.0
2017-03-29 06:30:00	SPY	ETF	234.86	234.88	234.77	234.88	41865.0
2017-03-29 07:00:00	SPY	ETF	234.92	234.99	234.87	234.91	46649.0
2017-03-29 07:30:00	SPY	ETF	234.88	234.98	234.82	234.97	39728.0
2017-03-29 08:00:00	SPY	ETF	234.92	235.05	234.85	235.05	82262.0
2017-03-29 08:30:00	SPY	ETF	235.04	235.12	235.0	235.0	60242.0
2017-03-29 09:00:00	SPY	ETF	235.0	235.09	234.93	234.99	237692.0
2017-03-29 09:30:00	SPY	ETF	234.99	235.26	234.725	235.2559	7014464.0
2017-03-29 10:00:00	SPY	ETF	235.26	235.33	235.07	235.21	4439128.0
2017-03-29 10:30:00	SPY	ETF	235.215	235.719	235.215	235.595	5713282.0
2017-03-29 11:00:00	SPY	ETF	235.58	235.63	235.335	235.44	2868814.0
2017-03-29 11:30:00	SPY	ETF	235.44	235.47	235.03	235.33	3119487.0
2017-03-29 12:00:00	SPY	ETF	235.32	235.51	235.24	235.425	1780058.0
2017-03-29 12:30:00	SPY	ETF	235.42	235.43	235.17	235.23	1734059.0
2017-03-29 13:00:00	SPY	ETF	235.24	235.51	235.21	235.46	1718394.0
2017-03-29 13:30:00	SPY	ETF	235.48	235.6	235.42	235.59	1650314.0
2017-03-29 14:00:00	SPY	ETF	235.59	235.72	235.43	235.6889	2568198.0
2017-03-29 14:30:00	SPY	ETF	235.68	235.75	235.56	235.675	2424373.0
2017-03-29 15:00:00	SPY	ETF	235.675	235.81	235.58	235.73	3143882.0
2017-03-29 15:30:00	SPY	ETF	235.73	235.78	235.45	235.59	8389319.0
2017-03-29 16:00:00	SPY	ETF	235.59	235.71	235.5	235.54	9709243.0
2017-03-29 16:30:00	SPY	ETF	235.55	235.56	235.2651	235.49	2590449.0
2017-03-29 17:00:00	SPY	ETF	235.49	235.52	235.3117	235.48	249992.0
2017-03-29 17:30:00	SPY	ETF	235.48	235.54	235.44	235.54	853728.0
2017-03-29 18:00:00	SPY	ETF	235.48	235.49	235.42	235.48	15425.0
2017-03-29 18:30:00	SPY	ETF	235.5	235.59	235.48	235.56	9030.0
2017-03-29 19:00:00	SPY	ETF	235.56	235.6	235.52	235.53	34203.0
2017-03-29 19:30:00	SPY	ETF	235.56	235.6	235.54	235.57	11400.0
2017-03-29 04:00:00	QQQ	ETF	131.76	131.85	131.71	131.82	25759.0
2017-03-29 04:30:00	QQQ	ETF	131.79	131.79	131.78	131.78	800.0
2017-03-29 05:00:00	QQQ	ETF	131.7	131.7	131.6	131.6	16300.0
2017-03-29 05:30:00	QQQ	ETF	131.65	131.65	131.59	131.62	20400.0
2017-03-29 06:00:00	QQQ	ETF	131.61	131.61	131.58	131.58	1599.0
2017-03-29 06:30:00	QQQ	ETF	131.57	131.59	131.57	131.59	7400.0
2017-03-29 07:00:00	QQQ	ETF	131.65	131.66	131.63	131.64	15500.0
2017-03-29 07:30:00	QQQ	ETF	131.6	131.63	131.6	131.63	7332.0
2017-03-29 08:00:00	QQQ	ETF	131.62	131.72	131.59	131.71	58688.0
2017-03-29 08:30:00	QQQ	ETF	131.71	131.75	131.7	131.71	39452.0
2017-03-29 09:00:00	QQQ	ETF	131.73	131.75	131.69	131.73	59961.0
2017-03-29 09:30:00	QQQ	ETF	131.73	131.97	131.59	131.96	1465412.0
2017-03-29 10:00:00	QQQ	ETF	131.97	132.03	131.85	131.99	817148.0
2017-03-29 10:30:00	QQQ	ETF	131.99	132.13	131.97	132.02	1259196.0
2017-03-29 11:00:00	QQQ	ETF	132.025	132.06	131.88	131.93	879145.0
2017-03-29 11:30:00	QQQ	ETF	131.92	131.93	131.7389	131.851	667830.0
2017-03-29 12:00:00	QQQ	ETF	131.869	132.03	131.82	132.01	495848.0
2017-03-29 12:30:00	QQQ	ETF	132.01	132.0245	131.85	131.89	566928.0

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

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