PREVIEW / etf_30min / 2005-08-23

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-08-23.parquet
  size:    46 KB
  rows:    1,619

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-23 05:00:00	SPY	ETF	122.34	122.34	122.34	122.34	500.0
2005-08-23 07:00:00	SPY	ETF	122.37	122.41	122.36	122.41	2600.0
2005-08-23 07:30:00	SPY	ETF	122.41	122.41	122.34	122.34	98400.0
2005-08-23 08:00:00	SPY	ETF	122.39	122.5	122.34	122.43	188700.0
2005-08-23 08:30:00	SPY	ETF	122.46	122.5	122.37	122.45	267400.0
2005-08-23 09:00:00	SPY	ETF	122.43	122.52	122.43	122.51	264500.0
2005-08-23 09:30:00	SPY	ETF	122.5	122.61	122.15	122.23	6940500.0
2005-08-23 10:00:00	SPY	ETF	122.22	122.44	122.11	122.34	5534400.0
2005-08-23 10:30:00	SPY	ETF	122.33	122.45	122.15	122.23	1761300.0
2005-08-23 11:00:00	SPY	ETF	122.23	122.25	121.98	122.14	3306000.0
2005-08-23 11:30:00	SPY	ETF	122.12	122.16	121.81	121.89	6459100.0
2005-08-23 12:00:00	SPY	ETF	121.9	122.12	121.67	121.8	3953000.0
2005-08-23 12:30:00	SPY	ETF	121.8	121.97	121.76	121.92	3186600.0
2005-08-23 13:00:00	SPY	ETF	121.92	122.04	121.83	121.93	2736300.0
2005-08-23 13:30:00	SPY	ETF	121.93	122.15	121.9	122.04	2586800.0
2005-08-23 14:00:00	SPY	ETF	122.04	122.31	122.0	122.24	4383300.0
2005-08-23 14:30:00	SPY	ETF	122.24	122.47	122.17	122.35	3081600.0
2005-08-23 15:00:00	SPY	ETF	122.35	122.36	122.07	122.19	3301800.0
2005-08-23 15:30:00	SPY	ETF	122.19	122.26	122.05	122.05	2825200.0
2005-08-23 16:00:00	SPY	ETF	122.04	122.27	122.02	122.24	205300.0
2005-08-23 16:30:00	SPY	ETF	122.24	122.24	122.21	122.21	3100.0
2005-08-23 17:00:00	SPY	ETF	122.22	122.23	122.18	122.18	66600.0
2005-08-23 17:30:00	SPY	ETF	122.23	122.23	122.18	122.18	1500900.0
2005-08-23 18:00:00	SPY	ETF	122.18	122.18	122.16	122.18	3300.0
2005-08-23 18:30:00	SPY	ETF	122.15	122.15	122.15	122.15	400.0
2005-08-23 19:00:00	SPY	ETF	122.22	122.25	122.22	122.25	19700.0
2005-08-23 09:30:00	QQQ	ETF	38.85	38.92	38.76	38.79	7072300.0
2005-08-23 10:00:00	QQQ	ETF	38.79	38.88	38.75	38.85	4634100.0
2005-08-23 10:30:00	QQQ	ETF	38.85	38.87	38.77	38.79	4265000.0
2005-08-23 11:00:00	QQQ	ETF	38.8	38.8	38.72	38.75	5216200.0
2005-08-23 11:30:00	QQQ	ETF	38.75	38.76	38.63	38.66	6712800.0
2005-08-23 12:00:00	QQQ	ETF	38.66	38.72	38.61	38.67	3383900.0
2005-08-23 12:30:00	QQQ	ETF	38.67	38.72	38.66	38.69	1887900.0
2005-08-23 13:00:00	QQQ	ETF	38.69	38.75	38.66	38.68	2853000.0
2005-08-23 13:30:00	QQQ	ETF	38.68	38.78	38.68	38.74	2107300.0
2005-08-23 14:00:00	QQQ	ETF	38.73	38.83	38.7	38.81	3459300.0
2005-08-23 14:30:00	QQQ	ETF	38.81	38.91	38.79	38.86	5750200.0
2005-08-23 15:00:00	QQQ	ETF	38.86	38.87	38.76	38.8	3312500.0
2005-08-23 15:30:00	QQQ	ETF	38.8	38.82	38.74	38.74	4217600.0
2005-08-23 07:30:00	IWM	ETF	65.43	65.43	65.4	65.4	21000.0
2005-08-23 08:00:00	IWM	ETF	65.44	65.45	65.4	65.45	437000.0
2005-08-23 08:30:00	IWM	ETF	65.45	65.45	65.41	65.41	58000.0
2005-08-23 09:00:00	IWM	ETF	65.42	65.51	65.41	65.51	122000.0
2005-08-23 09:30:00	IWM	ETF	65.51	65.63	65.35	65.36	3088900.0
2005-08-23 10:00:00	IWM	ETF	65.36	65.53	65.29	65.46	1417100.0
2005-08-23 10:30:00	IWM	ETF	65.47	65.5	65.22	65.27	1193700.0
2005-08-23 11:00:00	IWM	ETF	65.26	65.3	65.15	65.192	1161600.0
2005-08-23 11:30:00	IWM	ETF	65.19	65.2	64.95	64.99	1308300.0
2005-08-23 12:00:00	IWM	ETF	65.0	65.0	64.86	64.92	1819700.0
2005-08-23 12:30:00	IWM	ETF	64.92	65.04	64.89	65.0	625700.0

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

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