PREVIEW / etf_30min / 2008-04-08

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-08.parquet
  size:    148 KB
  rows:    5,669

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
2008-04-08 04:30:00	SPY	ETF	136.37	136.44	136.37	136.44	200.0
2008-04-08 05:00:00	SPY	ETF	136.3	136.3	136.3	136.3	100.0
2008-04-08 05:30:00	SPY	ETF	136.21	136.24	136.21	136.24	8100.0
2008-04-08 06:30:00	SPY	ETF	136.37	136.37	136.15	136.25	35100.0
2008-04-08 07:00:00	SPY	ETF	136.27	136.4	136.2	136.3	150300.0
2008-04-08 07:30:00	SPY	ETF	136.26	136.46	136.21	136.45	239100.0
2008-04-08 08:00:00	SPY	ETF	136.45	136.45	136.21	136.26	1355100.0
2008-04-08 08:30:00	SPY	ETF	136.24	136.4	136.22	136.36	480100.0
2008-04-08 09:00:00	SPY	ETF	136.36	136.45	136.16	136.19	2761700.0
2008-04-08 09:30:00	SPY	ETF	136.19	136.58	136.1	136.52	14806337.0
2008-04-08 10:00:00	SPY	ETF	136.53	136.72	136.23	136.51	15419583.0
2008-04-08 10:30:00	SPY	ETF	136.51	136.89	136.47	136.71	8617806.0
2008-04-08 11:00:00	SPY	ETF	136.71	136.8	136.54	136.72	5765060.0
2008-04-08 11:30:00	SPY	ETF	136.72	137.1554	136.45	136.54	9379361.0
2008-04-08 12:00:00	SPY	ETF	136.53	136.7	136.38	136.52	7154554.0
2008-04-08 12:30:00	SPY	ETF	136.52	136.69	136.48	136.5	3396147.0
2008-04-08 13:00:00	SPY	ETF	136.5	136.6	136.31	136.36	5557128.0
2008-04-08 13:30:00	SPY	ETF	136.35	136.58	136.27	136.48	5889510.0
2008-04-08 14:00:00	SPY	ETF	136.48	136.52	135.95	136.18	17283288.0
2008-04-08 14:30:00	SPY	ETF	136.17	136.63	136.08	136.58	12086309.0
2008-04-08 15:00:00	SPY	ETF	136.57	136.58	136.13	136.4	10437364.0
2008-04-08 15:30:00	SPY	ETF	136.4	136.73	136.37	136.46	18559119.0
2008-04-08 16:00:00	SPY	ETF	136.6	136.88	136.46	136.79	2079900.0
2008-04-08 16:30:00	SPY	ETF	136.79	137.1554	136.77	136.81	3404100.0
2008-04-08 17:00:00	SPY	ETF	136.79	136.8	136.45	136.7	707000.0
2008-04-08 17:30:00	SPY	ETF	136.7	136.77	136.56	136.74	473600.0
2008-04-08 18:00:00	SPY	ETF	136.74	137.11	136.74	137.0	260400.0
2008-04-08 18:30:00	SPY	ETF	137.0	137.17	137.0	137.07	68100.0
2008-04-08 19:00:00	SPY	ETF	137.04	137.26	137.02	137.22	202700.0
2008-04-08 19:30:00	SPY	ETF	137.21	137.22	136.98	137.11	34800.0
2008-04-08 05:00:00	QQQ	ETF	45.52	45.52	45.52	45.52	400.0
2008-04-08 05:30:00	QQQ	ETF	45.5	45.5	45.5	45.5	200.0
2008-04-08 06:30:00	QQQ	ETF	45.56	45.56	45.47	45.49	56879.0
2008-04-08 07:00:00	QQQ	ETF	45.52	45.52	45.46	45.49	224022.0
2008-04-08 07:30:00	QQQ	ETF	45.49	45.5	45.47	45.49	121670.0
2008-04-08 08:00:00	QQQ	ETF	45.49	45.52	45.4	45.4	2940136.0
2008-04-08 08:30:00	QQQ	ETF	45.4	45.45	45.38	45.44	659110.0
2008-04-08 09:00:00	QQQ	ETF	45.45	45.45	45.39	45.41	778837.0
2008-04-08 09:30:00	QQQ	ETF	45.41	45.48	45.32	45.451	11473905.0
2008-04-08 10:00:00	QQQ	ETF	45.46	45.57	45.33	45.5	9980713.0
2008-04-08 10:30:00	QQQ	ETF	45.49	45.7	45.48	45.62	7486609.0
2008-04-08 11:00:00	QQQ	ETF	45.62	45.7	45.57	45.66	3341514.0
2008-04-08 11:30:00	QQQ	ETF	45.66	45.72	45.4801	45.5026	5761001.0
2008-04-08 12:00:00	QQQ	ETF	45.51	45.6	45.48	45.549	3535046.0
2008-04-08 12:30:00	QQQ	ETF	45.55	45.58	45.51	45.52	1949926.0
2008-04-08 13:00:00	QQQ	ETF	45.52	45.56	45.43	45.43	4374241.0
2008-04-08 13:30:00	QQQ	ETF	45.4301	45.56	45.4	45.488	4492075.0
2008-04-08 14:00:00	QQQ	ETF	45.48	45.48	45.18	45.292	13050719.0
2008-04-08 14:30:00	QQQ	ETF	45.3	45.45	45.26	45.43	5865520.0
2008-04-08 15:00:00	QQQ	ETF	45.44	45.44	45.27	45.39	5390397.0

> showing 50 of 5,669 rows — these rows as CSV

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