PREVIEW / etf_30min / 2008-01-09

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-09.parquet
  size:    161 KB
  rows:    5,736

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-01-09 04:00:00	SPY	ETF	139.36	139.36	139.34	139.34	3000.0
2008-01-09 04:30:00	SPY	ETF	139.1	139.2	139.1	139.2	3200.0
2008-01-09 05:00:00	SPY	ETF	139.25	139.25	139.25	139.25	1000.0
2008-01-09 05:30:00	SPY	ETF	139.23	139.46	139.23	139.3	101300.0
2008-01-09 06:00:00	SPY	ETF	139.35	139.73	139.35	139.67	12800.0
2008-01-09 06:30:00	SPY	ETF	139.54	139.63	139.42	139.54	117300.0
2008-01-09 07:00:00	SPY	ETF	139.55	139.64	138.93	139.1	646300.0
2008-01-09 07:30:00	SPY	ETF	139.05	139.37	139.03	139.09	604500.0
2008-01-09 08:00:00	SPY	ETF	139.615	139.615	138.73	139.12	1669600.0
2008-01-09 08:30:00	SPY	ETF	139.13	139.24	138.64	138.71	2669329.0
2008-01-09 09:00:00	SPY	ETF	138.73	139.11	138.55	139.01	2426271.0
2008-01-09 09:30:00	SPY	ETF	139.01	139.6	138.72	139.33	35919889.0
2008-01-09 10:00:00	SPY	ETF	139.35	139.89	139.01	139.33	27299302.0
2008-01-09 10:30:00	SPY	ETF	139.33	139.68	139.05	139.55	17515558.0
2008-01-09 11:00:00	SPY	ETF	139.52	139.67	139.1	139.17	12564001.0
2008-01-09 11:30:00	SPY	ETF	139.18	139.18	138.0	138.67	17628844.0
2008-01-09 12:00:00	SPY	ETF	138.66	139.38	138.51	139.3	12730917.0
2008-01-09 12:30:00	SPY	ETF	139.29	139.34	138.76	139.11	7392467.0
2008-01-09 13:00:00	SPY	ETF	139.11	139.29	138.47	138.63	10412097.0
2008-01-09 13:30:00	SPY	ETF	138.63	139.62	138.0	138.21	17397645.0
2008-01-09 14:00:00	SPY	ETF	138.21	138.38	137.7	138.34	18862774.0
2008-01-09 14:30:00	SPY	ETF	138.34	139.36	138.18	139.16	30488178.0
2008-01-09 15:00:00	SPY	ETF	139.16	140.48	139.08	139.72	42642910.0
2008-01-09 15:30:00	SPY	ETF	139.7201	140.79	139.33	140.78	31571770.0
2008-01-09 16:00:00	SPY	ETF	140.77	140.8	138.8	140.35	5331400.0
2008-01-09 16:30:00	SPY	ETF	140.4	140.64	139.28	140.58	2139400.0
2008-01-09 17:00:00	SPY	ETF	140.58	140.76	137.8	140.73	862700.0
2008-01-09 17:30:00	SPY	ETF	140.74	140.84	140.73	140.79	29600.0
2008-01-09 18:00:00	SPY	ETF	140.75	140.75	140.69	140.71	43900.0
2008-01-09 18:30:00	SPY	ETF	140.71	140.74	140.68	140.68	11000.0
2008-01-09 19:00:00	SPY	ETF	140.6	140.72	140.54	140.61	22700.0
2008-01-09 19:30:00	SPY	ETF	140.48	140.52	140.45	140.48	7900.0
2008-01-09 04:30:00	QQQ	ETF	47.06	47.06	47.06	47.06	100.0
2008-01-09 05:30:00	QQQ	ETF	47.21	47.21	47.21	47.21	100.0
2008-01-09 06:00:00	QQQ	ETF	47.2	47.29	47.2	47.23	50400.0
2008-01-09 06:30:00	QQQ	ETF	47.23	47.33	47.23	47.25	76830.0
2008-01-09 07:00:00	QQQ	ETF	47.25	47.25	47.09	47.14	211933.0
2008-01-09 07:30:00	QQQ	ETF	47.14	47.16	47.1	47.16	338510.0
2008-01-09 08:00:00	QQQ	ETF	47.13	47.21	47.0	47.13	996908.0
2008-01-09 08:30:00	QQQ	ETF	47.15	47.18	46.98	47.0	628441.0
2008-01-09 09:00:00	QQQ	ETF	47.01	47.13	46.86	47.1	2301274.0
2008-01-09 09:30:00	QQQ	ETF	47.09	47.48	46.88	47.32	28833306.0
2008-01-09 10:00:00	QQQ	ETF	47.32	47.58	47.03	47.33	31871048.0
2008-01-09 10:30:00	QQQ	ETF	47.33	47.46	47.13	47.38	19040240.0
2008-01-09 11:00:00	QQQ	ETF	47.38	47.45	47.09	47.1299	10013278.0
2008-01-09 11:30:00	QQQ	ETF	47.1299	47.13	46.77	46.99	13870968.0
2008-01-09 12:00:00	QQQ	ETF	46.99	47.24	46.92	47.2301	12278946.0
2008-01-09 12:30:00	QQQ	ETF	47.23	47.23	46.94	47.1	7673767.0
2008-01-09 13:00:00	QQQ	ETF	47.1	47.17	46.83	46.88	11597083.0
2008-01-09 13:30:00	QQQ	ETF	46.8881	46.96	46.65	46.78	12886547.0

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

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