PREVIEW / etf_30min / 2006-06-30

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-30.parquet
  size:    72 KB
  rows:    2,610

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
2006-06-30 05:30:00	SPY	ETF	127.14	127.14	127.14	127.14	100.0
2006-06-30 07:00:00	SPY	ETF	127.2	127.25	127.2	127.2	5700.0
2006-06-30 07:30:00	SPY	ETF	127.25	127.28	127.17	127.28	5200.0
2006-06-30 08:00:00	SPY	ETF	127.26	127.29	127.19	127.28	214300.0
2006-06-30 08:30:00	SPY	ETF	127.28	127.57	127.24	127.49	1583600.0
2006-06-30 09:00:00	SPY	ETF	127.49	127.73	127.24	127.48	1317700.0
2006-06-30 09:30:00	SPY	ETF	127.47	127.66	127.23	127.26	7285400.0
2006-06-30 10:00:00	SPY	ETF	127.26	127.3	126.96	127.19	8423000.0
2006-06-30 10:30:00	SPY	ETF	127.2	127.4	127.09	127.34	3774400.0
2006-06-30 11:00:00	SPY	ETF	127.35	127.39	127.21	127.24	2039100.0
2006-06-30 11:30:00	SPY	ETF	127.21	127.35	127.15	127.31	1545400.0
2006-06-30 12:00:00	SPY	ETF	127.31	127.34	127.16	127.23	1111300.0
2006-06-30 12:30:00	SPY	ETF	127.22	127.36	127.16	127.18	1002600.0
2006-06-30 13:00:00	SPY	ETF	127.19	127.28	127.13	127.19	2043900.0
2006-06-30 13:30:00	SPY	ETF	127.19	127.33	127.15	127.28	1975400.0
2006-06-30 14:00:00	SPY	ETF	127.27	127.41	127.2	127.31	2540800.0
2006-06-30 14:30:00	SPY	ETF	127.3	127.57	127.28	127.54	4322500.0
2006-06-30 15:00:00	SPY	ETF	127.53	127.54	127.27	127.3	3784100.0
2006-06-30 15:30:00	SPY	ETF	127.3	127.31	126.99	126.99	6513100.0
2006-06-30 16:00:00	SPY	ETF	126.99	127.28	126.96	127.25	1564800.0
2006-06-30 16:30:00	SPY	ETF	127.24	127.3	126.96	127.15	405900.0
2006-06-30 17:00:00	SPY	ETF	127.2	127.27	127.16	127.25	35000.0
2006-06-30 17:30:00	SPY	ETF	127.17	127.17	127.17	127.17	100.0
2006-06-30 18:00:00	SPY	ETF	127.22	127.22	127.22	127.22	2100.0
2006-06-30 19:00:00	SPY	ETF	127.2	127.2	127.2	127.2	300.0
2006-06-30 09:30:00	QQQ	ETF	39.12	39.14	38.82	38.82	16354300.0
2006-06-30 10:00:00	QQQ	ETF	38.83	38.86	38.69	38.78	14161800.0
2006-06-30 10:30:00	QQQ	ETF	38.78	38.84	38.72	38.82	8217000.0
2006-06-30 11:00:00	QQQ	ETF	38.83	38.87	38.79	38.84	3865600.0
2006-06-30 11:30:00	QQQ	ETF	38.82	38.84	38.74	38.8	3167400.0
2006-06-30 12:00:00	QQQ	ETF	38.8	38.81	38.73	38.76	2550200.0
2006-06-30 12:30:00	QQQ	ETF	38.75	38.83	38.74	38.77	2262500.0
2006-06-30 13:00:00	QQQ	ETF	38.77	38.82	38.75	38.8	1968100.0
2006-06-30 13:30:00	QQQ	ETF	38.79	38.84	38.75	38.83	1943400.0
2006-06-30 14:00:00	QQQ	ETF	38.83	38.85	38.78	38.82	2813600.0
2006-06-30 14:30:00	QQQ	ETF	38.82	38.92	38.8	38.9	4424500.0
2006-06-30 15:00:00	QQQ	ETF	38.9	38.91	38.78	38.79	2691100.0
2006-06-30 15:30:00	QQQ	ETF	38.78	38.8	38.68	38.77	9666200.0
2006-06-30 08:00:00	IWM	ETF	71.2	71.45	71.2	71.36	108800.0
2006-06-30 08:30:00	IWM	ETF	71.39	71.67	71.36	71.56	188000.0
2006-06-30 09:00:00	IWM	ETF	71.58	71.66	71.43	71.43	858500.0
2006-06-30 09:30:00	IWM	ETF	71.46	71.6	70.97	70.9906	11343900.0
2006-06-30 10:00:00	IWM	ETF	71.0	71.0	70.55	70.89	7341800.0
2006-06-30 10:30:00	IWM	ETF	70.89	71.13	70.77	71.11	2735100.0
2006-06-30 11:00:00	IWM	ETF	71.12	71.27	71.03	71.13	3745700.0
2006-06-30 11:30:00	IWM	ETF	71.12	71.21	70.99	71.21	1686500.0
2006-06-30 12:00:00	IWM	ETF	71.22	71.33	71.11	71.23	1603100.0
2006-06-30 12:30:00	IWM	ETF	71.24	71.35	71.17	71.26	1725900.0
2006-06-30 13:00:00	IWM	ETF	71.26	71.4	71.23	71.3	1445200.0
2006-06-30 13:30:00	IWM	ETF	71.29	71.47	71.24	71.46	1690000.0

> showing 50 of 2,610 rows — these rows as CSV

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