PREVIEW / etf_30min / 2010-01-04

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-04.parquet
  size:    242 KB
  rows:    8,293

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
2010-01-04 04:00:00	SPY	ETF	112.25	112.25	112.2	112.2	31999.0
2010-01-04 04:30:00	SPY	ETF	112.2	112.23	112.17	112.23	1075.0
2010-01-04 05:00:00	SPY	ETF	112.22	112.22	112.2	112.22	1400.0
2010-01-04 05:30:00	SPY	ETF	112.16	112.25	112.14	112.25	5600.0
2010-01-04 06:00:00	SPY	ETF	112.22	112.22	112.21	112.22	12540.0
2010-01-04 06:30:00	SPY	ETF	112.22	112.23	112.16	112.2	5450.0
2010-01-04 07:00:00	SPY	ETF	112.2	112.2	112.15	112.17	29400.0
2010-01-04 07:30:00	SPY	ETF	112.17	112.19	112.12	112.15	110708.0
2010-01-04 08:00:00	SPY	ETF	112.12	112.18	112.09	112.15	2447926.0
2010-01-04 08:30:00	SPY	ETF	112.16	112.33	112.14	112.32	1367484.0
2010-01-04 09:00:00	SPY	ETF	112.33	112.46	111.44	112.36	1239935.0
2010-01-04 09:30:00	SPY	ETF	112.37	112.94	112.33	112.83	22176565.0
2010-01-04 10:00:00	SPY	ETF	112.84	113.1	112.73	113.085	13792897.0
2010-01-04 10:30:00	SPY	ETF	113.08	113.24	113.06	113.1	8573758.0
2010-01-04 11:00:00	SPY	ETF	113.1	113.29	113.1	113.23	5731663.0
2010-01-04 11:30:00	SPY	ETF	113.2201	113.39	113.2	113.275	6458421.0
2010-01-04 12:00:00	SPY	ETF	113.28	113.31	113.25	113.3	3627314.0
2010-01-04 12:30:00	SPY	ETF	113.3	113.36	113.27	113.295	5131608.0
2010-01-04 13:00:00	SPY	ETF	113.33	113.38	113.28	113.366	3230552.0
2010-01-04 13:30:00	SPY	ETF	113.37	113.38	113.17	113.19	3943838.0
2010-01-04 14:00:00	SPY	ETF	113.2	113.24	113.17	113.2125	4809674.0
2010-01-04 14:30:00	SPY	ETF	113.22	113.38	113.215	113.28	5206964.0
2010-01-04 15:00:00	SPY	ETF	113.28	113.36	113.21	113.255	4566696.0
2010-01-04 15:30:00	SPY	ETF	113.25	113.32	113.18	113.32	14677124.0
2010-01-04 16:00:00	SPY	ETF	113.3	113.33	113.0643	113.28	10032277.0
2010-01-04 16:30:00	SPY	ETF	113.28	113.31	113.22	113.29	510290.0
2010-01-04 17:00:00	SPY	ETF	113.29	113.31	113.25	113.26	87571.0
2010-01-04 17:30:00	SPY	ETF	113.26	113.29	113.25	113.29	10222.0
2010-01-04 18:00:00	SPY	ETF	113.26	113.33	113.21	113.23	23838.0
2010-01-04 18:30:00	SPY	ETF	113.26	113.27	113.18	113.26	32284.0
2010-01-04 19:00:00	SPY	ETF	113.23	113.23	113.21	113.21	700.0
2010-01-04 19:30:00	SPY	ETF	113.22	113.22	113.16	113.21	30350.0
2010-01-04 04:00:00	QQQ	ETF	46.19	46.2	46.19	46.2	1100.0
2010-01-04 04:30:00	QQQ	ETF	46.24	46.24	46.23	46.23	460.0
2010-01-04 05:00:00	QQQ	ETF	46.24	46.24	46.21	46.21	300.0
2010-01-04 05:30:00	QQQ	ETF	46.25	46.25	46.23	46.23	5350.0
2010-01-04 06:00:00	QQQ	ETF	46.21	46.24	46.2	46.2	8800.0
2010-01-04 06:30:00	QQQ	ETF	46.2	46.24	46.2	46.24	22200.0
2010-01-04 07:00:00	QQQ	ETF	46.22	46.25	46.2	46.21	45361.0
2010-01-04 07:30:00	QQQ	ETF	46.2	46.22	46.19	46.21	44525.0
2010-01-04 08:00:00	QQQ	ETF	46.19	46.24	45.92	46.18	1681056.0
2010-01-04 08:30:00	QQQ	ETF	46.18	46.33	46.18	46.32	1168234.0
2010-01-04 09:00:00	QQQ	ETF	46.33	46.39	46.29	46.32	1554943.0
2010-01-04 09:30:00	QQQ	ETF	46.32	46.44	46.27	46.35	13448055.0
2010-01-04 10:00:00	QQQ	ETF	46.36	46.42	46.28	46.41	7091343.0
2010-01-04 10:30:00	QQQ	ETF	46.41	46.48	46.39	46.4	5641615.0
2010-01-04 11:00:00	QQQ	ETF	46.39	46.46	46.39	46.42	3192468.0
2010-01-04 11:30:00	QQQ	ETF	46.405	46.47	46.39	46.425	2858794.0
2010-01-04 12:00:00	QQQ	ETF	46.43	46.45	46.41	46.45	1313749.0
2010-01-04 12:30:00	QQQ	ETF	46.4401	46.46	46.41	46.43	1389321.0

> showing 50 of 8,293 rows — these rows as CSV

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