PREVIEW / etf_30min / 2009-02-04

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-04.parquet
  size:    201 KB
  rows:    6,644

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
2009-02-04 04:00:00	SPY	ETF	83.61	83.61	83.61	83.61	400.0
2009-02-04 04:30:00	SPY	ETF	83.73	83.98	83.73	83.98	200.0
2009-02-04 05:00:00	SPY	ETF	84.1	84.1	84.1	84.1	140.0
2009-02-04 05:30:00	SPY	ETF	84.11	84.11	83.9	83.9	700.0
2009-02-04 06:00:00	SPY	ETF	83.85	83.85	83.61	83.79	31740.0
2009-02-04 06:30:00	SPY	ETF	83.61	83.61	83.56	83.56	51000.0
2009-02-04 07:00:00	SPY	ETF	83.73	83.77	83.59	83.63	223640.0
2009-02-04 07:30:00	SPY	ETF	83.63	83.94	83.61	83.84	510413.0
2009-02-04 08:00:00	SPY	ETF	83.83	84.11	83.73	83.95	2104821.0
2009-02-04 08:30:00	SPY	ETF	83.94	84.48	83.94	84.08	2225451.0
2009-02-04 09:00:00	SPY	ETF	84.08	84.35	83.3	84.29	1336663.0
2009-02-04 09:30:00	SPY	ETF	84.3	84.84	83.92	84.76	27252381.0
2009-02-04 10:00:00	SPY	ETF	84.76	85.29	84.75	85.1	29412764.0
2009-02-04 10:30:00	SPY	ETF	85.1	85.37	84.87	85.09	22580447.0
2009-02-04 11:00:00	SPY	ETF	85.09	85.17	84.75	84.87	18538276.0
2009-02-04 11:30:00	SPY	ETF	84.87	84.97	84.64	84.71	12675437.0
2009-02-04 12:00:00	SPY	ETF	84.71	84.9	84.46	84.52	11486063.0
2009-02-04 12:30:00	SPY	ETF	84.52	84.81	84.4	84.47	12030919.0
2009-02-04 13:00:00	SPY	ETF	84.47	84.54	84.2	84.52	13555154.0
2009-02-04 13:30:00	SPY	ETF	84.52	84.56	83.18	83.57	36762297.0
2009-02-04 14:00:00	SPY	ETF	83.93	84.35	83.04	83.27	27894998.0
2009-02-04 14:30:00	SPY	ETF	83.27	84.75	83.1	83.71	29562594.0
2009-02-04 15:00:00	SPY	ETF	83.705	83.9982	83.25	83.45	29626956.0
2009-02-04 15:30:00	SPY	ETF	83.46	84.36	83.29	83.31	26803856.0
2009-02-04 16:00:00	SPY	ETF	83.3	84.26	83.28	83.37	10503654.0
2009-02-04 16:30:00	SPY	ETF	83.38	83.5	83.09	83.1	1862505.0
2009-02-04 17:00:00	SPY	ETF	83.08	83.33	82.85	83.01	1953090.0
2009-02-04 17:30:00	SPY	ETF	83.01	83.05	82.8	82.92	1117176.0
2009-02-04 18:00:00	SPY	ETF	82.93	83.72	82.9	83.01	119245.0
2009-02-04 18:30:00	SPY	ETF	83.02	83.06	82.99	83.05	38692.0
2009-02-04 19:00:00	SPY	ETF	83.06	83.06	82.81	82.81	60895.0
2009-02-04 19:30:00	SPY	ETF	82.83	82.88	82.81	82.83	22657.0
2009-02-04 04:00:00	QQQ	ETF	29.74	29.75	29.74	29.75	1100.0
2009-02-04 04:30:00	QQQ	ETF	29.8	29.83	29.8	29.83	700.0
2009-02-04 06:00:00	QQQ	ETF	29.82	29.83	29.74	29.74	22000.0
2009-02-04 06:30:00	QQQ	ETF	29.69	29.75	29.68	29.75	2100.0
2009-02-04 07:00:00	QQQ	ETF	29.78	29.81	29.74	29.76	247270.0
2009-02-04 07:30:00	QQQ	ETF	29.75	29.88	29.75	29.79	97263.0
2009-02-04 08:00:00	QQQ	ETF	29.83	29.88	29.71	29.82	1561055.0
2009-02-04 08:30:00	QQQ	ETF	29.83	29.98	29.83	29.9	1171048.0
2009-02-04 09:00:00	QQQ	ETF	29.89	29.95	29.84	29.94	3488906.0
2009-02-04 09:30:00	QQQ	ETF	29.925	30.36	29.85	30.33	19683552.0
2009-02-04 10:00:00	QQQ	ETF	30.33	30.55	30.33	30.51	15236599.0
2009-02-04 10:30:00	QQQ	ETF	30.51	30.65	30.45	30.54	10742986.0
2009-02-04 11:00:00	QQQ	ETF	30.54	30.59	30.47	30.512	9368661.0
2009-02-04 11:30:00	QQQ	ETF	30.52	30.5499	30.39	30.43	4643265.0
2009-02-04 12:00:00	QQQ	ETF	30.43	30.49	30.36	30.3676	4515021.0
2009-02-04 12:30:00	QQQ	ETF	30.36	30.42	30.28	30.2999	7614069.0
2009-02-04 13:00:00	QQQ	ETF	30.29	30.34	30.2	30.339	6996351.0
2009-02-04 13:30:00	QQQ	ETF	30.33	30.35	29.83	29.97	19322850.0

> showing 50 of 6,644 rows — these rows as CSV

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