PREVIEW / etf_30min / 2007-12-13

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-13.parquet
  size:    142 KB
  rows:    5,296

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
2007-12-13 04:00:00	SPY	ETF	148.6	148.6	148.54	148.54	3000.0
2007-12-13 04:30:00	SPY	ETF	148.42	148.42	148.34	148.35	2500.0
2007-12-13 05:00:00	SPY	ETF	148.65	148.7	148.65	148.7	2000.0
2007-12-13 05:30:00	SPY	ETF	148.76	149.0	148.76	148.98	13700.0
2007-12-13 06:00:00	SPY	ETF	148.88	148.88	148.81	148.86	21000.0
2007-12-13 06:30:00	SPY	ETF	148.78	148.78	148.61	148.61	90000.0
2007-12-13 07:00:00	SPY	ETF	148.64	148.64	147.67	147.67	691200.0
2007-12-13 07:30:00	SPY	ETF	147.7	148.1	147.58	148.1	728200.0
2007-12-13 08:00:00	SPY	ETF	148.1	149.3	147.5	148.01	4325300.0
2007-12-13 08:30:00	SPY	ETF	148.01	148.5	147.42	148.3	4369726.0
2007-12-13 09:00:00	SPY	ETF	148.32	148.48	147.84	148.34	2794300.0
2007-12-13 09:30:00	SPY	ETF	148.32	149.0	147.77	147.94	23322268.0
2007-12-13 10:00:00	SPY	ETF	147.94	148.69	147.62	148.26	23090705.0
2007-12-13 10:30:00	SPY	ETF	148.26	148.45	147.44	147.58	18026713.0
2007-12-13 11:00:00	SPY	ETF	147.58	148.0	147.3	147.69	21704095.0
2007-12-13 11:30:00	SPY	ETF	147.69	148.09	147.53	147.99	12631954.0
2007-12-13 12:00:00	SPY	ETF	147.99	148.16	147.67	147.7901	10831449.0
2007-12-13 12:30:00	SPY	ETF	147.79	147.91	147.46	147.68	5597600.0
2007-12-13 13:00:00	SPY	ETF	147.65	148.09	147.52	147.98	8104463.0
2007-12-13 13:30:00	SPY	ETF	147.98	148.0284	147.51	147.94	7690935.0
2007-12-13 14:00:00	SPY	ETF	147.94	148.78	147.68	148.55	18837100.0
2007-12-13 14:30:00	SPY	ETF	148.56	148.62	148.14	148.33	15053995.0
2007-12-13 15:00:00	SPY	ETF	148.32	148.98	147.97	148.92	16010065.0
2007-12-13 15:30:00	SPY	ETF	148.93	149.39	148.67	149.31	29853940.0
2007-12-13 16:00:00	SPY	ETF	149.2501	149.39	148.0574	149.08	8131800.0
2007-12-13 16:30:00	SPY	ETF	149.13	149.18	148.97	148.99	337000.0
2007-12-13 17:00:00	SPY	ETF	148.99	149.1	148.94	149.03	253100.0
2007-12-13 17:30:00	SPY	ETF	149.09	149.09	149.02	149.03	3100.0
2007-12-13 18:00:00	SPY	ETF	149.03	149.15	149.01	149.15	24600.0
2007-12-13 18:30:00	SPY	ETF	149.15	149.28	149.15	149.27	9300.0
2007-12-13 19:00:00	SPY	ETF	149.25	149.44	149.22	149.44	17200.0
2007-12-13 19:30:00	SPY	ETF	149.45	149.48	149.39	149.39	4100.0
2007-12-13 05:30:00	QQQ	ETF	51.46	51.6	51.46	51.6	300.0
2007-12-13 06:30:00	QQQ	ETF	51.55	51.58	51.53	51.57	33500.0
2007-12-13 07:00:00	QQQ	ETF	51.52	51.53	51.22	51.23	280854.0
2007-12-13 07:30:00	QQQ	ETF	51.2	51.35	51.16	51.31	388639.0
2007-12-13 08:00:00	QQQ	ETF	51.3	51.45	51.16	51.24	1759577.0
2007-12-13 08:30:00	QQQ	ETF	51.26	51.44	51.09	51.41	1621158.0
2007-12-13 09:00:00	QQQ	ETF	51.42	51.43	51.31	51.34	583378.0
2007-12-13 09:30:00	QQQ	ETF	51.34	51.63	51.2	51.26	18297655.0
2007-12-13 10:00:00	QQQ	ETF	51.26	51.48	51.18	51.3	13099219.0
2007-12-13 10:30:00	QQQ	ETF	51.29	51.38	51.01	51.07	16092760.0
2007-12-13 11:00:00	QQQ	ETF	51.075	51.21	51.02	51.11	16359633.0
2007-12-13 11:30:00	QQQ	ETF	51.1	51.23	51.06	51.23	9023358.0
2007-12-13 12:00:00	QQQ	ETF	51.24	51.28	51.1	51.11	10365210.0
2007-12-13 12:30:00	QQQ	ETF	51.12	51.16	51.03	51.1	3632246.0
2007-12-13 13:00:00	QQQ	ETF	51.1	51.23	51.04	51.18	6660955.0
2007-12-13 13:30:00	QQQ	ETF	51.18	51.19	50.98	51.08	4801674.0
2007-12-13 14:00:00	QQQ	ETF	51.0886	51.36	51.01	51.32	11425604.0
2007-12-13 14:30:00	QQQ	ETF	51.32	51.33	51.12	51.25	5826820.0

> showing 50 of 5,296 rows — these rows as CSV

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