PREVIEW / etf_30min / 2007-11-09

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-09.parquet
  size:    143 KB
  rows:    5,222

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-11-09 04:00:00	SPY	ETF	147.54	147.54	147.54	147.54	5000.0
2007-11-09 04:30:00	SPY	ETF	147.27	147.27	147.27	147.27	1000.0
2007-11-09 05:00:00	SPY	ETF	147.12	147.12	147.12	147.12	1000.0
2007-11-09 05:30:00	SPY	ETF	146.81	146.81	146.51	146.56	39000.0
2007-11-09 06:00:00	SPY	ETF	146.56	146.56	145.95	145.95	52000.0
2007-11-09 06:30:00	SPY	ETF	145.91	145.91	145.6	145.74	485100.0
2007-11-09 07:00:00	SPY	ETF	145.83	146.4	145.7	146.01	873200.0
2007-11-09 07:30:00	SPY	ETF	146.03	146.18	145.8	145.9	488100.0
2007-11-09 08:00:00	SPY	ETF	145.92	146.17	145.5	145.7	1716100.0
2007-11-09 08:30:00	SPY	ETF	145.72	146.1	145.52	145.91	3201500.0
2007-11-09 09:00:00	SPY	ETF	145.9	145.99	145.52	145.52	1440571.0
2007-11-09 09:30:00	SPY	ETF	145.51	145.95	145.11	145.51	31135768.0
2007-11-09 10:00:00	SPY	ETF	145.52	146.55	145.18	146.19	30610144.0
2007-11-09 10:30:00	SPY	ETF	146.19	146.457	145.54	145.79	12275114.0
2007-11-09 11:00:00	SPY	ETF	145.79	146.05	144.89	145.72	23157075.0
2007-11-09 11:30:00	SPY	ETF	145.71	146.52	145.55	146.39	23636566.0
2007-11-09 12:00:00	SPY	ETF	146.4	146.4	145.69	146.16	10472204.0
2007-11-09 12:30:00	SPY	ETF	146.17	146.82	146.05	146.23	13576270.0
2007-11-09 13:00:00	SPY	ETF	146.23	146.44	145.78	146.27	10325670.0
2007-11-09 13:30:00	SPY	ETF	146.275	146.44	145.9	145.98	9907129.0
2007-11-09 14:00:00	SPY	ETF	145.98	147.24	145.82	147.04	20558620.0
2007-11-09 14:30:00	SPY	ETF	147.03	147.47	146.67	146.92	16403027.0
2007-11-09 15:00:00	SPY	ETF	146.91	147.54	146.79	147.26	14943387.0
2007-11-09 15:30:00	SPY	ETF	147.26	147.28	145.26	145.27	38132547.0
2007-11-09 16:00:00	SPY	ETF	145.36	146.7	145.0	145.0	7829500.0
2007-11-09 16:30:00	SPY	ETF	145.0	145.01	144.9	144.92	200000.0
2007-11-09 17:00:00	SPY	ETF	144.91	145.16	144.85	145.16	48100.0
2007-11-09 17:30:00	SPY	ETF	145.03	145.07	145.0	145.07	11600.0
2007-11-09 18:00:00	SPY	ETF	145.0	145.12	145.0	145.1	2300.0
2007-11-09 18:30:00	SPY	ETF	145.06	145.25	145.0	145.14	8700.0
2007-11-09 19:00:00	SPY	ETF	145.1	145.1	144.99	144.99	2300.0
2007-11-09 19:30:00	SPY	ETF	144.99	145.1	144.85	144.85	11300.0
2007-11-09 05:30:00	QQQ	ETF	51.45	51.45	51.44	51.44	25000.0
2007-11-09 06:00:00	QQQ	ETF	51.25	51.25	51.25	51.25	200.0
2007-11-09 06:30:00	QQQ	ETF	51.08	51.18	51.03	51.08	727462.0
2007-11-09 07:00:00	QQQ	ETF	51.06	51.25	51.02	51.13	993256.0
2007-11-09 07:30:00	QQQ	ETF	51.12	51.16	51.08	51.11	261499.0
2007-11-09 08:00:00	QQQ	ETF	51.11	51.7737	50.93	50.95	1620545.0
2007-11-09 08:30:00	QQQ	ETF	50.95	50.97	50.7	50.85	3180263.0
2007-11-09 09:00:00	QQQ	ETF	50.86	50.86	50.72	50.72	1090220.0
2007-11-09 09:30:00	QQQ	ETF	50.73	50.85	50.28	50.67	46692082.0
2007-11-09 10:00:00	QQQ	ETF	50.67	50.92	50.62	50.79	30970763.0
2007-11-09 10:30:00	QQQ	ETF	50.79	50.88	50.43	50.52	22370800.0
2007-11-09 11:00:00	QQQ	ETF	50.52	50.65	50.18	50.502	23508470.0
2007-11-09 11:30:00	QQQ	ETF	50.5	50.78	50.5	50.69	18179842.0
2007-11-09 12:00:00	QQQ	ETF	50.6999	50.7	50.41	50.58	9565949.0
2007-11-09 12:30:00	QQQ	ETF	50.57	50.87	50.55	50.6194	15874521.0
2007-11-09 13:00:00	QQQ	ETF	50.61	50.73	50.48	50.66	11415776.0
2007-11-09 13:30:00	QQQ	ETF	50.66	50.71	50.4	50.41	8457794.0
2007-11-09 14:00:00	QQQ	ETF	50.4	50.99	50.35	50.89	20399627.0

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

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