PREVIEW / etf_30min / 2005-07-26

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-26.parquet
  size:    43 KB
  rows:    1,587

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-26 07:00:00	SPY	ETF	123.35	123.35	123.26	123.28	3700.0
2005-07-26 07:30:00	SPY	ETF	123.3	123.32	123.25	123.28	9200.0
2005-07-26 08:00:00	SPY	ETF	123.25	123.31	123.25	123.31	106500.0
2005-07-26 08:30:00	SPY	ETF	123.25	123.28	123.23	123.23	17600.0
2005-07-26 09:00:00	SPY	ETF	123.22	123.27	123.22	123.25	37200.0
2005-07-26 09:30:00	SPY	ETF	123.23	123.33	123.03	123.26	3803500.0
2005-07-26 10:00:00	SPY	ETF	123.27	123.5	123.02	123.32	7494500.0
2005-07-26 10:30:00	SPY	ETF	123.33	123.41	123.07	123.21	4526800.0
2005-07-26 11:00:00	SPY	ETF	123.24	123.3	123.05	123.18	3990100.0
2005-07-26 11:30:00	SPY	ETF	123.17	123.26	123.07	123.24	1239200.0
2005-07-26 12:00:00	SPY	ETF	123.24	123.28	122.95	122.99	1568800.0
2005-07-26 12:30:00	SPY	ETF	122.99	123.19	122.95	123.13	2365700.0
2005-07-26 13:00:00	SPY	ETF	123.13	123.23	123.12	123.12	1190400.0
2005-07-26 13:30:00	SPY	ETF	123.12	123.45	123.08	123.45	4056600.0
2005-07-26 14:00:00	SPY	ETF	123.45	123.5	123.28	123.33	2576100.0
2005-07-26 14:30:00	SPY	ETF	123.33	123.53	123.24	123.41	2910400.0
2005-07-26 15:00:00	SPY	ETF	123.4	123.44	123.28	123.392	1703500.0
2005-07-26 15:30:00	SPY	ETF	123.4	123.42	123.21	123.25	3315100.0
2005-07-26 16:00:00	SPY	ETF	123.22	123.34	123.18	123.29	441800.0
2005-07-26 16:30:00	SPY	ETF	123.28	123.31	123.22	123.3	49600.0
2005-07-26 17:00:00	SPY	ETF	123.29	123.29	123.2	123.2	40100.0
2005-07-26 17:30:00	SPY	ETF	123.2	123.22	123.2	123.2	700.0
2005-07-26 18:00:00	SPY	ETF	123.19	123.21	123.18	123.21	24100.0
2005-07-26 18:30:00	SPY	ETF	123.22	123.22	123.22	123.22	700.0
2005-07-26 19:00:00	SPY	ETF	123.2	123.23	123.2	123.23	2100.0
2005-07-26 19:30:00	SPY	ETF	123.23	123.24	123.2	123.21	2600.0
2005-07-26 09:30:00	QQQ	ETF	39.37	39.41	39.31	39.39	10064700.0
2005-07-26 10:00:00	QQQ	ETF	39.39	39.46	39.25	39.4	9967400.0
2005-07-26 10:30:00	QQQ	ETF	39.39	39.42	39.19	39.29	7619200.0
2005-07-26 11:00:00	QQQ	ETF	39.29	39.37	39.25	39.28	3122300.0
2005-07-26 11:30:00	QQQ	ETF	39.29	39.39	39.25	39.37	2749100.0
2005-07-26 12:00:00	QQQ	ETF	39.37	39.39	39.25	39.27	3260000.0
2005-07-26 12:30:00	QQQ	ETF	39.27	39.37	39.26	39.32	1859300.0
2005-07-26 13:00:00	QQQ	ETF	39.32	39.38	39.32	39.33	1718400.0
2005-07-26 13:30:00	QQQ	ETF	39.33	39.48	39.3	39.48	4531400.0
2005-07-26 14:00:00	QQQ	ETF	39.48	39.51	39.43	39.46	4084200.0
2005-07-26 14:30:00	QQQ	ETF	39.46	39.53	39.43	39.48	3013400.0
2005-07-26 15:00:00	QQQ	ETF	39.48	39.5	39.43	39.48	2284600.0
2005-07-26 15:30:00	QQQ	ETF	39.48	39.49	39.4	39.4	6183200.0
2005-07-26 08:00:00	IWM	ETF	66.99	66.99	66.99	66.99	3000.0
2005-07-26 09:00:00	IWM	ETF	66.95	66.99	66.92	66.92	101500.0
2005-07-26 09:30:00	IWM	ETF	66.91	67.07	66.76	66.96	3870600.0
2005-07-26 10:00:00	IWM	ETF	66.96	67.15	66.69	67.0	2569100.0
2005-07-26 10:30:00	IWM	ETF	66.99	67.09	66.79	66.9	1135700.0
2005-07-26 11:00:00	IWM	ETF	66.91	67.03	66.87	66.95	1983400.0
2005-07-26 11:30:00	IWM	ETF	66.95	66.99	66.8	66.97	646000.0
2005-07-26 12:00:00	IWM	ETF	66.97	67.0	66.59	66.62	823500.0
2005-07-26 12:30:00	IWM	ETF	66.63	66.83	66.59	66.79	312000.0
2005-07-26 13:00:00	IWM	ETF	66.8	66.96	66.78	66.86	594300.0
2005-07-26 13:30:00	IWM	ETF	66.85	67.32	66.83	67.3	2926700.0

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

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