PREVIEW / etf_30min / 2007-09-26

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-26.parquet
  size:    127 KB
  rows:    4,796

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-09-26 04:00:00	SPY	ETF	152.06	152.08	151.97	152.03	3800.0
2007-09-26 05:00:00	SPY	ETF	152.05	152.11	152.04	152.11	2500.0
2007-09-26 05:30:00	SPY	ETF	152.15	152.19	152.1	152.1	13400.0
2007-09-26 06:00:00	SPY	ETF	152.1	152.1	152.03	152.07	6000.0
2007-09-26 06:30:00	SPY	ETF	152.07	152.15	152.07	152.15	35000.0
2007-09-26 07:00:00	SPY	ETF	152.1	152.35	152.08	152.26	775600.0
2007-09-26 07:30:00	SPY	ETF	152.25	152.37	152.14	152.14	449100.0
2007-09-26 08:00:00	SPY	ETF	152.2	152.3	152.06	152.23	1655100.0
2007-09-26 08:30:00	SPY	ETF	152.23	152.38	152.08	152.27	1216500.0
2007-09-26 09:00:00	SPY	ETF	152.27	152.33	152.21	152.25	374800.0
2007-09-26 09:30:00	SPY	ETF	152.25	152.41	151.94	152.06	14724954.0
2007-09-26 10:00:00	SPY	ETF	152.06	152.2	151.92	152.08	7386300.0
2007-09-26 10:30:00	SPY	ETF	152.08	152.17	151.86	152.12	7377000.0
2007-09-26 11:00:00	SPY	ETF	152.12	152.62	152.11	152.5	13216700.0
2007-09-26 11:30:00	SPY	ETF	152.5	152.61	152.4	152.46	4596400.0
2007-09-26 12:00:00	SPY	ETF	152.47	152.55	152.34	152.4299	3391000.0
2007-09-26 12:30:00	SPY	ETF	152.43	152.47	152.24	152.28	3503800.0
2007-09-26 13:00:00	SPY	ETF	152.27	152.46	152.27	152.3	4557800.0
2007-09-26 13:30:00	SPY	ETF	152.31	152.31	151.64	151.76	13551300.0
2007-09-26 14:00:00	SPY	ETF	151.77	152.05	151.75	151.94	6964800.0
2007-09-26 14:30:00	SPY	ETF	151.94	152.1	151.83	151.99	6976400.0
2007-09-26 15:00:00	SPY	ETF	151.98	152.76	151.94	152.71	14669500.0
2007-09-26 15:30:00	SPY	ETF	152.71	152.77	152.16	152.37	12688800.0
2007-09-26 16:00:00	SPY	ETF	152.34	152.35	152.12	152.17	1628000.0
2007-09-26 16:30:00	SPY	ETF	152.17	152.33	151.52	152.3	2677900.0
2007-09-26 17:00:00	SPY	ETF	152.3	152.41	152.19	152.19	5099800.0
2007-09-26 17:30:00	SPY	ETF	152.34	152.39	150.52	152.3	3965200.0
2007-09-26 18:00:00	SPY	ETF	152.3	152.31	152.28	152.31	14300.0
2007-09-26 18:30:00	SPY	ETF	152.3	152.3	152.3	152.3	200.0
2007-09-26 19:00:00	SPY	ETF	152.3	152.39	152.28	152.39	19200.0
2007-09-26 19:30:00	SPY	ETF	152.38	152.38	152.38	152.38	22500.0
2007-09-26 05:30:00	QQQ	ETF	51.28	51.29	51.28	51.29	1990.0
2007-09-26 06:00:00	QQQ	ETF	51.28	51.28	51.28	51.28	700.0
2007-09-26 06:30:00	QQQ	ETF	51.29	51.29	51.29	51.29	2500.0
2007-09-26 07:00:00	QQQ	ETF	51.25	51.42	51.25	51.38	913799.0
2007-09-26 07:30:00	QQQ	ETF	51.38	51.4	51.32	51.32	250541.0
2007-09-26 08:00:00	QQQ	ETF	51.34	51.39	51.25	51.36	477317.0
2007-09-26 08:30:00	QQQ	ETF	51.36	51.4	51.3	51.34	1369071.0
2007-09-26 09:00:00	QQQ	ETF	51.35	51.37	51.31	51.35	831842.0
2007-09-26 09:30:00	QQQ	ETF	51.36	51.39	51.2	51.255	13186443.0
2007-09-26 10:00:00	QQQ	ETF	51.26	51.35	51.22	51.33	7381292.0
2007-09-26 10:30:00	QQQ	ETF	51.33	51.37	51.19	51.28	10289106.0
2007-09-26 11:00:00	QQQ	ETF	51.28	51.51	51.27	51.44	10951507.0
2007-09-26 11:30:00	QQQ	ETF	51.44	51.49	51.4	51.42	5374449.0
2007-09-26 12:00:00	QQQ	ETF	51.43	51.46	51.38	51.4425	2226222.0
2007-09-26 12:30:00	QQQ	ETF	51.45	51.47	51.39	51.41	1275883.0
2007-09-26 13:00:00	QQQ	ETF	51.42	51.5	51.41	51.45	2688740.0
2007-09-26 13:30:00	QQQ	ETF	51.45	51.45	51.14	51.17	9471114.0
2007-09-26 14:00:00	QQQ	ETF	51.17	51.3	51.16	51.22	5874403.0
2007-09-26 14:30:00	QQQ	ETF	51.22	51.27	51.12	51.23	6060816.0

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

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