PREVIEW / etf_30min / 2005-09-07

all etf 30-min files

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

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-09-07 07:00:00	SPY	ETF	123.6	123.61	123.6	123.61	7000.0
2005-09-07 07:30:00	SPY	ETF	123.63	123.72	123.63	123.7	13300.0
2005-09-07 08:00:00	SPY	ETF	123.7	123.74	123.62	123.74	56400.0
2005-09-07 08:30:00	SPY	ETF	123.66	123.69	123.55	123.6	395100.0
2005-09-07 09:00:00	SPY	ETF	123.61	123.68	123.59	123.64	190800.0
2005-09-07 09:30:00	SPY	ETF	123.63	123.72	123.5	123.57	3140500.0
2005-09-07 10:00:00	SPY	ETF	123.58	123.63	123.46	123.54	3079500.0
2005-09-07 10:30:00	SPY	ETF	123.52	123.82	123.49	123.81	4022200.0
2005-09-07 11:00:00	SPY	ETF	123.82	123.96	123.63	123.69	3983700.0
2005-09-07 11:30:00	SPY	ETF	123.69	123.79	123.65	123.74	873400.0
2005-09-07 12:00:00	SPY	ETF	123.72	123.79	123.69	123.77	695800.0
2005-09-07 12:30:00	SPY	ETF	123.77	123.88	123.71	123.85	798500.0
2005-09-07 13:00:00	SPY	ETF	123.85	123.98	123.71	123.77	2380800.0
2005-09-07 13:30:00	SPY	ETF	123.76	123.91	123.71	123.87	1128600.0
2005-09-07 14:00:00	SPY	ETF	123.87	123.98	123.63	123.65	2719800.0
2005-09-07 14:30:00	SPY	ETF	123.65	123.95	123.6	123.91	3132300.0
2005-09-07 15:00:00	SPY	ETF	123.91	124.13	123.79	124.05	5880900.0
2005-09-07 15:30:00	SPY	ETF	124.05	124.08	123.89	124.02	4523400.0
2005-09-07 16:00:00	SPY	ETF	124.04	124.04	123.89	123.92	915200.0
2005-09-07 16:30:00	SPY	ETF	123.92	123.92	123.82	123.86	96000.0
2005-09-07 17:00:00	SPY	ETF	123.85	123.88	123.85	123.88	3300.0
2005-09-07 17:30:00	SPY	ETF	123.84	123.91	123.84	123.91	32200.0
2005-09-07 18:00:00	SPY	ETF	123.86	123.86	123.84	123.85	4100.0
2005-09-07 18:30:00	SPY	ETF	123.83	123.83	123.78	123.78	13000.0
2005-09-07 19:00:00	SPY	ETF	123.79	123.79	123.79	123.79	1000.0
2005-09-07 19:30:00	SPY	ETF	123.79	123.8	123.77	123.77	3800.0
2005-09-07 09:30:00	QQQ	ETF	39.3	39.34	39.22	39.26	7732700.0
2005-09-07 10:00:00	QQQ	ETF	39.26	39.28	39.21	39.25	4754000.0
2005-09-07 10:30:00	QQQ	ETF	39.26	39.37	39.24	39.37	5010300.0
2005-09-07 11:00:00	QQQ	ETF	39.37	39.41	39.3	39.32	4382400.0
2005-09-07 11:30:00	QQQ	ETF	39.32	39.35	39.3	39.33	1926200.0
2005-09-07 12:00:00	QQQ	ETF	39.33	39.36	39.31	39.33	3507900.0
2005-09-07 12:30:00	QQQ	ETF	39.33	39.38	39.33	39.37	1494000.0
2005-09-07 13:00:00	QQQ	ETF	39.38	39.42	39.32	39.37	4999700.0
2005-09-07 13:30:00	QQQ	ETF	39.36	39.39	39.33	39.38	2469700.0
2005-09-07 14:00:00	QQQ	ETF	39.38	39.45	39.34	39.36	4265300.0
2005-09-07 14:30:00	QQQ	ETF	39.36	39.42	39.32	39.41	3674100.0
2005-09-07 15:00:00	QQQ	ETF	39.41	39.48	38.44	39.44	4251200.0
2005-09-07 15:30:00	QQQ	ETF	39.43	39.45	39.37	39.41	4099800.0
2005-09-07 08:30:00	IWM	ETF	67.12	67.12	67.06	67.06	300.0
2005-09-07 09:00:00	IWM	ETF	67.06	67.1	67.04	67.08	48600.0
2005-09-07 09:30:00	IWM	ETF	67.13	67.2	66.9	66.93	1234800.0
2005-09-07 10:00:00	IWM	ETF	66.92	67.0	66.88	66.95	1044000.0
2005-09-07 10:30:00	IWM	ETF	66.95	67.28	66.93	67.23	1281700.0
2005-09-07 11:00:00	IWM	ETF	67.25	67.31	67.11	67.17	1285600.0
2005-09-07 11:30:00	IWM	ETF	67.16	67.25	67.13	67.18	556300.0
2005-09-07 12:00:00	IWM	ETF	67.18	67.23	67.16	67.2	136000.0
2005-09-07 12:30:00	IWM	ETF	67.2	67.28	67.14	67.22	305100.0
2005-09-07 13:00:00	IWM	ETF	67.23	67.34	67.14	67.21	593800.0
2005-09-07 13:30:00	IWM	ETF	67.22	67.29	67.19	67.27	640400.0

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

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