PREVIEW / etf_30min / 2007-01-26

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-26.parquet
  size:    96 KB
  rows:    3,318

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-01-26 04:00:00	SPY	ETF	142.32	142.33	142.32	142.33	4100.0
2007-01-26 07:00:00	SPY	ETF	142.41	142.44	142.41	142.44	10800.0
2007-01-26 07:30:00	SPY	ETF	142.29	142.34	142.26	142.26	34700.0
2007-01-26 08:00:00	SPY	ETF	142.26	142.48	142.26	142.44	810700.0
2007-01-26 08:30:00	SPY	ETF	142.44	142.6	142.31	142.6	1398700.0
2007-01-26 09:00:00	SPY	ETF	142.63	142.63	142.5	142.56	465500.0
2007-01-26 09:30:00	SPY	ETF	142.57	142.65	142.1	142.21	10059400.0
2007-01-26 10:00:00	SPY	ETF	142.21	142.35	141.67	142.04	12633600.0
2007-01-26 10:30:00	SPY	ETF	142.04	142.2099	141.94	142.01	6026700.0
2007-01-26 11:00:00	SPY	ETF	142.01	142.03	141.78	141.93	5088300.0
2007-01-26 11:30:00	SPY	ETF	141.92	141.92	141.66	141.88	3237100.0
2007-01-26 12:00:00	SPY	ETF	141.88	142.17	141.88	142.08	4347800.0
2007-01-26 12:30:00	SPY	ETF	142.08	142.11	141.85	141.91	2281700.0
2007-01-26 13:00:00	SPY	ETF	141.92	141.96	141.58	141.69	3333000.0
2007-01-26 13:30:00	SPY	ETF	141.69	141.87	141.69	141.84	2053600.0
2007-01-26 14:00:00	SPY	ETF	141.84	142.12	141.66	142.0	6317500.0
2007-01-26 14:30:00	SPY	ETF	142.0	142.07	141.84	142.06	2562900.0
2007-01-26 15:00:00	SPY	ETF	142.05	142.42	142.02	142.27	6430600.0
2007-01-26 15:30:00	SPY	ETF	142.26	142.37	142.08	142.2	5330700.0
2007-01-26 16:00:00	SPY	ETF	142.21	142.32	142.05	142.18	480900.0
2007-01-26 16:30:00	SPY	ETF	142.18	142.22	142.18	142.22	219700.0
2007-01-26 17:00:00	SPY	ETF	142.18	142.18	142.18	142.18	500.0
2007-01-26 17:30:00	SPY	ETF	142.17	142.2	142.17	142.2	600.0
2007-01-26 18:00:00	SPY	ETF	142.2	142.2	142.2	142.2	900.0
2007-01-26 19:00:00	SPY	ETF	142.2	142.2	142.2	142.2	1200.0
2007-01-26 19:30:00	SPY	ETF	142.21	142.22	142.21	142.22	1500.0
2007-01-26 04:00:00	QQQ	ETF	43.67	43.67	43.67	43.67	200.0
2007-01-26 07:00:00	QQQ	ETF	43.71	43.72	43.71	43.71	15200.0
2007-01-26 07:30:00	QQQ	ETF	43.69	43.69	43.65	43.66	66300.0
2007-01-26 08:00:00	QQQ	ETF	43.67	43.79	43.65	43.73	926331.0
2007-01-26 08:30:00	QQQ	ETF	43.74	43.83	43.69	43.83	1360881.0
2007-01-26 09:00:00	QQQ	ETF	43.83	43.84	43.8	43.81	455803.0
2007-01-26 09:30:00	QQQ	ETF	43.81	43.83	43.41	43.53	24571200.0
2007-01-26 10:00:00	QQQ	ETF	43.54	43.6	43.29	43.53	23893900.0
2007-01-26 10:30:00	QQQ	ETF	43.53	43.73	43.5	43.62	15714000.0
2007-01-26 11:00:00	QQQ	ETF	43.62	43.66	43.51	43.59	8215500.0
2007-01-26 11:30:00	QQQ	ETF	43.59	43.61	43.44	43.58	16208100.0
2007-01-26 12:00:00	QQQ	ETF	43.57	43.74	43.55	43.66	10150700.0
2007-01-26 12:30:00	QQQ	ETF	43.66	43.69	43.56	43.58	6096400.0
2007-01-26 13:00:00	QQQ	ETF	43.58	43.62	43.45	43.49	7742900.0
2007-01-26 13:30:00	QQQ	ETF	43.49	43.62	43.49	43.61	4469700.0
2007-01-26 14:00:00	QQQ	ETF	43.6	43.7	43.49	43.61	5795100.0
2007-01-26 14:30:00	QQQ	ETF	43.62	43.64	43.57	43.64	4674100.0
2007-01-26 15:00:00	QQQ	ETF	43.63	43.75	43.62	43.67	5900400.0
2007-01-26 15:30:00	QQQ	ETF	43.67	43.71	43.57	43.57	6917500.0
2007-01-26 16:00:00	QQQ	ETF	43.57	43.57	43.46	43.51	1970332.0
2007-01-26 16:30:00	QQQ	ETF	43.51	43.53	43.49	43.53	54610.0
2007-01-26 17:00:00	QQQ	ETF	43.52	43.55	43.52	43.55	10100.0
2007-01-26 17:30:00	QQQ	ETF	43.55	43.55	43.53	43.53	6800.0
2007-01-26 18:00:00	QQQ	ETF	43.55	43.56	43.55	43.56	7100.0

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

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