PREVIEW / etf_30min / 2005-07-27

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-27.parquet
  size:    45 KB
  rows:    1,593

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-27 07:00:00	SPY	ETF	123.33	123.4	123.33	123.4	5400.0
2005-07-27 07:30:00	SPY	ETF	123.35	123.35	123.35	123.35	800.0
2005-07-27 08:00:00	SPY	ETF	123.44	123.44	123.37	123.37	86400.0
2005-07-27 08:30:00	SPY	ETF	123.49	123.53	123.47	123.49	203700.0
2005-07-27 09:00:00	SPY	ETF	123.53	123.53	123.46	123.46	136700.0
2005-07-27 09:30:00	SPY	ETF	123.5	123.52	123.29	123.37	3851500.0
2005-07-27 10:00:00	SPY	ETF	123.36	123.44	123.05	123.16	4823700.0
2005-07-27 10:30:00	SPY	ETF	123.16	123.38	123.1	123.14	5305500.0
2005-07-27 11:00:00	SPY	ETF	123.14	123.35	123.09	123.13	2045700.0
2005-07-27 11:30:00	SPY	ETF	123.11	123.24	123.1	123.19	1438200.0
2005-07-27 12:00:00	SPY	ETF	123.19	123.41	123.19	123.3	2744900.0
2005-07-27 12:30:00	SPY	ETF	123.3	123.41	123.19	123.31	1256900.0
2005-07-27 13:00:00	SPY	ETF	123.32	123.38	123.22	123.3	1238000.0
2005-07-27 13:30:00	SPY	ETF	123.3	123.41	123.26	123.38	1914700.0
2005-07-27 14:00:00	SPY	ETF	123.39	123.68	123.34	123.6	4191900.0
2005-07-27 14:30:00	SPY	ETF	123.6	123.8	123.57	123.72	3102300.0
2005-07-27 15:00:00	SPY	ETF	123.71	123.85	123.66	123.81	2950900.0
2005-07-27 15:30:00	SPY	ETF	123.81	123.85	123.69	123.79	4624000.0
2005-07-27 16:00:00	SPY	ETF	123.81	123.88	123.73	123.73	1350200.0
2005-07-27 16:30:00	SPY	ETF	123.78	123.8	123.74	123.77	497900.0
2005-07-27 17:00:00	SPY	ETF	123.74	123.81	123.69	123.69	1508300.0
2005-07-27 17:30:00	SPY	ETF	123.69	123.72	123.69	123.72	6700.0
2005-07-27 18:00:00	SPY	ETF	123.72	123.79	123.72	123.79	38400.0
2005-07-27 18:30:00	SPY	ETF	123.79	123.8	123.79	123.8	4900.0
2005-07-27 19:00:00	SPY	ETF	123.82	123.82	123.82	123.82	800.0
2005-07-27 09:30:00	QQQ	ETF	39.43	39.46	39.33	39.36	7782200.0
2005-07-27 10:00:00	QQQ	ETF	39.36	39.39	39.23	39.3	7425300.0
2005-07-27 10:30:00	QQQ	ETF	39.29	39.52	39.28	39.42	10057100.0
2005-07-27 11:00:00	QQQ	ETF	39.42	39.45	39.34	39.36	2253700.0
2005-07-27 11:30:00	QQQ	ETF	39.36	39.4	39.34	39.4	1607400.0
2005-07-27 12:00:00	QQQ	ETF	39.4	39.52	39.4	39.43	4486800.0
2005-07-27 12:30:00	QQQ	ETF	39.43	39.48	39.4	39.44	1375000.0
2005-07-27 13:00:00	QQQ	ETF	39.44	39.47	39.38	39.45	2848500.0
2005-07-27 13:30:00	QQQ	ETF	39.45	39.53	39.44	39.49	4220300.0
2005-07-27 14:00:00	QQQ	ETF	39.5	39.69	39.48	39.67	11144000.0
2005-07-27 14:30:00	QQQ	ETF	39.67	39.72	39.64	39.7	5267700.0
2005-07-27 15:00:00	QQQ	ETF	39.7	39.75	39.66	39.74	4728600.0
2005-07-27 15:30:00	QQQ	ETF	39.73	39.76	39.69	39.72	6353800.0
2005-07-27 08:00:00	IWM	ETF	67.25	67.25	67.15	67.22	5900.0
2005-07-27 08:30:00	IWM	ETF	67.25	67.26	67.25	67.25	5100.0
2005-07-27 09:00:00	IWM	ETF	67.29	67.29	67.2	67.23	3400.0
2005-07-27 09:30:00	IWM	ETF	67.25	67.28	66.81	66.87	2414500.0
2005-07-27 10:00:00	IWM	ETF	66.85	66.92	66.5	66.58	2442100.0
2005-07-27 10:30:00	IWM	ETF	66.59	67.25	66.45	66.47	2800000.0
2005-07-27 11:00:00	IWM	ETF	66.47	66.7	66.47	66.52	1143500.0
2005-07-27 11:30:00	IWM	ETF	66.52	66.65	66.51	66.59	600700.0
2005-07-27 12:00:00	IWM	ETF	66.59	66.96	66.59	66.84	2670600.0
2005-07-27 12:30:00	IWM	ETF	66.84	66.93	66.78	66.81	821900.0
2005-07-27 13:00:00	IWM	ETF	66.8	66.83	66.63	66.72	948800.0
2005-07-27 13:30:00	IWM	ETF	66.72	66.86	66.7	66.85	918500.0

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

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