PREVIEW / etf_30min / 2006-01-25

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-25.parquet
  size:    60 KB
  rows:    2,143

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
2006-01-25 06:30:00	SPY	ETF	126.95	126.95	126.95	126.95	1000.0
2006-01-25 07:00:00	SPY	ETF	126.99	127.09	126.99	127.09	53700.0
2006-01-25 07:30:00	SPY	ETF	127.09	127.12	126.99	127.04	38400.0
2006-01-25 08:00:00	SPY	ETF	127.01	127.13	126.93	127.04	816800.0
2006-01-25 08:30:00	SPY	ETF	127.01	127.05	126.92	126.97	179400.0
2006-01-25 09:00:00	SPY	ETF	126.96	127.01	126.91	127.01	199500.0
2006-01-25 09:30:00	SPY	ETF	127.04	127.11	126.85	127.02	5105100.0
2006-01-25 10:00:00	SPY	ETF	127.02	127.18	126.28	126.51	12602200.0
2006-01-25 10:30:00	SPY	ETF	126.5	126.84	126.37	126.84	7807900.0
2006-01-25 11:00:00	SPY	ETF	126.82	126.99	126.75	126.86	4084700.0
2006-01-25 11:30:00	SPY	ETF	126.87	126.91	126.4	126.57	5554800.0
2006-01-25 12:00:00	SPY	ETF	126.58	126.58	126.01	126.14	7673100.0
2006-01-25 12:30:00	SPY	ETF	126.14	126.6	126.13	126.55	4903700.0
2006-01-25 13:00:00	SPY	ETF	126.58	126.77	126.4	126.49	3746500.0
2006-01-25 13:30:00	SPY	ETF	126.49	126.53	126.22	126.3101	1783000.0
2006-01-25 14:00:00	SPY	ETF	126.31	126.44	126.14	126.17	3498700.0
2006-01-25 14:30:00	SPY	ETF	126.18	126.32	125.84	125.92	8296600.0
2006-01-25 15:00:00	SPY	ETF	125.93	126.31	125.89	126.28	6375600.0
2006-01-25 15:30:00	SPY	ETF	126.28	126.49	126.14	126.47	5636100.0
2006-01-25 16:00:00	SPY	ETF	126.49	126.69	126.3744	126.43	735000.0
2006-01-25 16:30:00	SPY	ETF	126.63	126.84	126.43	126.81	1150800.0
2006-01-25 17:00:00	SPY	ETF	126.81	126.81	126.74	126.77	3600.0
2006-01-25 17:30:00	SPY	ETF	126.8	126.8	126.73	126.73	21800.0
2006-01-25 18:00:00	SPY	ETF	126.74	126.79	126.73	126.79	24000.0
2006-01-25 18:30:00	SPY	ETF	126.76	126.76	126.74	126.75	1900.0
2006-01-25 19:00:00	SPY	ETF	126.76	126.87	126.75	126.87	6200.0
2006-01-25 19:30:00	SPY	ETF	126.83	126.86	126.83	126.86	400.0
2006-01-25 09:30:00	QQQ	ETF	41.64	41.67	41.52	41.54	8271300.0
2006-01-25 10:00:00	QQQ	ETF	41.53	41.6	41.15	41.29	12341100.0
2006-01-25 10:30:00	QQQ	ETF	41.29	41.43	41.18	41.38	8850800.0
2006-01-25 11:00:00	QQQ	ETF	41.38	41.54	41.34	41.49	5703700.0
2006-01-25 11:30:00	QQQ	ETF	41.48	41.5	41.22	41.34	7306100.0
2006-01-25 12:00:00	QQQ	ETF	41.34	41.34	41.09	41.13	8632700.0
2006-01-25 12:30:00	QQQ	ETF	41.13	41.31	41.13	41.31	6171400.0
2006-01-25 13:00:00	QQQ	ETF	41.31	41.37	41.27	41.32	3904600.0
2006-01-25 13:30:00	QQQ	ETF	41.32	41.35	41.22	41.27	2833300.0
2006-01-25 14:00:00	QQQ	ETF	41.27	41.32	41.17	41.22	3561000.0
2006-01-25 14:30:00	QQQ	ETF	41.23	41.31	41.08	41.12	12148100.0
2006-01-25 15:00:00	QQQ	ETF	41.12	41.23	41.1	41.22	6029800.0
2006-01-25 15:30:00	QQQ	ETF	41.21	41.25	41.15	41.24	7020500.0
2006-01-25 07:00:00	IWM	ETF	71.45	71.46	71.45	71.46	10000.0
2006-01-25 07:30:00	IWM	ETF	71.47	71.48	71.47	71.48	13900.0
2006-01-25 08:00:00	IWM	ETF	71.4	71.48	71.4	71.4	117400.0
2006-01-25 08:30:00	IWM	ETF	71.37	71.41	71.33	71.41	89700.0
2006-01-25 09:00:00	IWM	ETF	71.4	71.4	71.35	71.4	119700.0
2006-01-25 09:30:00	IWM	ETF	71.39	71.57	71.24	71.49	2806100.0
2006-01-25 10:00:00	IWM	ETF	71.49	71.6	71.08	71.23	4035300.0
2006-01-25 10:30:00	IWM	ETF	71.24	71.43	71.12	71.41	2465700.0
2006-01-25 11:00:00	IWM	ETF	71.41	71.52	71.34	71.48	1101300.0
2006-01-25 11:30:00	IWM	ETF	71.48	71.51	71.13	71.24	3859800.0

> showing 50 of 2,143 rows — these rows as CSV

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