PREVIEW / etf_30min / 2007-12-26

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-26.parquet
  size:    136 KB
  rows:    5,161

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-12-26 06:00:00	SPY	ETF	149.41	149.43	149.41	149.43	17500.0
2007-12-26 06:30:00	SPY	ETF	149.46	149.52	149.25	149.25	46700.0
2007-12-26 07:00:00	SPY	ETF	149.34	149.34	149.22	149.22	68500.0
2007-12-26 07:30:00	SPY	ETF	149.22	149.23	148.97	149.0	313400.0
2007-12-26 08:00:00	SPY	ETF	149.08	149.13	149.05	149.05	295700.0
2007-12-26 08:30:00	SPY	ETF	149.07	149.11	148.95	149.08	263300.0
2007-12-26 09:00:00	SPY	ETF	149.07	149.07	148.6	148.74	3197200.0
2007-12-26 09:30:00	SPY	ETF	148.8	148.92	148.5	148.65	7811308.0
2007-12-26 10:00:00	SPY	ETF	148.64	149.0	148.61	148.95	4721035.0
2007-12-26 10:30:00	SPY	ETF	148.95	148.98	148.75	148.88	2980780.0
2007-12-26 11:00:00	SPY	ETF	148.87	149.06	148.8	148.81	2949503.0
2007-12-26 11:30:00	SPY	ETF	148.82	148.9	148.76	148.7699	2499100.0
2007-12-26 12:00:00	SPY	ETF	148.77	148.9	148.75	148.88	1246900.0
2007-12-26 12:30:00	SPY	ETF	148.88	149.17	148.85	149.12	4565779.0
2007-12-26 13:00:00	SPY	ETF	149.11	149.36	149.08	149.19	4121875.0
2007-12-26 13:30:00	SPY	ETF	149.19	149.5	149.12	149.49	4195323.0
2007-12-26 14:00:00	SPY	ETF	149.49	149.52	149.25	149.42	3711894.0
2007-12-26 14:30:00	SPY	ETF	149.42	149.55	149.35	149.44	3440853.0
2007-12-26 15:00:00	SPY	ETF	149.44	149.45	149.21	149.26	3921403.0
2007-12-26 15:30:00	SPY	ETF	149.26	149.62	149.18	149.46	10892356.0
2007-12-26 16:00:00	SPY	ETF	149.4	149.67	149.4	149.59	1233900.0
2007-12-26 16:30:00	SPY	ETF	149.56	149.65	149.55	149.58	404500.0
2007-12-26 17:00:00	SPY	ETF	149.55	149.57	149.49	149.57	35900.0
2007-12-26 17:30:00	SPY	ETF	149.56	149.6	149.56	149.6	2200.0
2007-12-26 18:00:00	SPY	ETF	149.59	149.59	149.52	149.54	9900.0
2007-12-26 18:30:00	SPY	ETF	149.52	149.52	149.44	149.44	32600.0
2007-12-26 19:00:00	SPY	ETF	149.44	149.44	149.37	149.43	15100.0
2007-12-26 19:30:00	SPY	ETF	149.44	149.44	149.31	149.31	5200.0
2007-12-26 07:00:00	QQQ	ETF	52.26	52.26	52.22	52.22	9252.0
2007-12-26 07:30:00	QQQ	ETF	52.2	52.21	52.2	52.2	11100.0
2007-12-26 08:00:00	QQQ	ETF	52.22	52.26	52.17	52.19	137544.0
2007-12-26 08:30:00	QQQ	ETF	52.19	52.22	52.17	52.21	152694.0
2007-12-26 09:00:00	QQQ	ETF	52.21	52.21	52.08	52.15	834479.0
2007-12-26 09:30:00	QQQ	ETF	52.14	52.17	52.0	52.0794	8054939.0
2007-12-26 10:00:00	QQQ	ETF	52.08	52.24	52.06	52.22	3680406.0
2007-12-26 10:30:00	QQQ	ETF	52.22	52.25	52.1	52.18	2958047.0
2007-12-26 11:00:00	QQQ	ETF	52.19	52.28	52.17	52.17	2452740.0
2007-12-26 11:30:00	QQQ	ETF	52.17	52.26	52.16	52.16	3265000.0
2007-12-26 12:00:00	QQQ	ETF	52.16	52.28	52.16	52.26	3676806.0
2007-12-26 12:30:00	QQQ	ETF	52.26	52.4	52.25	52.38	2591702.0
2007-12-26 13:00:00	QQQ	ETF	52.38	52.45	52.34	52.41	2414375.0
2007-12-26 13:30:00	QQQ	ETF	52.41	52.56	52.4	52.56	2393616.0
2007-12-26 14:00:00	QQQ	ETF	52.56	52.59	52.5	52.58	1794040.0
2007-12-26 14:30:00	QQQ	ETF	52.5801	52.63	52.54	52.59	7616462.0
2007-12-26 15:00:00	QQQ	ETF	52.59	52.6	52.45	52.48	3840032.0
2007-12-26 15:30:00	QQQ	ETF	52.47	52.54	52.41	52.5	5369737.0
2007-12-26 16:00:00	QQQ	ETF	52.52	52.57	52.45	52.51	1187118.0
2007-12-26 16:30:00	QQQ	ETF	52.5	52.53	52.3218	52.51	6026367.0
2007-12-26 17:00:00	QQQ	ETF	52.5	52.5	52.5	52.5	1600.0
2007-12-26 17:30:00	QQQ	ETF	52.51	52.51	52.51	52.51	1700.0

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

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