PREVIEW / etf_30min / 2015-09-03

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-03.parquet
  size:    384 KB
  rows:    12,945

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-09-03 04:00:00	SPY	ETF	196.11	196.3	196.02	196.06	9775.0
2015-09-03 04:30:00	SPY	ETF	196.06	196.34	196.06	196.31	9450.0
2015-09-03 05:00:00	SPY	ETF	196.34	196.64	196.34	196.39	21976.0
2015-09-03 05:30:00	SPY	ETF	196.46	196.46	196.06	196.21	14723.0
2015-09-03 06:00:00	SPY	ETF	196.26	196.41	196.1	196.41	67823.0
2015-09-03 06:30:00	SPY	ETF	196.38	196.45	196.14	196.31	93782.0
2015-09-03 07:00:00	SPY	ETF	196.17	196.26	195.86	195.86	147811.0
2015-09-03 07:30:00	SPY	ETF	195.86	196.38	195.86	196.23	92693.0
2015-09-03 08:00:00	SPY	ETF	196.49	196.5	196.06	196.16	251226.0
2015-09-03 08:30:00	SPY	ETF	196.25	197.62	196.17	196.43	2892135.0
2015-09-03 09:00:00	SPY	ETF	196.44	196.62	196.01	196.26	1473726.0
2015-09-03 09:30:00	SPY	ETF	196.26	197.1	195.925	196.75	14678302.0
2015-09-03 10:00:00	SPY	ETF	196.75	197.6	196.42	197.5	10726757.0
2015-09-03 10:30:00	SPY	ETF	197.5	197.95	197.13	197.89	11960986.0
2015-09-03 11:00:00	SPY	ETF	197.89	198.05	197.26	197.37	8568747.0
2015-09-03 11:30:00	SPY	ETF	197.37	197.39	196.85	197.11	8170133.0
2015-09-03 12:00:00	SPY	ETF	197.1	197.21	196.853	197.0	4763457.0
2015-09-03 12:30:00	SPY	ETF	197.0	197.04	196.3	196.483	6828282.0
2015-09-03 13:00:00	SPY	ETF	196.49	197.2	195.58	196.335	10064573.0
2015-09-03 13:30:00	SPY	ETF	196.335	196.36	195.48	195.49	6799475.0
2015-09-03 14:00:00	SPY	ETF	195.495	195.9689	195.2601	195.9689	10268049.0
2015-09-03 14:30:00	SPY	ETF	195.965	196.46	195.74	196.0392	9681581.0
2015-09-03 15:00:00	SPY	ETF	196.03	196.28	195.48	195.61	10592873.0
2015-09-03 15:30:00	SPY	ETF	195.6	196.19	194.96	195.55	22834159.0
2015-09-03 16:00:00	SPY	ETF	195.53	195.7253	195.31	195.38	7998409.0
2015-09-03 16:30:00	SPY	ETF	195.38	195.65	195.35	195.43	2363421.0
2015-09-03 17:00:00	SPY	ETF	195.44	195.45	195.39	195.4	55687.0
2015-09-03 17:30:00	SPY	ETF	195.4	195.51	195.4	195.44	40922.0
2015-09-03 18:00:00	SPY	ETF	195.44	195.66	195.4	195.59	76062.0
2015-09-03 18:30:00	SPY	ETF	195.5	195.63	195.5	195.62	4541.0
2015-09-03 19:00:00	SPY	ETF	195.61	195.67	195.55	195.57	4526.0
2015-09-03 19:30:00	SPY	ETF	195.62	195.67	195.52	195.61	7482.0
2015-09-03 04:00:00	QQQ	ETF	104.51	104.56	104.45	104.48	7300.0
2015-09-03 04:30:00	QQQ	ETF	104.48	104.66	104.48	104.58	11474.0
2015-09-03 05:00:00	QQQ	ETF	104.67	104.72	104.64	104.72	6600.0
2015-09-03 05:30:00	QQQ	ETF	104.53	104.54	104.41	104.41	2250.0
2015-09-03 06:00:00	QQQ	ETF	104.51	104.51	104.45	104.49	4000.0
2015-09-03 06:30:00	QQQ	ETF	104.47	104.51	104.44	104.51	3300.0
2015-09-03 07:00:00	QQQ	ETF	104.44	104.48	104.3	104.3	8821.0
2015-09-03 07:30:00	QQQ	ETF	104.37	104.53	104.36	104.49	10869.0
2015-09-03 08:00:00	QQQ	ETF	104.48	104.61	104.36	104.41	45419.0
2015-09-03 08:30:00	QQQ	ETF	104.47	105.13	104.46	104.51	445668.0
2015-09-03 09:00:00	QQQ	ETF	104.52	104.55	104.21	104.28	450633.0
2015-09-03 09:30:00	QQQ	ETF	104.31	104.73	104.03	104.2	6308631.0
2015-09-03 10:00:00	QQQ	ETF	104.21	104.7799	104.03	104.73	4420285.0
2015-09-03 10:30:00	QQQ	ETF	104.73	104.91	104.48	104.88	2263905.0
2015-09-03 11:00:00	QQQ	ETF	104.881	105.02	104.52	104.58	2339643.0
2015-09-03 11:30:00	QQQ	ETF	104.595	104.61	104.23	104.42	1718656.0
2015-09-03 12:00:00	QQQ	ETF	104.41	104.47	104.24	104.4	1169176.0
2015-09-03 12:30:00	QQQ	ETF	104.395	104.42	103.92	104.05	1786575.0

> showing 50 of 12,945 rows — these rows as CSV

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