PREVIEW / etf_30min / 2007-04-27

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-27.parquet
  size:    104 KB
  rows:    3,703

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-04-27 06:30:00	SPY	ETF	149.42	149.42	149.33	149.33	16000.0
2007-04-27 07:00:00	SPY	ETF	149.37	149.37	149.28	149.3	367800.0
2007-04-27 07:30:00	SPY	ETF	149.28	149.38	149.21	149.37	326100.0
2007-04-27 08:00:00	SPY	ETF	149.37	149.53	149.3	149.5	2100400.0
2007-04-27 08:30:00	SPY	ETF	149.4	149.45	148.91	149.0	7101900.0
2007-04-27 09:00:00	SPY	ETF	149.02	149.15	148.99	149.03	1128275.0
2007-04-27 09:30:00	SPY	ETF	149.03	149.23	148.9	149.11	15091640.0
2007-04-27 10:00:00	SPY	ETF	149.11	149.41	149.1	149.27	9535241.0
2007-04-27 10:30:00	SPY	ETF	149.27	149.4203	148.84	149.05	10626083.0
2007-04-27 11:00:00	SPY	ETF	149.04	149.29	149.01	149.17	6322067.0
2007-04-27 11:30:00	SPY	ETF	149.17	149.36	149.06	149.35	5447311.0
2007-04-27 12:00:00	SPY	ETF	149.36	149.4203	149.18	149.25	4012750.0
2007-04-27 12:30:00	SPY	ETF	149.25	149.47	149.21	149.3	3233300.0
2007-04-27 13:00:00	SPY	ETF	149.3	149.45	149.29	149.45	2772100.0
2007-04-27 13:30:00	SPY	ETF	149.45	149.66	149.4	149.49	5886988.0
2007-04-27 14:00:00	SPY	ETF	149.48	149.7	149.44	149.56	4434864.0
2007-04-27 14:30:00	SPY	ETF	149.56	149.74	149.53	149.63	4141417.0
2007-04-27 15:00:00	SPY	ETF	149.63	149.65	149.4	149.42	6582847.0
2007-04-27 15:30:00	SPY	ETF	149.42	149.56	149.22	149.4	11713771.0
2007-04-27 16:00:00	SPY	ETF	149.4	149.59	149.28	149.51	4474400.0
2007-04-27 16:30:00	SPY	ETF	149.51	149.6	149.51	149.6	39800.0
2007-04-27 17:00:00	SPY	ETF	149.53	149.61	149.53	149.61	4400.0
2007-04-27 17:30:00	SPY	ETF	149.55	149.57	149.55	149.57	1208000.0
2007-04-27 18:30:00	SPY	ETF	149.55	149.6	149.55	149.6	600.0
2007-04-27 19:00:00	SPY	ETF	149.6	149.64	149.6	149.61	2300.0
2007-04-27 19:30:00	SPY	ETF	149.65	149.67	149.65	149.67	3000.0
2007-04-27 07:00:00	QQQ	ETF	46.47	46.5	46.41	46.42	827000.0
2007-04-27 07:30:00	QQQ	ETF	46.45	46.48	46.42	46.47	292664.0
2007-04-27 08:00:00	QQQ	ETF	46.47	46.51	46.45	46.49	1594405.0
2007-04-27 08:30:00	QQQ	ETF	46.48	46.48	46.31	46.32	2662454.0
2007-04-27 09:00:00	QQQ	ETF	46.32	46.4	46.32	46.37	1087302.0
2007-04-27 09:30:00	QQQ	ETF	46.37	46.49	46.37	46.45	14054031.0
2007-04-27 10:00:00	QQQ	ETF	46.46	46.7	46.45	46.48	14397074.0
2007-04-27 10:30:00	QQQ	ETF	46.49	46.5	46.29	46.38	10047909.0
2007-04-27 11:00:00	QQQ	ETF	46.38	46.51	46.37	46.44	5670709.0
2007-04-27 11:30:00	QQQ	ETF	46.44	46.5	46.4	46.5	2858380.0
2007-04-27 12:00:00	QQQ	ETF	46.5	46.5	46.4	46.41	2332770.0
2007-04-27 12:30:00	QQQ	ETF	46.42	46.48	46.38	46.38	2216416.0
2007-04-27 13:00:00	QQQ	ETF	46.38	46.43	46.37	46.42	2766473.0
2007-04-27 13:30:00	QQQ	ETF	46.42	46.48	46.37	46.39	4882645.0
2007-04-27 14:00:00	QQQ	ETF	46.3926	46.51	46.38	46.48	5018847.0
2007-04-27 14:30:00	QQQ	ETF	46.48	46.56	46.47	46.52	5774738.0
2007-04-27 15:00:00	QQQ	ETF	46.52	46.55	46.48	46.49	4268306.0
2007-04-27 15:30:00	QQQ	ETF	46.49	46.52	46.38	46.51	13952305.0
2007-04-27 16:00:00	QQQ	ETF	46.52	46.61	46.51	46.58	1020624.0
2007-04-27 16:30:00	QQQ	ETF	46.59	46.6	46.52	46.53	206322.0
2007-04-27 17:00:00	QQQ	ETF	46.53	46.54	46.52	46.52	44245.0
2007-04-27 17:30:00	QQQ	ETF	46.52	46.54	46.51	46.54	8100.0
2007-04-27 18:00:00	QQQ	ETF	46.54	46.54	46.53	46.53	12300.0
2007-04-27 18:30:00	QQQ	ETF	46.54	46.61	46.54	46.6	23700.0

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

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