PREVIEW / etf_30min / 2008-04-25

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-25.parquet
  size:    159 KB
  rows:    5,582

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-04-25 04:00:00	SPY	ETF	139.0	139.0	139.0	139.0	100.0
2008-04-25 04:30:00	SPY	ETF	139.01	139.04	139.0	139.04	151100.0
2008-04-25 05:00:00	SPY	ETF	139.0	139.0	139.0	139.0	32800.0
2008-04-25 05:30:00	SPY	ETF	139.0	139.0	138.95	138.95	68600.0
2008-04-25 06:00:00	SPY	ETF	139.0	139.15	139.0	139.1	248200.0
2008-04-25 06:30:00	SPY	ETF	139.11	139.16	138.99	138.99	168700.0
2008-04-25 07:00:00	SPY	ETF	138.99	139.03	138.82	139.03	301255.0
2008-04-25 07:30:00	SPY	ETF	139.0	139.4	139.0	139.35	413230.0
2008-04-25 08:00:00	SPY	ETF	139.35	139.35	139.13	139.13	886742.0
2008-04-25 08:30:00	SPY	ETF	139.14	139.43	139.14	139.26	2168947.0
2008-04-25 09:00:00	SPY	ETF	139.25	139.6	139.24	139.4	1623787.0
2008-04-25 09:30:00	SPY	ETF	139.41	139.53	138.88	138.89	16974862.0
2008-04-25 10:00:00	SPY	ETF	138.89	139.12	138.6	139.02	21833112.0
2008-04-25 10:30:00	SPY	ETF	139.02	139.21	138.58	138.92	18864544.0
2008-04-25 11:00:00	SPY	ETF	138.91	139.0	137.91	138.19	18956811.0
2008-04-25 11:30:00	SPY	ETF	138.2	138.69	138.19	138.61	14703537.0
2008-04-25 12:00:00	SPY	ETF	138.62	138.79	138.44	138.6	5063002.0
2008-04-25 12:30:00	SPY	ETF	138.59	138.8345	138.4	138.54	7111517.0
2008-04-25 13:00:00	SPY	ETF	138.54	138.8343	138.39	138.4915	5022804.0
2008-04-25 13:30:00	SPY	ETF	138.5	138.93	138.29	138.91	6742367.0
2008-04-25 14:00:00	SPY	ETF	138.912	139.06	138.82	138.98	9161537.0
2008-04-25 14:30:00	SPY	ETF	138.98	139.18	138.88	139.14	10954985.0
2008-04-25 15:00:00	SPY	ETF	139.14	139.89	139.07	139.68	22519143.0
2008-04-25 15:30:00	SPY	ETF	139.68	139.84	138.31	139.76	20134371.0
2008-04-25 16:00:00	SPY	ETF	139.75	139.78	138.7453	139.62	1543803.0
2008-04-25 16:30:00	SPY	ETF	139.64	139.65	138.8343	139.6	1139396.0
2008-04-25 17:00:00	SPY	ETF	139.57	139.6	138.86	139.42	42814.0
2008-04-25 17:30:00	SPY	ETF	139.52	139.6	139.47	139.5	2002220.0
2008-04-25 18:00:00	SPY	ETF	139.53	139.53	139.42	139.43	9728.0
2008-04-25 18:30:00	SPY	ETF	139.47	139.47	139.45	139.45	500.0
2008-04-25 19:00:00	SPY	ETF	139.53	139.6	139.53	139.6	8346.0
2008-04-25 19:30:00	SPY	ETF	139.6	139.6	139.6	139.6	4945.0
2008-04-25 04:30:00	QQQ	ETF	47.28	47.28	47.28	47.28	200.0
2008-04-25 05:00:00	QQQ	ETF	47.29	47.29	47.29	47.29	100.0
2008-04-25 05:30:00	QQQ	ETF	47.27	47.27	47.27	47.27	100.0
2008-04-25 06:00:00	QQQ	ETF	47.31	47.31	47.3	47.3	22100.0
2008-04-25 06:30:00	QQQ	ETF	47.3	47.33	47.27	47.33	82700.0
2008-04-25 07:00:00	QQQ	ETF	47.29	47.29	47.18	47.25	188140.0
2008-04-25 07:30:00	QQQ	ETF	47.24	47.4	47.24	47.36	189412.0
2008-04-25 08:00:00	QQQ	ETF	47.38	47.39	47.29	47.29	767264.0
2008-04-25 08:30:00	QQQ	ETF	47.33	47.38	47.29	47.33	1411022.0
2008-04-25 09:00:00	QQQ	ETF	47.33	47.39	47.31	47.32	736277.0
2008-04-25 09:30:00	QQQ	ETF	47.32	47.35	46.78	46.8699	24159369.0
2008-04-25 10:00:00	QQQ	ETF	46.87	47.06	46.77	46.99	11242269.0
2008-04-25 10:30:00	QQQ	ETF	46.9999	47.08	46.81	46.92	9921393.0
2008-04-25 11:00:00	QQQ	ETF	46.92	46.96	46.58	46.68	10967429.0
2008-04-25 11:30:00	QQQ	ETF	46.68	46.89	46.67	46.82	7449279.0
2008-04-25 12:00:00	QQQ	ETF	46.82	46.87	46.71	46.7499	4788158.0
2008-04-25 12:30:00	QQQ	ETF	46.75	46.83	46.65	46.71	4959596.0
2008-04-25 13:00:00	QQQ	ETF	46.7195	46.78	46.62	46.65	2929243.0

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

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