PREVIEW / etf_30min / 2007-12-17

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-17.parquet
  size:    149 KB
  rows:    5,381

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-12-17 04:00:00	SPY	ETF	146.08	146.15	146.03	146.12	7100.0
2007-12-17 05:30:00	SPY	ETF	146.28	146.36	146.28	146.36	8300.0
2007-12-17 06:00:00	SPY	ETF	146.31	146.53	146.31	146.43	15100.0
2007-12-17 06:30:00	SPY	ETF	146.43	146.45	146.26	146.28	64200.0
2007-12-17 07:00:00	SPY	ETF	146.27	146.29	146.15	146.28	216300.0
2007-12-17 07:30:00	SPY	ETF	146.29	146.7	146.27	146.61	535100.0
2007-12-17 08:00:00	SPY	ETF	146.62	146.77	146.21	146.71	2513300.0
2007-12-17 08:30:00	SPY	ETF	146.7	147.05	146.34	146.71	1629800.0
2007-12-17 09:00:00	SPY	ETF	146.7	146.72	146.54	146.62	2209700.0
2007-12-17 09:30:00	SPY	ETF	146.61	146.72	146.14	146.21	19639490.0
2007-12-17 10:00:00	SPY	ETF	146.2	146.7	146.03	146.44	12668962.0
2007-12-17 10:30:00	SPY	ETF	146.43	146.79	146.22	146.67	12445327.0
2007-12-17 11:00:00	SPY	ETF	146.66	146.87	146.39	146.42	10518917.0
2007-12-17 11:30:00	SPY	ETF	146.41	146.57	146.03	146.27	7954981.0
2007-12-17 12:00:00	SPY	ETF	146.26	146.63	146.18	146.39	4160558.0
2007-12-17 12:30:00	SPY	ETF	146.39	146.57	146.19	146.56	3757271.0
2007-12-17 13:00:00	SPY	ETF	146.56	146.57	145.68	145.91	18600995.0
2007-12-17 13:30:00	SPY	ETF	145.91	146.04	145.47	145.48	7577676.0
2007-12-17 14:00:00	SPY	ETF	145.48	145.86	145.42	145.8	7689921.0
2007-12-17 14:30:00	SPY	ETF	145.8	145.99	145.29	145.37	11031218.0
2007-12-17 15:00:00	SPY	ETF	145.37	145.46	145.03	145.14	13896759.0
2007-12-17 15:30:00	SPY	ETF	145.15	145.78	144.94	145.07	20523798.0
2007-12-17 16:00:00	SPY	ETF	145.07	145.5272	144.86	145.05	8943200.0
2007-12-17 16:30:00	SPY	ETF	145.06	145.13	144.99	145.07	1498600.0
2007-12-17 17:00:00	SPY	ETF	145.01	145.08	144.99	145.03	209600.0
2007-12-17 17:30:00	SPY	ETF	147.22	147.22	145.0	147.22	2011100.0
2007-12-17 18:00:00	SPY	ETF	145.08	145.28	145.08	145.26	73800.0
2007-12-17 18:30:00	SPY	ETF	145.28	145.35	145.27	145.35	89600.0
2007-12-17 19:00:00	SPY	ETF	145.35	145.4	145.16	145.16	65900.0
2007-12-17 19:30:00	SPY	ETF	145.21	145.27	145.17	145.27	25100.0
2007-12-17 04:00:00	QQQ	ETF	50.58	50.59	50.58	50.59	2100.0
2007-12-17 05:30:00	QQQ	ETF	50.65	50.7	50.65	50.7	400.0
2007-12-17 06:00:00	QQQ	ETF	50.77	50.77	50.71	50.72	3400.0
2007-12-17 06:30:00	QQQ	ETF	50.72	50.75	50.67	50.67	16900.0
2007-12-17 07:00:00	QQQ	ETF	50.64	50.68	50.63	50.63	1110.0
2007-12-17 07:30:00	QQQ	ETF	50.68	50.8	50.65	50.78	144070.0
2007-12-17 08:00:00	QQQ	ETF	50.78	50.8	50.72	50.78	230880.0
2007-12-17 08:30:00	QQQ	ETF	50.77	50.83	50.7	50.78	425095.0
2007-12-17 09:00:00	QQQ	ETF	50.79	50.81	50.74	50.79	413412.0
2007-12-17 09:30:00	QQQ	ETF	50.79	50.94	50.65	50.65	13587617.0
2007-12-17 10:00:00	QQQ	ETF	50.66	50.73	50.51	50.56	14122587.0
2007-12-17 10:30:00	QQQ	ETF	50.56	50.69	50.49	50.6299	5679875.0
2007-12-17 11:00:00	QQQ	ETF	50.63	50.6894	50.4	50.42	8703843.0
2007-12-17 11:30:00	QQQ	ETF	50.42	50.49	50.23	50.33	9004356.0
2007-12-17 12:00:00	QQQ	ETF	50.32	50.39	50.27	50.3799	4140033.0
2007-12-17 12:30:00	QQQ	ETF	50.3708	50.49	50.28	50.4801	9359769.0
2007-12-17 13:00:00	QQQ	ETF	50.49	50.49	50.18	50.2	8663582.0
2007-12-17 13:30:00	QQQ	ETF	50.21	50.26	49.93	49.96	9989368.0
2007-12-17 14:00:00	QQQ	ETF	49.95	50.09	49.9	50.06	6173696.0
2007-12-17 14:30:00	QQQ	ETF	50.07	50.14	49.83	49.87	7495733.0

> showing 50 of 5,381 rows — these rows as CSV

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