PREVIEW / etf_30min / 2013-06-25

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-25.parquet
  size:    328 KB
  rows:    11,022

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
2013-06-25 04:00:00	SPY	ETF	157.55	157.88	157.38	157.84	32625.0
2013-06-25 04:30:00	SPY	ETF	157.87	158.02	157.78	157.92	17100.0
2013-06-25 05:00:00	SPY	ETF	157.93	157.93	157.75	157.75	5610.0
2013-06-25 05:30:00	SPY	ETF	157.74	158.14	157.7	157.98	46400.0
2013-06-25 06:00:00	SPY	ETF	157.99	157.99	157.75	157.89	49500.0
2013-06-25 06:30:00	SPY	ETF	157.84	157.99	157.52	157.67	68671.0
2013-06-25 07:00:00	SPY	ETF	157.64	157.92	157.61	157.92	267243.0
2013-06-25 07:30:00	SPY	ETF	157.92	158.24	157.88	158.2	417380.0
2013-06-25 08:00:00	SPY	ETF	157.98	158.23	157.69	158.11	780597.0
2013-06-25 08:30:00	SPY	ETF	158.12	158.25	156.99	157.95	2081741.0
2013-06-25 09:00:00	SPY	ETF	157.93	158.64	157.87	158.47	2039462.0
2013-06-25 09:30:00	SPY	ETF	158.48	158.62	157.72	157.99	21619467.0
2013-06-25 10:00:00	SPY	ETF	157.99	158.24	157.42	157.81	19996027.0
2013-06-25 10:30:00	SPY	ETF	157.81	158.5	157.64	158.38	11728519.0
2013-06-25 11:00:00	SPY	ETF	158.385	158.63	158.08	158.21	7366261.0
2013-06-25 11:30:00	SPY	ETF	158.21	158.46	158.001	158.41	7665763.0
2013-06-25 12:00:00	SPY	ETF	158.41	158.57	158.3	158.445	4043027.0
2013-06-25 12:30:00	SPY	ETF	158.45	158.715	158.42	158.43	7185610.0
2013-06-25 13:00:00	SPY	ETF	158.44	158.56	158.04	158.16	7375469.0
2013-06-25 13:30:00	SPY	ETF	158.16	158.535	158.04	158.29	5854644.0
2013-06-25 14:00:00	SPY	ETF	158.28	158.62	158.16	158.515	6738414.0
2013-06-25 14:30:00	SPY	ETF	158.51	158.8	158.41	158.48	6853640.0
2013-06-25 15:00:00	SPY	ETF	158.48	158.91	158.47	158.9	8218524.0
2013-06-25 15:30:00	SPY	ETF	158.895	160.1	158.54	158.59	26869980.0
2013-06-25 16:00:00	SPY	ETF	158.6	158.9	157.0689	158.52	8962780.0
2013-06-25 16:30:00	SPY	ETF	158.52	158.53	158.46	158.51	208912.0
2013-06-25 17:00:00	SPY	ETF	158.51	158.7294	158.46	158.48	188458.0
2013-06-25 17:30:00	SPY	ETF	158.49	158.5	158.44	158.46	32750.0
2013-06-25 18:00:00	SPY	ETF	158.46	158.5	158.35	158.5	87063.0
2013-06-25 18:30:00	SPY	ETF	158.49	158.51	158.42	158.45	12737.0
2013-06-25 19:00:00	SPY	ETF	158.45	158.46	158.17	158.18	90767.0
2013-06-25 19:30:00	SPY	ETF	158.2	158.25	158.08	158.1	85349.0
2013-06-25 04:00:00	QQQ	ETF	69.97	70.15	69.94	70.15	20200.0
2013-06-25 04:30:00	QQQ	ETF	70.18	70.22	70.15	70.22	3440.0
2013-06-25 05:00:00	QQQ	ETF	70.2	70.2	70.12	70.12	7200.0
2013-06-25 05:30:00	QQQ	ETF	70.15	70.29	70.15	70.21	9400.0
2013-06-25 06:00:00	QQQ	ETF	70.18	70.21	70.15	70.18	8500.0
2013-06-25 06:30:00	QQQ	ETF	70.21	70.21	70.05	70.09	8600.0
2013-06-25 07:00:00	QQQ	ETF	70.1	70.18	70.09	70.18	35140.0
2013-06-25 07:30:00	QQQ	ETF	70.19	70.35	70.18	70.33	43445.0
2013-06-25 08:00:00	QQQ	ETF	70.17	70.35	70.17	70.28	101445.0
2013-06-25 08:30:00	QQQ	ETF	70.28	70.35	70.18	70.21	166114.0
2013-06-25 09:00:00	QQQ	ETF	70.2	70.48	70.18	70.4	408416.0
2013-06-25 09:30:00	QQQ	ETF	70.4	70.52	70.0555	70.1712	4487411.0
2013-06-25 10:00:00	QQQ	ETF	70.17	70.2415	69.81	69.9	4825538.0
2013-06-25 10:30:00	QQQ	ETF	69.9	70.149	69.84	70.07	1983374.0
2013-06-25 11:00:00	QQQ	ETF	70.07	70.17	69.92	69.99	1253882.0
2013-06-25 11:30:00	QQQ	ETF	69.98	70.16	69.96	70.15	1283309.0
2013-06-25 12:00:00	QQQ	ETF	70.14	70.2199	70.08	70.14	780733.0
2013-06-25 12:30:00	QQQ	ETF	70.14	70.26	70.11	70.12	771295.0

> showing 50 of 11,022 rows — these rows as CSV

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