PREVIEW / etf_30min / 2005-07-20

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-20.parquet
  size:    48 KB
  rows:    1,665

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-07-20 05:30:00	SPY	ETF	122.87	122.89	122.87	122.89	2000.0
2005-07-20 06:00:00	SPY	ETF	122.8	122.8	122.8	122.8	400.0
2005-07-20 07:00:00	SPY	ETF	122.82	122.82	122.75	122.75	56000.0
2005-07-20 07:30:00	SPY	ETF	122.74	122.75	122.71	122.71	1800.0
2005-07-20 08:00:00	SPY	ETF	122.67	122.67	122.58	122.65	59400.0
2005-07-20 08:30:00	SPY	ETF	122.63	122.67	122.63	122.65	40000.0
2005-07-20 09:00:00	SPY	ETF	122.64	122.656	122.57	122.58	137800.0
2005-07-20 09:30:00	SPY	ETF	122.59	122.88	122.51	122.71	7434200.0
2005-07-20 10:00:00	SPY	ETF	122.71	122.74	122.3	122.37	10796200.0
2005-07-20 10:30:00	SPY	ETF	122.35	122.55	122.34	122.5	4145400.0
2005-07-20 11:00:00	SPY	ETF	122.49	122.8	122.42	122.74	4444000.0
2005-07-20 11:30:00	SPY	ETF	122.75	122.96	122.74	122.85	4658300.0
2005-07-20 12:00:00	SPY	ETF	122.85	122.88	122.69	122.7	1116700.0
2005-07-20 12:30:00	SPY	ETF	122.7	122.85	122.68	122.82	1305800.0
2005-07-20 13:00:00	SPY	ETF	122.83	123.28	122.75	123.24	4481300.0
2005-07-20 13:30:00	SPY	ETF	123.26	123.55	123.26	123.39	6898000.0
2005-07-20 14:00:00	SPY	ETF	123.39	123.5	123.33	123.43	2375500.0
2005-07-20 14:30:00	SPY	ETF	123.45	123.57	123.1	123.21	4872600.0
2005-07-20 15:00:00	SPY	ETF	123.21	123.42	123.16	123.37	4200300.0
2005-07-20 15:30:00	SPY	ETF	123.38	123.73	123.37	123.54	7667700.0
2005-07-20 16:00:00	SPY	ETF	123.49	123.61	122.99	123.55	1157300.0
2005-07-20 16:30:00	SPY	ETF	123.56	123.58	123.45	123.46	115300.0
2005-07-20 17:00:00	SPY	ETF	123.47	123.47	123.37	123.38	85600.0
2005-07-20 17:30:00	SPY	ETF	123.43	123.45	123.43	123.45	1500.0
2005-07-20 18:00:00	SPY	ETF	123.41	123.44	123.4	123.4	900.0
2005-07-20 18:30:00	SPY	ETF	123.41	123.41	123.4	123.41	3000.0
2005-07-20 19:00:00	SPY	ETF	123.41	123.41	123.41	123.41	700.0
2005-07-20 19:30:00	SPY	ETF	123.44	123.44	123.41	123.41	3100.0
2005-07-20 09:30:00	QQQ	ETF	38.93	39.06	38.9	39.03	13947100.0
2005-07-20 10:00:00	QQQ	ETF	39.03	39.04	38.9	38.96	8187400.0
2005-07-20 10:30:00	QQQ	ETF	38.96	39.07	38.95	39.03	6410300.0
2005-07-20 11:00:00	QQQ	ETF	39.03	39.15	39.02	39.12	5494300.0
2005-07-20 11:30:00	QQQ	ETF	39.12	39.19	39.12	39.15	5379900.0
2005-07-20 12:00:00	QQQ	ETF	39.15	39.16	39.08	39.09	2562900.0
2005-07-20 12:30:00	QQQ	ETF	39.09	39.15	39.08	39.13	1481300.0
2005-07-20 13:00:00	QQQ	ETF	39.13	39.29	39.1	39.26	6031600.0
2005-07-20 13:30:00	QQQ	ETF	39.27	39.4	39.26	39.3	8252100.0
2005-07-20 14:00:00	QQQ	ETF	39.3	39.37	39.28	39.36	3391800.0
2005-07-20 14:30:00	QQQ	ETF	39.37	39.4	39.27	39.32	5735900.0
2005-07-20 15:00:00	QQQ	ETF	39.32	39.4	39.29	39.39	4810200.0
2005-07-20 15:30:00	QQQ	ETF	39.39	39.57	39.39	39.47	12677300.0
2005-07-20 07:00:00	IWM	ETF	66.35	66.35	66.35	66.35	200.0
2005-07-20 07:30:00	IWM	ETF	66.32	66.32	66.32	66.32	1000.0
2005-07-20 08:00:00	IWM	ETF	66.24	66.24	66.2	66.23	16800.0
2005-07-20 08:30:00	IWM	ETF	66.23	66.32	66.23	66.32	13000.0
2005-07-20 09:00:00	IWM	ETF	66.27	66.29	66.18	66.25	35700.0
2005-07-20 09:30:00	IWM	ETF	66.25	66.6	66.22	66.55	1564900.0
2005-07-20 10:00:00	IWM	ETF	66.54	66.54	66.19	66.22	2594200.0
2005-07-20 10:30:00	IWM	ETF	66.21	66.5	66.21	66.5	1725500.0
2005-07-20 11:00:00	IWM	ETF	66.5	66.76	66.45	66.72	1408300.0

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

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