PREVIEW / etf_30min / 2007-02-22

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-22.parquet
  size:    102 KB
  rows:    3,562

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-02-22 06:30:00	SPY	ETF	146.12	146.12	146.12	146.12	4000.0
2007-02-22 07:00:00	SPY	ETF	146.09	146.19	146.09	146.18	24400.0
2007-02-22 07:30:00	SPY	ETF	146.18	146.19	146.15	146.15	23700.0
2007-02-22 08:00:00	SPY	ETF	146.15	146.22	146.12	146.2	249900.0
2007-02-22 08:30:00	SPY	ETF	146.2	146.24	146.14	146.14	682100.0
2007-02-22 09:00:00	SPY	ETF	146.14	146.21	146.05	146.05	1504000.0
2007-02-22 09:30:00	SPY	ETF	146.05	146.42	146.04	146.28	7947100.0
2007-02-22 10:00:00	SPY	ETF	146.28	146.32	145.83	145.96	7093300.0
2007-02-22 10:30:00	SPY	ETF	145.96	146.11	145.82	146.05	6109300.0
2007-02-22 11:00:00	SPY	ETF	146.05	146.06	145.4	145.52	9942700.0
2007-02-22 11:30:00	SPY	ETF	145.52	145.63	145.17	145.6	8223900.0
2007-02-22 12:00:00	SPY	ETF	145.59	145.7	145.53	145.6	5179700.0
2007-02-22 12:30:00	SPY	ETF	145.61	145.71	145.6	145.61	2626800.0
2007-02-22 13:00:00	SPY	ETF	145.6	145.82	145.56	145.69	3453200.0
2007-02-22 13:30:00	SPY	ETF	145.69	145.75	145.62	145.69	5068900.0
2007-02-22 14:00:00	SPY	ETF	145.69	145.79	145.66	145.71	2448000.0
2007-02-22 14:30:00	SPY	ETF	145.7	145.72	145.41	145.49	6481200.0
2007-02-22 15:00:00	SPY	ETF	145.49	145.69	145.49	145.6499	2711700.0
2007-02-22 15:30:00	SPY	ETF	145.65	145.84	145.64	145.83	5878900.0
2007-02-22 16:00:00	SPY	ETF	145.84	145.91	145.71	145.83	862500.0
2007-02-22 16:30:00	SPY	ETF	145.82	145.83	145.78	145.83	523300.0
2007-02-22 17:00:00	SPY	ETF	145.8	145.81	145.76	145.76	71500.0
2007-02-22 17:30:00	SPY	ETF	145.8	145.81	145.79	145.79	5200.0
2007-02-22 18:00:00	SPY	ETF	145.79	145.81	145.79	145.81	6600.0
2007-02-22 18:30:00	SPY	ETF	145.81	145.81	145.8	145.8	1000.0
2007-02-22 19:00:00	SPY	ETF	145.81	145.81	145.8	145.8	1600.0
2007-02-22 19:30:00	SPY	ETF	145.81	145.81	145.81	145.81	100.0
2007-02-22 05:00:00	QQQ	ETF	45.28	45.28	45.28	45.28	200.0
2007-02-22 07:00:00	QQQ	ETF	45.29	45.32	45.28	45.32	341133.0
2007-02-22 07:30:00	QQQ	ETF	45.32	45.32	45.29	45.31	367179.0
2007-02-22 08:00:00	QQQ	ETF	45.31	45.39	45.29	45.39	1952311.0
2007-02-22 08:30:00	QQQ	ETF	45.37	45.4	45.33	45.36	615415.0
2007-02-22 09:00:00	QQQ	ETF	45.37	45.4	45.36	45.36	754388.0
2007-02-22 09:30:00	QQQ	ETF	45.36	45.55	45.34	45.47	18731300.0
2007-02-22 10:00:00	QQQ	ETF	45.47	45.48	45.26	45.35	12239000.0
2007-02-22 10:30:00	QQQ	ETF	45.35	45.46	45.25	45.45	7707800.0
2007-02-22 11:00:00	QQQ	ETF	45.45	45.45	45.1	45.18	13711400.0
2007-02-22 11:30:00	QQQ	ETF	45.18	45.23	45.07	45.21	13903400.0
2007-02-22 12:00:00	QQQ	ETF	45.22	45.24	45.16	45.23	5152000.0
2007-02-22 12:30:00	QQQ	ETF	45.23	45.29	45.23	45.24	2711000.0
2007-02-22 13:00:00	QQQ	ETF	45.25	45.32	45.19	45.28	4334500.0
2007-02-22 13:30:00	QQQ	ETF	45.28	45.3	45.23	45.24	2085600.0
2007-02-22 14:00:00	QQQ	ETF	45.24	45.29	45.23	45.26	1615700.0
2007-02-22 14:30:00	QQQ	ETF	45.26	45.27	45.14	45.15	3852300.0
2007-02-22 15:00:00	QQQ	ETF	45.15	45.3	45.15	45.28	9216200.0
2007-02-22 15:30:00	QQQ	ETF	45.28	45.42	45.28	45.42	6885300.0
2007-02-22 16:00:00	QQQ	ETF	45.42	45.48	45.2399	45.47	3897750.0
2007-02-22 16:30:00	QQQ	ETF	45.47	45.47	45.42	45.47	418720.0
2007-02-22 17:00:00	QQQ	ETF	45.46	45.51	45.45	45.5	478094.0
2007-02-22 17:30:00	QQQ	ETF	45.47	45.49	45.46	45.47	18500.0

> showing 50 of 3,562 rows — these rows as CSV

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