PREVIEW / etf_30min / 2007-02-07

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-07.parquet
  size:    99 KB
  rows:    3,482

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-07 06:00:00	SPY	ETF	145.01	145.01	145.01	145.01	15000.0
2007-02-07 06:30:00	SPY	ETF	145.0	145.0	145.0	145.0	100.0
2007-02-07 07:00:00	SPY	ETF	144.93	145.01	144.93	145.01	95000.0
2007-02-07 07:30:00	SPY	ETF	145.0	145.08	145.0	145.08	39700.0
2007-02-07 08:00:00	SPY	ETF	145.07	145.07	144.99	145.05	62000.0
2007-02-07 08:30:00	SPY	ETF	145.06	145.2	145.03	145.16	601800.0
2007-02-07 09:00:00	SPY	ETF	145.16	145.17	145.08	145.12	415500.0
2007-02-07 09:30:00	SPY	ETF	145.12	145.19	144.87	144.96	7169600.0
2007-02-07 10:00:00	SPY	ETF	144.96	145.22	144.87	145.1	5405100.0
2007-02-07 10:30:00	SPY	ETF	145.11	145.34	145.06	145.25	4931600.0
2007-02-07 11:00:00	SPY	ETF	145.25	145.34	145.19	145.23	1901600.0
2007-02-07 11:30:00	SPY	ETF	145.23	145.33	145.18	145.27	1739200.0
2007-02-07 12:00:00	SPY	ETF	145.26	145.34	145.23	145.25	1740300.0
2007-02-07 12:30:00	SPY	ETF	145.25	145.36	145.2	145.3	2703500.0
2007-02-07 13:00:00	SPY	ETF	145.29	145.36	145.22	145.27	3862100.0
2007-02-07 13:30:00	SPY	ETF	145.26	145.29	145.13	145.16	2892800.0
2007-02-07 14:00:00	SPY	ETF	145.16	145.21	144.94	145.05	4365900.0
2007-02-07 14:30:00	SPY	ETF	145.05	145.06	144.57	144.755	5408900.0
2007-02-07 15:00:00	SPY	ETF	144.75	144.97	144.75	144.89	3828300.0
2007-02-07 15:30:00	SPY	ETF	144.89	145.06	144.83	145.03	4756400.0
2007-02-07 16:00:00	SPY	ETF	145.04	145.21	144.99	145.14	661200.0
2007-02-07 16:30:00	SPY	ETF	145.17	145.18	145.13	145.13	87000.0
2007-02-07 17:00:00	SPY	ETF	145.13	145.17	145.12	145.16	44100.0
2007-02-07 17:30:00	SPY	ETF	145.17	145.19	145.17	145.17	1700.0
2007-02-07 18:00:00	SPY	ETF	145.17	145.17	145.13	145.13	18400.0
2007-02-07 18:30:00	SPY	ETF	145.13	145.13	145.12	145.12	4400.0
2007-02-07 19:00:00	SPY	ETF	145.12	145.12	145.12	145.12	1100.0
2007-02-07 19:30:00	SPY	ETF	145.11	145.11	145.11	145.11	300.0
2007-02-07 04:00:00	QQQ	ETF	44.24	44.24	44.24	44.24	100.0
2007-02-07 05:30:00	QQQ	ETF	44.26	44.26	44.23	44.23	200.0
2007-02-07 07:30:00	QQQ	ETF	44.24	44.31	44.24	44.3	33128.0
2007-02-07 08:00:00	QQQ	ETF	44.29	44.29	44.26	44.28	589894.0
2007-02-07 08:30:00	QQQ	ETF	44.29	44.35	44.27	44.32	1843759.0
2007-02-07 09:00:00	QQQ	ETF	44.33	44.33	44.26	44.29	559805.0
2007-02-07 09:30:00	QQQ	ETF	44.28	44.35	44.12	44.19	14271800.0
2007-02-07 10:00:00	QQQ	ETF	44.19	44.38	44.12	44.33	12772100.0
2007-02-07 10:30:00	QQQ	ETF	44.33	44.61	44.29	44.58	16879500.0
2007-02-07 11:00:00	QQQ	ETF	44.58	44.65	44.54	44.54	9262500.0
2007-02-07 11:30:00	QQQ	ETF	44.55	44.58	44.51	44.53	3605500.0
2007-02-07 12:00:00	QQQ	ETF	44.53	44.6	44.53	44.55	2635600.0
2007-02-07 12:30:00	QQQ	ETF	44.55	44.63	44.53	44.59	3324000.0
2007-02-07 13:00:00	QQQ	ETF	44.59	44.65	44.57	44.58	2953300.0
2007-02-07 13:30:00	QQQ	ETF	44.58	44.6	44.51	44.52	4784600.0
2007-02-07 14:00:00	QQQ	ETF	44.52	44.55	44.46	44.53	7122600.0
2007-02-07 14:30:00	QQQ	ETF	44.54	44.54	44.27	44.34	15762900.0
2007-02-07 15:00:00	QQQ	ETF	44.34	44.42	44.33	44.39	6311600.0
2007-02-07 15:30:00	QQQ	ETF	44.39	44.5	44.36	44.49	9391900.0
2007-02-07 16:00:00	QQQ	ETF	44.49	44.58	44.48	44.57	2956570.0
2007-02-07 16:30:00	QQQ	ETF	44.57	44.6	44.49	44.57	800113.0
2007-02-07 17:00:00	QQQ	ETF	44.57	44.59	44.54	44.56	368802.0

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

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