PREVIEW / etf_30min / 2007-02-15

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-15.parquet
  size:    100 KB
  rows:    3,543

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
2007-02-15 05:00:00	SPY	ETF	145.56	145.56	145.56	145.56	100.0
2007-02-15 07:00:00	SPY	ETF	145.68	145.68	145.68	145.68	6000.0
2007-02-15 07:30:00	SPY	ETF	145.65	145.66	145.61	145.62	62900.0
2007-02-15 08:00:00	SPY	ETF	145.62	145.62	145.56	145.57	200200.0
2007-02-15 08:30:00	SPY	ETF	145.57	145.73	145.45	145.71	188200.0
2007-02-15 09:00:00	SPY	ETF	145.71	145.79	145.66	145.69	394300.0
2007-02-15 09:30:00	SPY	ETF	145.67	145.69	145.48	145.68	3641200.0
2007-02-15 10:00:00	SPY	ETF	145.68	145.85	145.58	145.62	4137400.0
2007-02-15 10:30:00	SPY	ETF	145.62	145.74	145.43	145.48	3578200.0
2007-02-15 11:00:00	SPY	ETF	145.48	145.73	145.46	145.72	2679500.0
2007-02-15 11:30:00	SPY	ETF	145.7275	145.78	145.66	145.78	1657800.0
2007-02-15 12:00:00	SPY	ETF	145.77	145.79	145.52	145.69	2974000.0
2007-02-15 12:30:00	SPY	ETF	145.7	145.73	145.65	145.69	870900.0
2007-02-15 13:00:00	SPY	ETF	145.69	145.75	145.64	145.69	1552500.0
2007-02-15 13:30:00	SPY	ETF	145.69	145.81	145.69	145.79	1118800.0
2007-02-15 14:00:00	SPY	ETF	145.79	145.9	145.73	145.8	1815700.0
2007-02-15 14:30:00	SPY	ETF	145.8	145.91	145.75	145.84	2170800.0
2007-02-15 15:00:00	SPY	ETF	145.84	145.87	145.71	145.85	3844200.0
2007-02-15 15:30:00	SPY	ETF	145.84	145.95	145.78	145.83	4985300.0
2007-02-15 16:00:00	SPY	ETF	145.83	145.85	145.7	145.76	626900.0
2007-02-15 16:30:00	SPY	ETF	145.75	145.75	145.54	145.62	439800.0
2007-02-15 17:00:00	SPY	ETF	145.67	145.72	145.61	145.72	502200.0
2007-02-15 17:30:00	SPY	ETF	145.7	145.7	145.6	145.68	48500.0
2007-02-15 18:00:00	SPY	ETF	145.68	145.68	145.68	145.68	10000.0
2007-02-15 18:30:00	SPY	ETF	145.67	145.67	145.67	145.67	500.0
2007-02-15 19:00:00	SPY	ETF	145.61	145.61	145.57	145.57	3400.0
2007-02-15 19:30:00	SPY	ETF	145.56	145.56	145.55	145.55	1700.0
2007-02-15 04:30:00	QQQ	ETF	44.61	44.61	44.61	44.61	200.0
2007-02-15 06:30:00	QQQ	ETF	44.57	44.57	44.57	44.57	1000.0
2007-02-15 07:00:00	QQQ	ETF	44.57	44.57	44.57	44.57	1300.0
2007-02-15 07:30:00	QQQ	ETF	44.57	44.61	44.57	44.6	567472.0
2007-02-15 08:00:00	QQQ	ETF	44.59	44.59	44.53	44.54	1097567.0
2007-02-15 08:30:00	QQQ	ETF	44.54	44.64	44.54	44.63	448587.0
2007-02-15 09:00:00	QQQ	ETF	44.63	44.68	44.61	44.63	897229.0
2007-02-15 09:30:00	QQQ	ETF	44.63	44.72	44.55	44.71	11351900.0
2007-02-15 10:00:00	QQQ	ETF	44.72	44.84	44.68	44.71	15116900.0
2007-02-15 10:30:00	QQQ	ETF	44.71	44.76	44.6	44.62	9553300.0
2007-02-15 11:00:00	QQQ	ETF	44.62	44.72	44.61	44.71	6916600.0
2007-02-15 11:30:00	QQQ	ETF	44.71	44.74	44.64	44.73	3691900.0
2007-02-15 12:00:00	QQQ	ETF	44.73	44.77	44.6	44.68	10812700.0
2007-02-15 12:30:00	QQQ	ETF	44.69	44.71	44.66	44.68	1690600.0
2007-02-15 13:00:00	QQQ	ETF	44.69	44.71	44.67	44.68	2622300.0
2007-02-15 13:30:00	QQQ	ETF	44.69	44.72	44.68	44.71	2803200.0
2007-02-15 14:00:00	QQQ	ETF	44.72	44.78	44.68	44.73	4327800.0
2007-02-15 14:30:00	QQQ	ETF	44.72	44.81	44.72	44.79	4362000.0
2007-02-15 15:00:00	QQQ	ETF	44.79	44.8	44.73	44.77	3529200.0
2007-02-15 15:30:00	QQQ	ETF	44.78	44.85	44.75	44.81	9864900.0
2007-02-15 16:00:00	QQQ	ETF	44.81	44.86	44.79	44.79	1835300.0
2007-02-15 16:30:00	QQQ	ETF	44.8	44.81	44.7	44.76	3359008.0
2007-02-15 17:00:00	QQQ	ETF	44.77	44.8	44.76	44.78	1176358.0

> showing 50 of 3,543 rows — these rows as CSV

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