PREVIEW / etf_30min / 2007-03-22

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-22.parquet
  size:    105 KB
  rows:    3,700

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-03-22 05:00:00	SPY	ETF	143.19	143.19	143.19	143.19	1000.0
2007-03-22 06:30:00	SPY	ETF	143.11	143.18	143.11	143.18	4500.0
2007-03-22 07:00:00	SPY	ETF	143.16	143.22	143.08	143.22	25000.0
2007-03-22 07:30:00	SPY	ETF	143.22	143.28	143.14	143.19	562200.0
2007-03-22 08:00:00	SPY	ETF	143.19	143.34	143.16	143.27	514800.0
2007-03-22 08:30:00	SPY	ETF	143.27	143.79	143.26	143.62	2408600.0
2007-03-22 09:00:00	SPY	ETF	143.62	143.68	143.45	143.47	1670400.0
2007-03-22 09:30:00	SPY	ETF	143.47	143.56	143.1	143.14	15921179.0
2007-03-22 10:00:00	SPY	ETF	143.14	143.38	142.98	143.09	16384863.0
2007-03-22 10:30:00	SPY	ETF	143.09	143.21	142.85	142.9	13747486.0
2007-03-22 11:00:00	SPY	ETF	142.9	143.19	142.79	143.15	10443749.0
2007-03-22 11:30:00	SPY	ETF	143.15	143.35	143.05	143.35	6072500.0
2007-03-22 12:00:00	SPY	ETF	143.35	143.59	143.25	143.5	12779150.0
2007-03-22 12:30:00	SPY	ETF	143.51	143.64	143.39	143.39	5141600.0
2007-03-22 13:00:00	SPY	ETF	143.4	143.41	143.25	143.36	3305300.0
2007-03-22 13:30:00	SPY	ETF	143.36	143.37	143.11	143.32	4772225.0
2007-03-22 14:00:00	SPY	ETF	143.33	143.68	143.32	143.35	3702150.0
2007-03-22 14:30:00	SPY	ETF	143.35	143.595	143.31	143.46	2944450.0
2007-03-22 15:00:00	SPY	ETF	143.47	143.47	143.05	143.22	9335150.0
2007-03-22 15:30:00	SPY	ETF	143.2199	143.37	143.12	143.31	5951900.0
2007-03-22 16:00:00	SPY	ETF	143.31	143.38	143.16	143.17	581100.0
2007-03-22 16:30:00	SPY	ETF	143.16	143.17	143.06	143.13	168400.0
2007-03-22 17:00:00	SPY	ETF	143.15	143.18	143.15	143.16	51100.0
2007-03-22 17:30:00	SPY	ETF	143.12	143.14	143.12	143.13	2900.0
2007-03-22 18:00:00	SPY	ETF	143.16	143.17	143.16	143.17	4600.0
2007-03-22 18:30:00	SPY	ETF	143.16	143.21	143.16	143.2	4100.0
2007-03-22 19:00:00	SPY	ETF	143.16	143.16	143.14	143.14	1100.0
2007-03-22 19:30:00	SPY	ETF	143.13	143.17	143.1	143.16	48000.0
2007-03-22 07:00:00	QQQ	ETF	44.32	44.42	44.32	44.4	347800.0
2007-03-22 07:30:00	QQQ	ETF	44.39	44.45	44.37	44.42	377615.0
2007-03-22 08:00:00	QQQ	ETF	44.42	44.45	44.38	44.4	1940792.0
2007-03-22 08:30:00	QQQ	ETF	44.41	44.53	44.4	44.45	2387613.0
2007-03-22 09:00:00	QQQ	ETF	44.46	44.47	44.42	44.44	839405.0
2007-03-22 09:30:00	QQQ	ETF	44.43	44.45	44.16	44.19	14717000.0
2007-03-22 10:00:00	QQQ	ETF	44.19	44.32	44.15	44.21	7396000.0
2007-03-22 10:30:00	QQQ	ETF	44.21	44.41	44.1	44.14	10464800.0
2007-03-22 11:00:00	QQQ	ETF	44.14	44.41	44.09	44.21	9352400.0
2007-03-22 11:30:00	QQQ	ETF	44.21	44.3	44.18	44.28	2687200.0
2007-03-22 12:00:00	QQQ	ETF	44.28	44.33	44.25	44.3	6405200.0
2007-03-22 12:30:00	QQQ	ETF	44.31	44.41	44.25	44.3	5605900.0
2007-03-22 13:00:00	QQQ	ETF	44.29	44.3	44.19	44.2	4494600.0
2007-03-22 13:30:00	QQQ	ETF	44.21	44.24	44.13	44.21	6229600.0
2007-03-22 14:00:00	QQQ	ETF	44.21	44.41	44.21	44.23	7098100.0
2007-03-22 14:30:00	QQQ	ETF	44.24	44.41	44.22	44.28	11234800.0
2007-03-22 15:00:00	QQQ	ETF	44.29	44.29	44.15	44.25	8837900.0
2007-03-22 15:30:00	QQQ	ETF	44.24	44.41	44.16	44.27	10247000.0
2007-03-22 16:00:00	QQQ	ETF	44.27	44.28	44.2	44.25	3274599.0
2007-03-22 16:30:00	QQQ	ETF	44.24	44.26	44.21	44.22	191215.0
2007-03-22 17:00:00	QQQ	ETF	44.24	44.24	44.21	44.23	58025.0
2007-03-22 17:30:00	QQQ	ETF	44.23	44.24	44.2	44.2	19187.0

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

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