PREVIEW / etf_30min / 2015-08-31

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-31.parquet
  size:    391 KB
  rows:    13,166

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
2015-08-31 04:00:00	SPY	ETF	197.87	197.87	197.35	197.47	48498.0
2015-08-31 04:30:00	SPY	ETF	197.59	197.74	197.36	197.57	17170.0
2015-08-31 05:00:00	SPY	ETF	197.56	198.0	197.47	198.0	25302.0
2015-08-31 05:30:00	SPY	ETF	198.0	198.06	197.65	197.92	8347.0
2015-08-31 06:00:00	SPY	ETF	198.0	198.19	197.8	198.17	44860.0
2015-08-31 06:30:00	SPY	ETF	198.12	198.39	198.07	198.1	60913.0
2015-08-31 07:00:00	SPY	ETF	198.09	198.14	197.93	197.97	73585.0
2015-08-31 07:30:00	SPY	ETF	198.03	198.26	198.03	198.17	190257.0
2015-08-31 08:00:00	SPY	ETF	198.19	198.44	197.0	198.05	556908.0
2015-08-31 08:30:00	SPY	ETF	198.04	198.06	197.1	197.9	625480.0
2015-08-31 09:00:00	SPY	ETF	197.86	199.3404	197.82	198.1	2073909.0
2015-08-31 09:30:00	SPY	ETF	198.11	198.56	197.43	197.48	16144260.0
2015-08-31 10:00:00	SPY	ETF	197.48	198.16	197.01	198.06	13076825.0
2015-08-31 10:30:00	SPY	ETF	198.05	198.4399	197.91	197.97	9500945.0
2015-08-31 11:00:00	SPY	ETF	197.96	198.44	197.46	198.34	9440571.0
2015-08-31 11:30:00	SPY	ETF	198.33	199.125	198.03	198.52	13661696.0
2015-08-31 12:00:00	SPY	ETF	198.525	199.05	198.35	198.82	5248402.0
2015-08-31 12:30:00	SPY	ETF	198.815	199.0408	198.51	198.52	3522089.0
2015-08-31 13:00:00	SPY	ETF	198.5308	198.73	198.17	198.33	3254612.0
2015-08-31 13:30:00	SPY	ETF	198.34	198.4057	197.93	198.15	7216138.0
2015-08-31 14:00:00	SPY	ETF	198.16	198.4	197.51	197.88	7370641.0
2015-08-31 14:30:00	SPY	ETF	197.885	198.1	197.19	197.35	8432303.0
2015-08-31 15:00:00	SPY	ETF	197.35	199.035	197.32	197.4961	9760124.0
2015-08-31 15:30:00	SPY	ETF	197.49	198.35	197.44	197.6	22637842.0
2015-08-31 16:00:00	SPY	ETF	197.63	197.8475	197.01	197.1	10856175.0
2015-08-31 16:30:00	SPY	ETF	197.11	197.67	197.04	197.31	4557052.0
2015-08-31 17:00:00	SPY	ETF	197.31	199.3526	197.26	197.35	849785.0
2015-08-31 17:30:00	SPY	ETF	197.35	197.9908	197.28	197.31	161457.0
2015-08-31 18:00:00	SPY	ETF	197.31	197.67	197.0	197.07	2661259.0
2015-08-31 18:30:00	SPY	ETF	197.05	197.06	196.81	196.98	81109.0
2015-08-31 19:00:00	SPY	ETF	196.97	196.99	196.9	196.9	10266.0
2015-08-31 19:30:00	SPY	ETF	196.89	196.89	196.17	196.33	203644.0
2015-08-31 04:00:00	QQQ	ETF	104.96	104.96	104.69	104.69	1510.0
2015-08-31 04:30:00	QQQ	ETF	104.8	104.8	104.8	104.8	320.0
2015-08-31 05:00:00	QQQ	ETF	104.95	104.95	104.95	104.95	100.0
2015-08-31 05:30:00	QQQ	ETF	105.1	105.1	105.07	105.07	200.0
2015-08-31 06:00:00	QQQ	ETF	104.91	105.1	104.91	105.1	200.0
2015-08-31 06:30:00	QQQ	ETF	105.13	105.2	105.09	105.1	4900.0
2015-08-31 07:00:00	QQQ	ETF	105.09	105.09	105.02	105.05	11050.0
2015-08-31 07:30:00	QQQ	ETF	105.08	105.22	105.08	105.2	6910.0
2015-08-31 08:00:00	QQQ	ETF	105.21	105.31	105.0	105.07	41135.0
2015-08-31 08:30:00	QQQ	ETF	105.09	105.09	104.91	104.95	99390.0
2015-08-31 09:00:00	QQQ	ETF	104.99	105.16	104.89	105.02	194694.0
2015-08-31 09:30:00	QQQ	ETF	105.03	105.44	104.73	104.76	4392620.0
2015-08-31 10:00:00	QQQ	ETF	104.77	105.08	104.36	105.0	3018843.0
2015-08-31 10:30:00	QQQ	ETF	105.01	105.3	104.9201	105.0	2001897.0
2015-08-31 11:00:00	QQQ	ETF	105.0	105.27	104.64	105.17	2108818.0
2015-08-31 11:30:00	QQQ	ETF	105.17	105.58	104.98	105.3	2565156.0
2015-08-31 12:00:00	QQQ	ETF	105.3	105.61	105.23	105.56	1258031.0
2015-08-31 12:30:00	QQQ	ETF	105.56	105.61	105.39	105.41	738401.0

> showing 50 of 13,166 rows — these rows as CSV

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