PREVIEW / etf_30min / 2005-07-14

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-14.parquet
  size:    46 KB
  rows:    1,623

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-14 07:00:00	SPY	ETF	122.81	122.94	122.81	122.9	27900.0
2005-07-14 07:30:00	SPY	ETF	122.9	122.91	122.86	122.87	95600.0
2005-07-14 08:00:00	SPY	ETF	122.86	122.91	122.45	122.8	564900.0
2005-07-14 08:30:00	SPY	ETF	122.87	123.17	122.83	123.13	1298700.0
2005-07-14 09:00:00	SPY	ETF	123.12	123.12	122.97	122.98	204700.0
2005-07-14 09:30:00	SPY	ETF	122.98	123.44	122.95	122.98	9915900.0
2005-07-14 10:00:00	SPY	ETF	123.0	123.16	122.78	123.11	9461300.0
2005-07-14 10:30:00	SPY	ETF	123.11	123.25	122.87	122.92	4810200.0
2005-07-14 11:00:00	SPY	ETF	122.92	123.04	122.73	122.8	3002800.0
2005-07-14 11:30:00	SPY	ETF	122.8	122.85	122.55	122.66	6000400.0
2005-07-14 12:00:00	SPY	ETF	122.66	122.91	122.66	122.74	4074300.0
2005-07-14 12:30:00	SPY	ETF	122.74	122.81	122.66	122.76	944500.0
2005-07-14 13:00:00	SPY	ETF	122.77	123.01	122.77	122.84	3471600.0
2005-07-14 13:30:00	SPY	ETF	122.84	122.85	122.5	122.58	2559300.0
2005-07-14 14:00:00	SPY	ETF	122.58	122.71	122.52	122.57	2437600.0
2005-07-14 14:30:00	SPY	ETF	122.57	122.68	122.49	122.61	2351100.0
2005-07-14 15:00:00	SPY	ETF	122.611	122.89	122.6	122.83	5194600.0
2005-07-14 15:30:00	SPY	ETF	122.82	123.12	122.68	122.74	3780600.0
2005-07-14 16:00:00	SPY	ETF	122.74	122.99	122.69	122.81	2070200.0
2005-07-14 16:30:00	SPY	ETF	122.81	123.06	122.72	122.75	262400.0
2005-07-14 17:00:00	SPY	ETF	122.74	122.77	122.74	122.77	65100.0
2005-07-14 17:30:00	SPY	ETF	122.8	122.83	122.7	122.71	22900.0
2005-07-14 18:00:00	SPY	ETF	122.72	122.75	122.72	122.75	1800.0
2005-07-14 18:30:00	SPY	ETF	122.72	122.72	122.72	122.72	200.0
2005-07-14 19:30:00	SPY	ETF	122.78	122.78	122.78	122.78	100.0
2005-07-14 09:30:00	QQQ	ETF	38.65	38.88	38.63	38.63	21032700.0
2005-07-14 10:00:00	QQQ	ETF	38.63	38.71	38.52	38.68	12219400.0
2005-07-14 10:30:00	QQQ	ETF	38.68	38.75	38.62	38.7	7014500.0
2005-07-14 11:00:00	QQQ	ETF	38.7	38.73	38.62	38.66	5040900.0
2005-07-14 11:30:00	QQQ	ETF	38.66	38.73	38.6	38.66	4666200.0
2005-07-14 12:00:00	QQQ	ETF	38.66	38.77	38.65	38.71	4254200.0
2005-07-14 12:30:00	QQQ	ETF	38.71	38.74	38.68	38.72	3263000.0
2005-07-14 13:00:00	QQQ	ETF	38.72	38.85	38.71	38.79	7018900.0
2005-07-14 13:30:00	QQQ	ETF	38.79	38.8	38.67	38.69	4576300.0
2005-07-14 14:00:00	QQQ	ETF	38.7	38.74	38.65	38.66	4556200.0
2005-07-14 14:30:00	QQQ	ETF	38.67	38.71	38.63	38.68	4494800.0
2005-07-14 15:00:00	QQQ	ETF	38.68	38.79	38.68	38.77	4998400.0
2005-07-14 15:30:00	QQQ	ETF	38.77	38.82	37.78	38.77	7771400.0
2005-07-14 07:00:00	IWM	ETF	66.65	66.74	66.65	66.73	1300.0
2005-07-14 07:30:00	IWM	ETF	66.75	66.75	66.74	66.75	7000.0
2005-07-14 08:00:00	IWM	ETF	66.73	66.79	66.73	66.79	8100.0
2005-07-14 08:30:00	IWM	ETF	66.8	67.0	66.8	66.95	48000.0
2005-07-14 09:00:00	IWM	ETF	66.97	66.97	66.87	66.87	17500.0
2005-07-14 09:30:00	IWM	ETF	66.9	67.07	66.57	66.57	4396000.0
2005-07-14 10:00:00	IWM	ETF	66.56	66.73	66.45	66.58	2493500.0
2005-07-14 10:30:00	IWM	ETF	66.58	66.68	66.29	66.37	2028800.0
2005-07-14 11:00:00	IWM	ETF	66.38	66.45	66.23	66.3	1762600.0
2005-07-14 11:30:00	IWM	ETF	66.3	66.34	66.02	66.06	1915400.0
2005-07-14 12:00:00	IWM	ETF	66.05	66.17	66.02	66.03	1115300.0
2005-07-14 12:30:00	IWM	ETF	66.05	66.13	65.93	66.02	1599800.0

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

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