PREVIEW / etf_30min / 2005-08-09

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-08-09.parquet
  size:    44 KB
  rows:    1,611

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-08-09 05:00:00	SPY	ETF	122.83	122.83	122.83	122.83	5100.0
2005-08-09 07:30:00	SPY	ETF	122.87	122.87	122.85	122.85	6000.0
2005-08-09 08:00:00	SPY	ETF	122.84	122.91	122.83	122.89	73200.0
2005-08-09 08:30:00	SPY	ETF	122.92	123.08	122.92	123.06	559200.0
2005-08-09 09:00:00	SPY	ETF	123.06	123.1	123.03	123.05	128500.0
2005-08-09 09:30:00	SPY	ETF	123.06	123.18	123.01	123.1505	6362500.0
2005-08-09 10:00:00	SPY	ETF	123.15	123.23	123.02	123.16	4351900.0
2005-08-09 10:30:00	SPY	ETF	123.15	123.27	123.1	123.21	2367200.0
2005-08-09 11:00:00	SPY	ETF	123.22	123.32	123.15	123.27	1411600.0
2005-08-09 11:30:00	SPY	ETF	123.27	123.33	123.22	123.27	1521900.0
2005-08-09 12:00:00	SPY	ETF	123.27	123.32	123.24	123.28	565200.0
2005-08-09 12:30:00	SPY	ETF	123.28	123.32	123.19	123.22	1121100.0
2005-08-09 13:00:00	SPY	ETF	123.22	123.26	123.09	123.16	831600.0
2005-08-09 13:30:00	SPY	ETF	123.16	123.27	123.12	123.26	2501500.0
2005-08-09 14:00:00	SPY	ETF	123.24	123.47	123.15	123.47	6058400.0
2005-08-09 14:30:00	SPY	ETF	123.47	123.59	123.24	123.25	7475700.0
2005-08-09 15:00:00	SPY	ETF	123.27	123.35	122.94	122.98	5578100.0
2005-08-09 15:30:00	SPY	ETF	122.99	123.35	122.87	123.34	4473000.0
2005-08-09 16:00:00	SPY	ETF	123.37	123.42	123.35	123.38	397600.0
2005-08-09 16:30:00	SPY	ETF	123.37	123.4	123.35	123.37	33000.0
2005-08-09 17:00:00	SPY	ETF	123.37	123.39	123.24	123.3	62100.0
2005-08-09 17:30:00	SPY	ETF	123.26	123.26	123.17	123.25	20100.0
2005-08-09 18:00:00	SPY	ETF	123.27	123.48	123.27	123.42	230300.0
2005-08-09 18:30:00	SPY	ETF	123.45	123.45	123.36	123.36	3200.0
2005-08-09 19:00:00	SPY	ETF	123.36	123.36	123.36	123.36	600.0
2005-08-09 19:30:00	SPY	ETF	123.36	123.36	123.34	123.34	600.0
2005-08-09 09:30:00	QQQ	ETF	39.37	39.42	39.34	39.42	6845100.0
2005-08-09 10:00:00	QQQ	ETF	39.42	39.45	39.38	39.44	5402700.0
2005-08-09 10:30:00	QQQ	ETF	39.43	39.5	39.43	39.46	4667700.0
2005-08-09 11:00:00	QQQ	ETF	39.47	39.51	39.42	39.48	3617800.0
2005-08-09 11:30:00	QQQ	ETF	39.48	39.49	39.43	39.46	2492600.0
2005-08-09 12:00:00	QQQ	ETF	39.46	39.47	39.44	39.45	1321000.0
2005-08-09 12:30:00	QQQ	ETF	39.45	39.49	39.44	39.46	1683000.0
2005-08-09 13:00:00	QQQ	ETF	39.46	39.47	39.4	39.44	2217300.0
2005-08-09 13:30:00	QQQ	ETF	39.43	39.48	39.43	39.47	1262500.0
2005-08-09 14:00:00	QQQ	ETF	39.46	39.56	39.44	39.56	6069700.0
2005-08-09 14:30:00	QQQ	ETF	39.57	39.59	39.48	39.48	7088900.0
2005-08-09 15:00:00	QQQ	ETF	39.49	39.51	39.34	39.35	6955600.0
2005-08-09 15:30:00	QQQ	ETF	39.35	39.46	39.31	39.44	7404700.0
2005-08-09 08:00:00	IWM	ETF	65.9	65.9	65.9	65.9	100.0
2005-08-09 08:30:00	IWM	ETF	65.98	66.01	65.97	66.0	18400.0
2005-08-09 09:00:00	IWM	ETF	65.97	66.0	65.95	65.95	43400.0
2005-08-09 09:30:00	IWM	ETF	65.89	65.99	65.78	65.89	2152900.0
2005-08-09 10:00:00	IWM	ETF	65.89	65.99	65.8	65.86	1835900.0
2005-08-09 10:30:00	IWM	ETF	65.86	66.07	65.86	66.02	1996500.0
2005-08-09 11:00:00	IWM	ETF	66.02	66.06	65.93	66.0	918500.0
2005-08-09 11:30:00	IWM	ETF	66.01	66.04	65.87	65.88	1190700.0
2005-08-09 12:00:00	IWM	ETF	65.88	65.9	65.83	65.85	545300.0
2005-08-09 12:30:00	IWM	ETF	65.84	65.88	65.79	65.8	879100.0
2005-08-09 13:00:00	IWM	ETF	65.8	65.82	65.66	65.71	952500.0

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

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