PREVIEW / etf_30min / 2005-01-18

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-01-18.parquet
  size:    42 KB
  rows:    1,413

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
2005-01-18 08:00:00	SPY	ETF	118.11	118.15	118.06	118.08	44300.0
2005-01-18 08:30:00	SPY	ETF	118.08	118.12	118.08	118.12	16100.0
2005-01-18 09:00:00	SPY	ETF	118.12	118.13	118.0	118.04	339000.0
2005-01-18 09:30:00	SPY	ETF	118.05	118.16	117.95	118.1	6382900.0
2005-01-18 10:00:00	SPY	ETF	118.1	118.41	118.03	118.4	4140200.0
2005-01-18 10:30:00	SPY	ETF	118.4	119.05	118.38	118.93	8694600.0
2005-01-18 11:00:00	SPY	ETF	118.93	119.02	118.83	118.96	3720100.0
2005-01-18 11:30:00	SPY	ETF	118.96	119.3	118.96	119.15	4564100.0
2005-01-18 12:00:00	SPY	ETF	119.16	119.35	119.14	119.28	1801400.0
2005-01-18 12:30:00	SPY	ETF	119.27	119.3	119.15	119.22	2034300.0
2005-01-18 13:00:00	SPY	ETF	119.23	119.26	119.15	119.24	1767900.0
2005-01-18 13:30:00	SPY	ETF	119.23	119.43	119.22	119.33	1967200.0
2005-01-18 14:00:00	SPY	ETF	119.33	119.48	119.27	119.45	1933700.0
2005-01-18 14:30:00	SPY	ETF	119.48	119.52	119.2	119.3	2581100.0
2005-01-18 15:00:00	SPY	ETF	119.3	119.49	119.21	119.38	2406700.0
2005-01-18 15:30:00	SPY	ETF	119.39	119.6	119.35	119.57	7140400.0
2005-01-18 16:00:00	SPY	ETF	119.54	119.63	119.44	119.45	3658900.0
2005-01-18 16:30:00	SPY	ETF	119.47	119.57	119.43	119.5	499800.0
2005-01-18 17:00:00	SPY	ETF	119.5	119.53	119.49	119.5	9400.0
2005-01-18 17:30:00	SPY	ETF	119.48	119.51	119.45	119.51	32600.0
2005-01-18 18:00:00	SPY	ETF	119.49	119.5	119.49	119.5	4100.0
2005-01-18 18:30:00	SPY	ETF	119.49	119.5	119.49	119.5	2900.0
2005-01-18 19:00:00	SPY	ETF	119.52	119.6	119.48	119.48	14200.0
2005-01-18 19:30:00	SPY	ETF	119.51	119.51	119.51	119.51	500.0
2005-01-18 09:30:00	QQQ	ETF	38.29	38.34	38.22	38.27	11390800.0
2005-01-18 10:00:00	QQQ	ETF	38.27	38.41	38.23	38.41	7262500.0
2005-01-18 10:30:00	QQQ	ETF	38.41	38.64	38.41	38.57	13788700.0
2005-01-18 11:00:00	QQQ	ETF	38.57	38.61	38.53	38.56	3545100.0
2005-01-18 11:30:00	QQQ	ETF	38.56	38.7	38.56	38.65	8287600.0
2005-01-18 12:00:00	QQQ	ETF	38.64	38.75	38.63	38.73	4869100.0
2005-01-18 12:30:00	QQQ	ETF	38.73	38.75	38.68	38.69	3097500.0
2005-01-18 13:00:00	QQQ	ETF	38.69	38.7	38.63	38.68	2277100.0
2005-01-18 13:30:00	QQQ	ETF	38.68	38.76	38.66	38.72	2974100.0
2005-01-18 14:00:00	QQQ	ETF	38.72	38.77	38.68	38.76	3090600.0
2005-01-18 14:30:00	QQQ	ETF	38.77	38.79	38.62	38.67	6067700.0
2005-01-18 15:00:00	QQQ	ETF	38.67	38.75	38.62	38.65	6761500.0
2005-01-18 15:30:00	QQQ	ETF	38.66	38.78	38.63	38.74	9489200.0
2005-01-18 09:00:00	IWM	ETF	61.295	61.295	61.295	61.295	1000.0
2005-01-18 09:30:00	IWM	ETF	61.3	61.55	61.21	61.52	2734200.0
2005-01-18 10:00:00	IWM	ETF	61.52	61.67	61.385	61.67	1442800.0
2005-01-18 10:30:00	IWM	ETF	61.675	62.0	61.675	61.885	2629200.0
2005-01-18 11:00:00	IWM	ETF	61.885	61.945	61.755	61.88	732600.0
2005-01-18 11:30:00	IWM	ETF	61.885	62.085	61.875	62.015	1381000.0
2005-01-18 12:00:00	IWM	ETF	62.02	62.19	62.01	62.125	1092600.0
2005-01-18 12:30:00	IWM	ETF	62.12	62.145	62.06	62.065	189200.0
2005-01-18 13:00:00	IWM	ETF	62.065	62.095	61.925	61.985	795000.0
2005-01-18 13:30:00	IWM	ETF	61.99	62.235	61.99	62.1	534400.0
2005-01-18 14:00:00	IWM	ETF	62.105	62.225	62.09	62.21	490600.0
2005-01-18 14:30:00	IWM	ETF	62.205	62.255	61.955	62.085	1247000.0
2005-01-18 15:00:00	IWM	ETF	62.085	62.255	62.035	62.155	1027200.0

> showing 50 of 1,413 rows — these rows as CSV

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