PREVIEW / etf_30min / 2012-12-12

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-12.parquet
  size:    296 KB
  rows:    9,975

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
2012-12-12 04:00:00	SPY	ETF	143.88	144.09	143.88	144.05	61376.0
2012-12-12 04:30:00	SPY	ETF	144.02	144.03	144.01	144.03	11000.0
2012-12-12 05:00:00	SPY	ETF	144.07	144.09	144.05	144.05	11275.0
2012-12-12 05:30:00	SPY	ETF	143.98	144.03	143.95	143.97	11196.0
2012-12-12 06:00:00	SPY	ETF	143.97	144.0	143.97	143.99	880.0
2012-12-12 06:30:00	SPY	ETF	143.98	143.98	143.92	143.96	37549.0
2012-12-12 07:00:00	SPY	ETF	143.98	144.08	143.93	144.07	43393.0
2012-12-12 07:30:00	SPY	ETF	144.08	144.23	144.07	144.11	214559.0
2012-12-12 08:00:00	SPY	ETF	144.11	144.14	143.97	143.99	925379.0
2012-12-12 08:30:00	SPY	ETF	144.0	144.09	143.9	144.07	286523.0
2012-12-12 09:00:00	SPY	ETF	144.07	144.16	143.92	144.0	481987.0
2012-12-12 09:30:00	SPY	ETF	144.0	144.02	143.76	143.81	11207023.0
2012-12-12 10:00:00	SPY	ETF	143.82	143.855	143.6	143.81	8914059.0
2012-12-12 10:30:00	SPY	ETF	143.81	143.83	143.58	143.6799	4836691.0
2012-12-12 11:00:00	SPY	ETF	143.68	143.81	143.59	143.792	4806250.0
2012-12-12 11:30:00	SPY	ETF	143.795	143.83	143.61	143.6299	3907081.0
2012-12-12 12:00:00	SPY	ETF	143.62	143.79	143.615	143.78	4358210.0
2012-12-12 12:30:00	SPY	ETF	143.77	144.5	143.52	144.3975	20599479.0
2012-12-12 13:00:00	SPY	ETF	144.395	144.52	144.18	144.44	10554269.0
2012-12-12 13:30:00	SPY	ETF	144.43	144.55	144.292	144.33	5975265.0
2012-12-12 14:00:00	SPY	ETF	144.3399	144.41	144.05	144.125	8526860.0
2012-12-12 14:30:00	SPY	ETF	144.125	144.21	143.99	144.045	8359624.0
2012-12-12 15:00:00	SPY	ETF	144.04	144.065	143.47	143.5695	10836385.0
2012-12-12 15:30:00	SPY	ETF	143.57	143.67	143.31	143.51	16840432.0
2012-12-12 16:00:00	SPY	ETF	143.5	144.34	142.0336	143.33	4522425.0
2012-12-12 16:30:00	SPY	ETF	143.34	144.061	143.28	143.29	16031494.0
2012-12-12 17:00:00	SPY	ETF	143.29	143.4386	143.28	143.35	1603309.0
2012-12-12 17:30:00	SPY	ETF	143.35	143.36	143.25	143.29	29626.0
2012-12-12 18:00:00	SPY	ETF	143.29	143.42	143.19	143.42	47045.0
2012-12-12 18:30:00	SPY	ETF	143.43	143.51	143.43	143.5	51284.0
2012-12-12 19:00:00	SPY	ETF	143.49	143.58	143.49	143.5	30042.0
2012-12-12 19:30:00	SPY	ETF	143.5	143.54	143.44	143.47	13574.0
2012-12-12 04:30:00	QQQ	ETF	66.21	66.21	66.21	66.21	900.0
2012-12-12 06:30:00	QQQ	ETF	66.17	66.17	66.17	66.17	100.0
2012-12-12 07:00:00	QQQ	ETF	66.25	66.26	66.2	66.22	11970.0
2012-12-12 07:30:00	QQQ	ETF	66.25	66.28	66.25	66.28	17246.0
2012-12-12 08:00:00	QQQ	ETF	66.28	66.29	66.23	66.26	1457804.0
2012-12-12 08:30:00	QQQ	ETF	66.25	66.28	66.22	66.28	65512.0
2012-12-12 09:00:00	QQQ	ETF	66.27	66.33	66.25	66.29	133491.0
2012-12-12 09:30:00	QQQ	ETF	66.29	66.32	66.035	66.07	4208227.0
2012-12-12 10:00:00	QQQ	ETF	66.065	66.08	65.93	66.05	2823278.0
2012-12-12 10:30:00	QQQ	ETF	66.05	66.065	65.88	65.93	1957975.0
2012-12-12 11:00:00	QQQ	ETF	65.925	66.02	65.86	65.9775	995444.0
2012-12-12 11:30:00	QQQ	ETF	65.99	66.0	65.83	65.849	927343.0
2012-12-12 12:00:00	QQQ	ETF	65.84	65.94	65.84	65.93	918098.0
2012-12-12 12:30:00	QQQ	ETF	65.92	66.27	65.79	66.2099	4988795.0
2012-12-12 13:00:00	QQQ	ETF	66.205	66.22	66.01	66.16	4650368.0
2012-12-12 13:30:00	QQQ	ETF	66.16	66.26	66.13	66.16	2136730.0
2012-12-12 14:00:00	QQQ	ETF	66.16	66.26	66.07	66.1	2810180.0
2012-12-12 14:30:00	QQQ	ETF	66.1	66.17	66.01	66.04	2008587.0

> showing 50 of 9,975 rows — these rows as CSV

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