PREVIEW / etf_30min / 2013-01-24

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-24.parquet
  size:    317 KB
  rows:    10,594

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-01-24 04:00:00	SPY	ETF	148.92	149.19	148.92	149.19	24766.0
2013-01-24 04:30:00	SPY	ETF	149.19	149.19	149.16	149.17	20600.0
2013-01-24 05:00:00	SPY	ETF	149.1	149.19	149.1	149.16	8300.0
2013-01-24 05:30:00	SPY	ETF	149.22	149.22	149.12	149.12	10900.0
2013-01-24 06:00:00	SPY	ETF	149.11	149.16	149.09	149.14	7480.0
2013-01-24 06:30:00	SPY	ETF	149.09	149.09	149.02	149.07	52320.0
2013-01-24 07:00:00	SPY	ETF	149.09	149.24	149.07	149.12	87039.0
2013-01-24 07:30:00	SPY	ETF	149.15	149.15	149.04	149.11	128361.0
2013-01-24 08:00:00	SPY	ETF	149.1	149.25	149.03	149.19	573806.0
2013-01-24 08:30:00	SPY	ETF	149.22	149.46	149.09	149.36	813415.0
2013-01-24 09:00:00	SPY	ETF	149.35	149.39	149.14	149.155	538159.0
2013-01-24 09:30:00	SPY	ETF	149.15	149.78	149.12	149.75	15314994.0
2013-01-24 10:00:00	SPY	ETF	149.75	150.07	149.72	149.85	10773190.0
2013-01-24 10:30:00	SPY	ETF	149.85	149.9685	149.76	149.85	5917437.0
2013-01-24 11:00:00	SPY	ETF	149.85	150.14	149.85	150.06	7922849.0
2013-01-24 11:30:00	SPY	ETF	150.06	150.12	149.87	149.94	8061303.0
2013-01-24 12:00:00	SPY	ETF	149.931	149.98	149.71	149.76	6906716.0
2013-01-24 12:30:00	SPY	ETF	149.77	149.77	149.33	149.351	10047209.0
2013-01-24 13:00:00	SPY	ETF	149.35	149.48	149.29	149.45	7967809.0
2013-01-24 13:30:00	SPY	ETF	149.45	149.45	149.01	149.14	10751573.0
2013-01-24 14:00:00	SPY	ETF	149.14	149.3729	149.04	149.21	7236069.0
2013-01-24 14:30:00	SPY	ETF	149.2001	149.45	149.2	149.37	6108328.0
2013-01-24 15:00:00	SPY	ETF	149.37	149.56	149.32	149.535	6910691.0
2013-01-24 15:30:00	SPY	ETF	149.53	149.74	149.32	149.38	13666540.0
2013-01-24 16:00:00	SPY	ETF	149.39	149.9664	149.36	149.59	15829149.0
2013-01-24 16:30:00	SPY	ETF	149.58	149.59	149.24	149.24	8530525.0
2013-01-24 17:00:00	SPY	ETF	149.26	149.27	149.18	149.26	159134.0
2013-01-24 17:30:00	SPY	ETF	149.25	149.26	149.17	149.21	43913.0
2013-01-24 18:00:00	SPY	ETF	149.2	149.28	149.16	149.23	66626.0
2013-01-24 18:30:00	SPY	ETF	149.23	149.26	149.21	149.21	8835.0
2013-01-24 19:00:00	SPY	ETF	149.23	149.25	149.09	149.09	118781.0
2013-01-24 19:30:00	SPY	ETF	149.11	149.24	149.1	149.24	74055.0
2013-01-24 04:00:00	QQQ	ETF	66.73	66.8	66.73	66.8	1600.0
2013-01-24 04:30:00	QQQ	ETF	66.81	66.81	66.81	66.81	5000.0
2013-01-24 05:00:00	QQQ	ETF	66.8	66.84	66.8	66.84	4604.0
2013-01-24 05:30:00	QQQ	ETF	66.85	66.85	66.8	66.8	1700.0
2013-01-24 06:00:00	QQQ	ETF	66.8	66.83	66.8	66.83	11580.0
2013-01-24 06:30:00	QQQ	ETF	66.81	66.81	66.73	66.73	1995.0
2013-01-24 07:00:00	QQQ	ETF	66.74	66.82	66.72	66.82	205874.0
2013-01-24 07:30:00	QQQ	ETF	66.8	66.85	66.78	66.82	347079.0
2013-01-24 08:00:00	QQQ	ETF	66.81	66.83	66.75	66.79	194045.0
2013-01-24 08:30:00	QQQ	ETF	66.79	66.81	66.65	66.73	476371.0
2013-01-24 09:00:00	QQQ	ETF	66.72	66.75	66.62	66.67	209713.0
2013-01-24 09:30:00	QQQ	ETF	66.68	67.11	66.649	67.08	8102162.0
2013-01-24 10:00:00	QQQ	ETF	67.07	67.21	67.01	67.16	3497670.0
2013-01-24 10:30:00	QQQ	ETF	67.1601	67.25	67.08	67.12	1953241.0
2013-01-24 11:00:00	QQQ	ETF	67.12	67.27	67.11	67.26	2584596.0
2013-01-24 11:30:00	QQQ	ETF	67.26	67.28	67.16	67.19	1142433.0
2013-01-24 12:00:00	QQQ	ETF	67.1899	67.2	67.04	67.0699	2291832.0
2013-01-24 12:30:00	QQQ	ETF	67.069	67.07	66.8	66.82	2082753.0

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

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