PREVIEW / etf_30min / 2012-12-18

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-18.parquet
  size:    317 KB
  rows:    10,521

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-18 04:00:00	SPY	ETF	144.42	144.56	144.39	144.56	6860.0
2012-12-18 04:30:00	SPY	ETF	144.53	144.57	144.5	144.5	6500.0
2012-12-18 05:00:00	SPY	ETF	144.51	144.58	144.51	144.51	970.0
2012-12-18 05:30:00	SPY	ETF	144.43	144.43	144.36	144.36	696.0
2012-12-18 06:00:00	SPY	ETF	144.3	144.36	144.3	144.36	250.0
2012-12-18 06:30:00	SPY	ETF	144.41	144.5	144.41	144.48	1945.0
2012-12-18 07:00:00	SPY	ETF	144.43	144.48	144.39	144.43	71098.0
2012-12-18 07:30:00	SPY	ETF	144.42	144.55	144.39	144.55	214674.0
2012-12-18 08:00:00	SPY	ETF	144.55	144.68	144.11	144.22	2837632.0
2012-12-18 08:30:00	SPY	ETF	144.21	144.36	144.03	144.07	2440386.0
2012-12-18 09:00:00	SPY	ETF	144.08	144.22	143.8	144.0	5069207.0
2012-12-18 09:30:00	SPY	ETF	144.0	144.12	143.79	143.87	16541987.0
2012-12-18 10:00:00	SPY	ETF	143.86	144.31	143.8	144.281	12575245.0
2012-12-18 10:30:00	SPY	ETF	144.29	144.75	144.275	144.62	13895803.0
2012-12-18 11:00:00	SPY	ETF	144.62	145.02	144.6	144.84	12002088.0
2012-12-18 11:30:00	SPY	ETF	144.84	144.98	144.76	144.765	6938822.0
2012-12-18 12:00:00	SPY	ETF	144.77	144.98	144.73	144.929	5894785.0
2012-12-18 12:30:00	SPY	ETF	144.93	145.46	144.91	145.31	11079037.0
2012-12-18 13:00:00	SPY	ETF	145.31	145.35	145.08	145.11	5707126.0
2012-12-18 13:30:00	SPY	ETF	145.1199	145.32	145.07	145.1599	7324449.0
2012-12-18 14:00:00	SPY	ETF	145.15	145.27	144.91	144.92	10116677.0
2012-12-18 14:30:00	SPY	ETF	144.92	145.12	144.85	145.03	8201362.0
2012-12-18 15:00:00	SPY	ETF	145.03	145.21	144.97	144.97	8735048.0
2012-12-18 15:30:00	SPY	ETF	144.97	145.5	144.94	145.35	25953571.0
2012-12-18 16:00:00	SPY	ETF	145.34	145.45	143.7346	145.27	8614033.0
2012-12-18 16:30:00	SPY	ETF	145.27	145.28	143.7346	145.22	4921738.0
2012-12-18 17:00:00	SPY	ETF	145.22	145.31	143.7346	145.31	7093374.0
2012-12-18 17:30:00	SPY	ETF	145.29	145.29	145.16	145.23	120880.0
2012-12-18 18:00:00	SPY	ETF	145.23	145.36	145.16	145.33	129529.0
2012-12-18 18:30:00	SPY	ETF	145.32	145.36	145.28	145.28	17046.0
2012-12-18 19:00:00	SPY	ETF	145.27	145.27	145.17	145.22	9452.0
2012-12-18 19:30:00	SPY	ETF	145.23	145.33	145.18	145.3	17340.0
2012-12-18 04:00:00	QQQ	ETF	65.91	65.91	65.91	65.91	8000.0
2012-12-18 04:30:00	QQQ	ETF	65.93	65.96	65.93	65.96	13400.0
2012-12-18 06:30:00	QQQ	ETF	65.88	65.95	65.88	65.95	16500.0
2012-12-18 07:00:00	QQQ	ETF	65.94	65.95	65.9	65.94	198383.0
2012-12-18 07:30:00	QQQ	ETF	66.0	66.1	65.99	66.05	71000.0
2012-12-18 08:00:00	QQQ	ETF	66.05	66.1	65.93	65.93	217762.0
2012-12-18 08:30:00	QQQ	ETF	65.96	65.99	65.85	65.87	100448.0
2012-12-18 09:00:00	QQQ	ETF	65.9	65.94	65.78	65.86	337704.0
2012-12-18 09:30:00	QQQ	ETF	65.85	65.94	65.7	65.75	5362570.0
2012-12-18 10:00:00	QQQ	ETF	65.75	66.01	65.7	66.0	4493046.0
2012-12-18 10:30:00	QQQ	ETF	66.008	66.2	65.98	66.12	4732066.0
2012-12-18 11:00:00	QQQ	ETF	66.13	66.31	66.0999	66.24	3681990.0
2012-12-18 11:30:00	QQQ	ETF	66.25	66.43	66.22	66.339	2916992.0
2012-12-18 12:00:00	QQQ	ETF	66.33	66.43	66.28	66.3985	1850077.0
2012-12-18 12:30:00	QQQ	ETF	66.39	66.6387	66.38	66.61	2957285.0
2012-12-18 13:00:00	QQQ	ETF	66.61	66.61	66.44	66.451	1727557.0
2012-12-18 13:30:00	QQQ	ETF	66.46	66.54	66.43	66.46	1806490.0
2012-12-18 14:00:00	QQQ	ETF	66.46	66.55	66.38	66.38	2606599.0

> showing 50 of 10,521 rows — these rows as CSV

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