PREVIEW / etf_30min / 2008-08-26

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-26.parquet
  size:    165 KB
  rows:    5,780

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-08-26 04:00:00	SPY	ETF	126.79	126.79	126.79	126.79	400.0
2008-08-26 04:30:00	SPY	ETF	126.85	126.85	126.85	126.85	400.0
2008-08-26 06:00:00	SPY	ETF	127.05	127.15	127.05	127.15	2500.0
2008-08-26 06:30:00	SPY	ETF	127.23	127.32	127.23	127.32	21000.0
2008-08-26 07:00:00	SPY	ETF	127.3	127.39	127.23	127.28	368223.0
2008-08-26 07:30:00	SPY	ETF	127.31	127.33	126.94	127.0	290299.0
2008-08-26 08:00:00	SPY	ETF	126.96	127.15	126.59	126.89	1507720.0
2008-08-26 08:30:00	SPY	ETF	126.87	127.11	126.79	127.08	986462.0
2008-08-26 09:00:00	SPY	ETF	127.11	127.12	126.81	127.01	1405682.0
2008-08-26 09:30:00	SPY	ETF	127.02	127.35	126.65	127.15	21617418.0
2008-08-26 10:00:00	SPY	ETF	127.15	127.49	127.13	127.43	16732831.0
2008-08-26 10:30:00	SPY	ETF	127.43	127.87	127.42	127.7	18719532.0
2008-08-26 11:00:00	SPY	ETF	127.69	127.76	127.42	127.47	8734957.0
2008-08-26 11:30:00	SPY	ETF	127.47	127.47	127.05	127.29	10156547.0
2008-08-26 12:00:00	SPY	ETF	127.2957	127.5	127.18	127.22	5077139.0
2008-08-26 12:30:00	SPY	ETF	127.23	127.49	127.17	127.22	5976879.0
2008-08-26 13:00:00	SPY	ETF	127.22	127.27	127.07	127.11	3947185.0
2008-08-26 13:30:00	SPY	ETF	127.1	127.17	126.84	127.07	7398505.0
2008-08-26 14:00:00	SPY	ETF	127.07	127.18	126.65	126.73	14828530.0
2008-08-26 14:30:00	SPY	ETF	126.73	126.87	126.58	126.71	12089577.0
2008-08-26 15:00:00	SPY	ETF	126.7	127.15	126.62	127.04	11917394.0
2008-08-26 15:30:00	SPY	ETF	127.04	127.47	127.04	127.44	14004784.0
2008-08-26 16:00:00	SPY	ETF	127.44	127.47	127.34	127.46	1164395.0
2008-08-26 16:30:00	SPY	ETF	127.45	127.52	127.43	127.48	173582.0
2008-08-26 17:00:00	SPY	ETF	127.48	127.48	127.42	127.42	18654.0
2008-08-26 17:30:00	SPY	ETF	127.5	127.5	127.48	127.48	500.0
2008-08-26 18:00:00	SPY	ETF	127.42	127.52	127.41	127.51	167980.0
2008-08-26 18:30:00	SPY	ETF	127.5	127.51	127.45	127.45	1900.0
2008-08-26 19:00:00	SPY	ETF	127.45	127.45	127.45	127.45	1000.0
2008-08-26 19:30:00	SPY	ETF	127.46	127.49	127.43	127.43	6700.0
2008-08-26 04:00:00	QQQ	ETF	46.52	46.52	46.52	46.52	200.0
2008-08-26 06:30:00	QQQ	ETF	46.68	46.68	46.68	46.68	300.0
2008-08-26 07:00:00	QQQ	ETF	46.7	46.7	46.66	46.68	8200.0
2008-08-26 07:30:00	QQQ	ETF	46.69	46.69	46.55	46.57	56823.0
2008-08-26 08:00:00	QQQ	ETF	46.58	46.58	46.44	46.51	322273.0
2008-08-26 08:30:00	QQQ	ETF	46.52	46.58	46.5	46.58	302816.0
2008-08-26 09:00:00	QQQ	ETF	46.59	46.6	46.49	46.51	760040.0
2008-08-26 09:30:00	QQQ	ETF	46.51	46.67	46.41	46.5501	17427653.0
2008-08-26 10:00:00	QQQ	ETF	46.56	46.67	46.46	46.58	11002442.0
2008-08-26 10:30:00	QQQ	ETF	46.58	46.77	46.58	46.71	9150669.0
2008-08-26 11:00:00	QQQ	ETF	46.7099	46.74	46.52	46.56	4592759.0
2008-08-26 11:30:00	QQQ	ETF	46.57	46.57	46.46	46.54	4406333.0
2008-08-26 12:00:00	QQQ	ETF	46.54	46.65	46.49	46.5	3508968.0
2008-08-26 12:30:00	QQQ	ETF	46.5	46.59	46.45	46.47	3746599.0
2008-08-26 13:00:00	QQQ	ETF	46.47	46.49	46.43	46.44	2409450.0
2008-08-26 13:30:00	QQQ	ETF	46.44	46.4401	46.21	46.29	6065765.0
2008-08-26 14:00:00	QQQ	ETF	46.28	46.4	46.17	46.188	8801314.0
2008-08-26 14:30:00	QQQ	ETF	46.18	46.24	46.12	46.15	6354845.0
2008-08-26 15:00:00	QQQ	ETF	46.15	46.36	46.15	46.3	7315252.0
2008-08-26 15:30:00	QQQ	ETF	46.3	46.45	46.3	46.43	11889270.0

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

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