PREVIEW / etf_30min / 2005-08-15

all etf 30-min files

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

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-15 07:00:00	SPY	ETF	123.29	123.29	123.23	123.24	51400.0
2005-08-15 07:30:00	SPY	ETF	123.24	123.24	123.11	123.15	94600.0
2005-08-15 08:00:00	SPY	ETF	123.13	123.15	123.03	123.03	17300.0
2005-08-15 08:30:00	SPY	ETF	123.06	123.07	123.04	123.06	71800.0
2005-08-15 09:00:00	SPY	ETF	123.09	123.22	123.09	123.2	130400.0
2005-08-15 09:30:00	SPY	ETF	123.22	123.33	123.0	123.12	5894200.0
2005-08-15 10:00:00	SPY	ETF	123.12	123.16	122.83	122.93	3429600.0
2005-08-15 10:30:00	SPY	ETF	122.94	123.2	122.94	123.18	2617900.0
2005-08-15 11:00:00	SPY	ETF	123.2	123.29	123.0	123.07	1417100.0
2005-08-15 11:30:00	SPY	ETF	123.07	123.23	122.97	123.15	940500.0
2005-08-15 12:00:00	SPY	ETF	123.14	123.58	123.13	123.54	3643600.0
2005-08-15 12:30:00	SPY	ETF	123.52	123.65	123.48	123.52	2275500.0
2005-08-15 13:00:00	SPY	ETF	123.52	123.83	123.5	123.75	3215800.0
2005-08-15 13:30:00	SPY	ETF	123.74	123.87	123.72	123.74	2313700.0
2005-08-15 14:00:00	SPY	ETF	123.74	123.8	123.57	123.74	1473200.0
2005-08-15 14:30:00	SPY	ETF	123.74	123.85	123.63	123.79	1952600.0
2005-08-15 15:00:00	SPY	ETF	123.82	123.86	123.62	123.7	1474400.0
2005-08-15 15:30:00	SPY	ETF	123.7	123.74	123.57	123.65	3031800.0
2005-08-15 16:00:00	SPY	ETF	123.64	123.84	123.605	123.77	591800.0
2005-08-15 16:30:00	SPY	ETF	123.76	123.82	123.59	123.82	119800.0
2005-08-15 17:00:00	SPY	ETF	123.82	123.84	123.8	123.84	6000.0
2005-08-15 17:30:00	SPY	ETF	123.84	123.84	123.82	123.82	500.0
2005-08-15 18:00:00	SPY	ETF	123.84	123.86	123.82	123.85	4600.0
2005-08-15 19:00:00	SPY	ETF	123.81	123.85	123.81	123.81	1100.0
2005-08-15 19:30:00	SPY	ETF	123.83	123.84	123.83	123.84	700.0
2005-08-15 09:30:00	QQQ	ETF	39.14	39.22	39.1	39.2	6740000.0
2005-08-15 10:00:00	QQQ	ETF	39.19	39.21	39.08	39.11	4763200.0
2005-08-15 10:30:00	QQQ	ETF	39.11	39.22	39.11	39.21	3711800.0
2005-08-15 11:00:00	QQQ	ETF	39.21	39.27	39.18	39.2	2738900.0
2005-08-15 11:30:00	QQQ	ETF	39.2	39.26	39.17	39.22	2598100.0
2005-08-15 12:00:00	QQQ	ETF	39.23	39.51	39.22	39.46	7263900.0
2005-08-15 12:30:00	QQQ	ETF	39.46	39.57	39.46	39.5	6874900.0
2005-08-15 13:00:00	QQQ	ETF	39.5	39.58	39.47	39.55	3676000.0
2005-08-15 13:30:00	QQQ	ETF	39.54	39.63	39.52	39.57	5162500.0
2005-08-15 14:00:00	QQQ	ETF	39.57	39.58	39.48	39.54	2587200.0
2005-08-15 14:30:00	QQQ	ETF	39.55	39.58	39.49	39.54	3623600.0
2005-08-15 15:00:00	QQQ	ETF	39.55	39.56	39.49	39.52	3065900.0
2005-08-15 15:30:00	QQQ	ETF	39.52	39.54	39.43	39.46	5387100.0
2005-08-15 08:30:00	IWM	ETF	65.56	65.56	65.56	65.56	8400.0
2005-08-15 09:00:00	IWM	ETF	65.56	65.63	65.53	65.63	23000.0
2005-08-15 09:30:00	IWM	ETF	65.65	65.9	65.41	65.51	1907700.0
2005-08-15 10:00:00	IWM	ETF	65.51	65.56	65.25	65.34	2992800.0
2005-08-15 10:30:00	IWM	ETF	65.37	65.53	65.28	65.49	1000800.0
2005-08-15 11:00:00	IWM	ETF	65.49	65.63	65.41	65.52	1340400.0
2005-08-15 11:30:00	IWM	ETF	65.51	65.7	65.45	65.6	1010100.0
2005-08-15 12:00:00	IWM	ETF	65.6	66.12	65.57	66.07	3954400.0
2005-08-15 12:30:00	IWM	ETF	66.08	66.2	66.05	66.12	2191900.0
2005-08-15 13:00:00	IWM	ETF	66.12	66.38	66.04	66.33	1221400.0
2005-08-15 13:30:00	IWM	ETF	66.34	66.49	66.31	66.34	1526900.0
2005-08-15 14:00:00	IWM	ETF	66.34	66.37	66.22	66.31	1074400.0

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

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