PREVIEW / etf_30min / 2007-05-24

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-24.parquet
  size:    123 KB
  rows:    4,534

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-05-24 04:00:00	SPY	ETF	152.15	152.15	152.15	152.15	100.0
2007-05-24 06:00:00	SPY	ETF	152.27	152.27	152.27	152.27	5000.0
2007-05-24 07:00:00	SPY	ETF	152.27	152.41	152.26	152.37	275000.0
2007-05-24 07:30:00	SPY	ETF	152.37	152.37	152.29	152.32	75800.0
2007-05-24 08:00:00	SPY	ETF	152.24	152.42	152.24	152.42	392500.0
2007-05-24 08:30:00	SPY	ETF	152.39	152.64	152.27	152.54	3033700.0
2007-05-24 09:00:00	SPY	ETF	152.54	152.6	152.49	152.55	1023307.0
2007-05-24 09:30:00	SPY	ETF	152.53	152.78	152.28	152.65	14374635.0
2007-05-24 10:00:00	SPY	ETF	152.65	153.21	152.54	152.87	18276900.0
2007-05-24 10:30:00	SPY	ETF	152.88	152.93	151.9	152.04	18614541.0
2007-05-24 11:00:00	SPY	ETF	152.04	152.4588	151.6	151.66	17872465.0
2007-05-24 11:30:00	SPY	ETF	151.66	152.04	151.54	151.98	15070138.0
2007-05-24 12:00:00	SPY	ETF	151.97	152.01	151.6	151.69	7926847.0
2007-05-24 12:30:00	SPY	ETF	151.68	151.75	151.26	151.56	12534538.0
2007-05-24 13:00:00	SPY	ETF	151.56	151.79	151.24	151.65	7589524.0
2007-05-24 13:30:00	SPY	ETF	151.65	151.74	151.38	151.7	6549523.0
2007-05-24 14:00:00	SPY	ETF	151.69	151.75	151.22	151.38	8658637.0
2007-05-24 14:30:00	SPY	ETF	151.38	151.731	151.03	151.09	13238095.0
2007-05-24 15:00:00	SPY	ETF	151.1	151.78	150.92	151.01	12554150.0
2007-05-24 15:30:00	SPY	ETF	151.01	151.08	150.74	151.01	21760207.0
2007-05-24 16:00:00	SPY	ETF	151.01	151.18	150.93	151.07	2186300.0
2007-05-24 16:30:00	SPY	ETF	151.11	151.13	151.01	151.06	168900.0
2007-05-24 17:00:00	SPY	ETF	151.06	151.09	150.99	151.06	1726500.0
2007-05-24 17:30:00	SPY	ETF	151.02	151.02	150.98	151.02	78700.0
2007-05-24 18:00:00	SPY	ETF	151.1	151.1	151.05	151.08	122300.0
2007-05-24 18:30:00	SPY	ETF	151.08	151.16	151.08	151.12	9900.0
2007-05-24 19:00:00	SPY	ETF	151.13	151.2	151.13	151.2	3500.0
2007-05-24 19:30:00	SPY	ETF	151.23	151.23	151.17	151.17	2700.0
2007-05-24 05:00:00	QQQ	ETF	46.79	46.79	46.79	46.79	500.0
2007-05-24 07:00:00	QQQ	ETF	46.76	46.83	46.76	46.83	1400.0
2007-05-24 07:30:00	QQQ	ETF	46.83	46.83	46.79	46.79	62682.0
2007-05-24 08:00:00	QQQ	ETF	46.79	46.84	46.76	46.8	87555.0
2007-05-24 08:30:00	QQQ	ETF	46.81	46.93	46.77	46.89	870121.0
2007-05-24 09:00:00	QQQ	ETF	46.89	46.91	46.84	46.86	305002.0
2007-05-24 09:30:00	QQQ	ETF	46.855	46.89	46.6	46.82	20833259.0
2007-05-24 10:00:00	QQQ	ETF	46.83	47.04	46.82	46.9	25259809.0
2007-05-24 10:30:00	QQQ	ETF	46.91	46.95	46.51	46.54	18124936.0
2007-05-24 11:00:00	QQQ	ETF	46.54	46.617	46.26	46.3	26197996.0
2007-05-24 11:30:00	QQQ	ETF	46.292	46.51	46.23	46.49	18997208.0
2007-05-24 12:00:00	QQQ	ETF	46.49	46.53	46.28	46.31	14257690.0
2007-05-24 12:30:00	QQQ	ETF	46.3	46.34	46.17	46.31	10934363.0
2007-05-24 13:00:00	QQQ	ETF	46.32	46.45	46.22	46.39	8242256.0
2007-05-24 13:30:00	QQQ	ETF	46.39	46.39	46.26	46.36	7833607.0
2007-05-24 14:00:00	QQQ	ETF	46.36	46.4	46.16	46.2395	8549291.0
2007-05-24 14:30:00	QQQ	ETF	46.24	46.2695	46.09	46.15	7222723.0
2007-05-24 15:00:00	QQQ	ETF	46.1505	46.21	46.08	46.13	7661237.0
2007-05-24 15:30:00	QQQ	ETF	46.13	46.1495	45.97	46.12	20322375.0
2007-05-24 16:00:00	QQQ	ETF	46.12	46.25	45.98	46.14	1765161.0
2007-05-24 16:30:00	QQQ	ETF	46.14	46.17	46.14	46.14	228534.0
2007-05-24 17:00:00	QQQ	ETF	46.16	46.17	46.14	46.16	1222992.0

> showing 50 of 4,534 rows — these rows as CSV

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