PREVIEW / etf_30min / 2006-05-18

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-05-18.parquet
  size:    67 KB
  rows:    2,396

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-05-18 04:00:00	SPY	ETF	127.56	127.56	127.56	127.56	100.0
2006-05-18 04:30:00	SPY	ETF	127.51	127.51	127.51	127.51	5000.0
2006-05-18 05:30:00	SPY	ETF	127.41	127.41	127.38	127.38	5000.0
2006-05-18 06:00:00	SPY	ETF	127.48	127.48	127.46	127.46	75000.0
2006-05-18 06:30:00	SPY	ETF	127.41	127.41	127.38	127.38	2500.0
2006-05-18 07:00:00	SPY	ETF	127.45	127.46	127.27	127.27	37300.0
2006-05-18 07:30:00	SPY	ETF	127.22	127.28	127.15	127.26	507600.0
2006-05-18 08:00:00	SPY	ETF	127.24	127.45	127.15	127.37	1353800.0
2006-05-18 08:30:00	SPY	ETF	127.38	127.55	127.25	127.49	1774000.0
2006-05-18 09:00:00	SPY	ETF	127.46	127.55	127.24	127.38	659100.0
2006-05-18 09:30:00	SPY	ETF	127.38	127.75	127.3	127.5	12129100.0
2006-05-18 10:00:00	SPY	ETF	127.51	127.7	127.27	127.54	8247300.0
2006-05-18 10:30:00	SPY	ETF	127.54	127.6	127.28	127.38	4084100.0
2006-05-18 11:00:00	SPY	ETF	127.4	127.54	127.04	127.49	9061700.0
2006-05-18 11:30:00	SPY	ETF	127.49	127.64	127.09	127.3	6861100.0
2006-05-18 12:00:00	SPY	ETF	127.29	127.59	127.12	127.4	6650100.0
2006-05-18 12:30:00	SPY	ETF	127.4	127.58	127.33	127.52	2267000.0
2006-05-18 13:00:00	SPY	ETF	127.52	127.58	127.32	127.51	2058700.0
2006-05-18 13:30:00	SPY	ETF	127.52	127.61	127.44	127.52	2276400.0
2006-05-18 14:00:00	SPY	ETF	127.52	127.53	127.23	127.29	2592300.0
2006-05-18 14:30:00	SPY	ETF	127.29	127.53	127.12	127.28	3025600.0
2006-05-18 15:00:00	SPY	ETF	127.31	127.33	126.73	126.84	7095500.0
2006-05-18 15:30:00	SPY	ETF	126.85	127.01	126.36	126.37	13343300.0
2006-05-18 16:00:00	SPY	ETF	126.36	126.43	126.11	126.24	1590600.0
2006-05-18 16:30:00	SPY	ETF	126.25	126.39	126.25	126.3	501100.0
2006-05-18 17:00:00	SPY	ETF	126.3	126.33	126.22	126.32	71300.0
2006-05-18 17:30:00	SPY	ETF	126.29	126.33	126.28	126.29	3900.0
2006-05-18 18:00:00	SPY	ETF	126.29	126.35	126.29	126.35	17800.0
2006-05-18 18:30:00	SPY	ETF	126.32	126.39	126.32	126.34	300.0
2006-05-18 19:00:00	SPY	ETF	126.38	126.38	126.33	126.35	2000.0
2006-05-18 19:30:00	SPY	ETF	126.35	126.44	126.35	126.44	11800.0
2006-05-18 09:30:00	QQQ	ETF	39.49	39.66	39.43	39.55	21479500.0
2006-05-18 10:00:00	QQQ	ETF	39.56	39.63	39.43	39.52	11332000.0
2006-05-18 10:30:00	QQQ	ETF	39.51	39.55	39.41	39.46	6269300.0
2006-05-18 11:00:00	QQQ	ETF	39.47	39.49	39.31	39.46	10446100.0
2006-05-18 11:30:00	QQQ	ETF	39.47	39.49	39.32	39.42	7362900.0
2006-05-18 12:00:00	QQQ	ETF	39.42	39.53	39.37	39.47	9828300.0
2006-05-18 12:30:00	QQQ	ETF	39.47	39.51	39.43	39.49	3879000.0
2006-05-18 13:00:00	QQQ	ETF	39.49	39.49	39.43	39.47	2215800.0
2006-05-18 13:30:00	QQQ	ETF	39.48	39.52	39.45	39.49	2778000.0
2006-05-18 14:00:00	QQQ	ETF	39.49	39.49	39.37	39.39	4388400.0
2006-05-18 14:30:00	QQQ	ETF	39.4	39.45	39.37	39.41	6750000.0
2006-05-18 15:00:00	QQQ	ETF	39.41	39.41	39.16	39.2	11873300.0
2006-05-18 15:30:00	QQQ	ETF	39.2	39.25	39.0	39.05	19613400.0
2006-05-18 07:30:00	IWM	ETF	72.1	72.1	72.1	72.1	10000.0
2006-05-18 08:00:00	IWM	ETF	72.2	72.26	72.11	72.26	61200.0
2006-05-18 08:30:00	IWM	ETF	72.27	72.45	71.96	72.42	3014800.0
2006-05-18 09:00:00	IWM	ETF	72.43	72.52	72.42	72.42	195800.0
2006-05-18 09:30:00	IWM	ETF	72.42	72.86	72.35	72.69	7154300.0
2006-05-18 10:00:00	IWM	ETF	72.68	72.81	72.5	72.65	5183900.0

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

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