PREVIEW / etf_30min / 2007-12-24

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-24.parquet
  size:    88 KB
  rows:    3,077

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-24 06:30:00	SPY	ETF	148.35	148.35	148.35	148.35	2200.0
2007-12-24 07:00:00	SPY	ETF	148.41	148.65	148.22	148.56	177500.0
2007-12-24 07:30:00	SPY	ETF	148.55	148.63	148.51	148.51	46100.0
2007-12-24 08:00:00	SPY	ETF	148.5	148.65	148.46	148.6	190500.0
2007-12-24 08:30:00	SPY	ETF	148.61	148.83	148.6	148.79	668100.0
2007-12-24 09:00:00	SPY	ETF	148.8	148.87	148.71	148.74	458100.0
2007-12-24 09:30:00	SPY	ETF	148.73	149.27	148.48	149.1	9790504.0
2007-12-24 10:00:00	SPY	ETF	149.1	149.27	149.05	149.07	4711110.0
2007-12-24 10:30:00	SPY	ETF	149.06	149.09	148.89	149.0	3915622.0
2007-12-24 11:00:00	SPY	ETF	149.0	149.11	148.99	149.09	1882316.0
2007-12-24 11:30:00	SPY	ETF	149.09	149.1	148.99	148.99	2090700.0
2007-12-24 12:00:00	SPY	ETF	148.99	149.13	148.98	149.11	6390298.0
2007-12-24 12:30:00	SPY	ETF	149.11	149.48	149.1	149.45	11886017.0
2007-12-24 13:00:00	SPY	ETF	149.45	149.46	149.2	149.32	1512800.0
2007-12-24 13:30:00	SPY	ETF	149.34	149.37	149.34	149.37	30500.0
2007-12-24 14:00:00	SPY	ETF	149.3	149.3	149.25	149.25	700.0
2007-12-24 14:30:00	SPY	ETF	149.31	149.38	149.31	149.38	4500.0
2007-12-24 15:00:00	SPY	ETF	149.31	149.31	149.2	149.2	5600.0
2007-12-24 16:30:00	SPY	ETF	149.32	149.33	149.26	149.26	800.0
2007-12-24 07:00:00	QQQ	ETF	51.93	52.01	51.91	52.01	189349.0
2007-12-24 07:30:00	QQQ	ETF	52.0	52.01	51.97	51.99	43851.0
2007-12-24 08:00:00	QQQ	ETF	51.99	52.0057	51.99	52.0	236599.0
2007-12-24 08:30:00	QQQ	ETF	52.0	52.03	51.99	52.02	312202.0
2007-12-24 09:00:00	QQQ	ETF	52.02	52.05	52.01	52.01	542318.0
2007-12-24 09:30:00	QQQ	ETF	52.01	52.27	51.9501	52.17	9554974.0
2007-12-24 10:00:00	QQQ	ETF	52.18	52.27	52.15	52.2	3813358.0
2007-12-24 10:30:00	QQQ	ETF	52.2	52.25	52.14	52.24	3336795.0
2007-12-24 11:00:00	QQQ	ETF	52.25	52.25	52.2	52.22	1910308.0
2007-12-24 11:30:00	QQQ	ETF	52.21	52.23	52.19	52.21	2297111.0
2007-12-24 12:00:00	QQQ	ETF	52.21	52.26	52.2	52.2101	3914699.0
2007-12-24 12:30:00	QQQ	ETF	52.22	52.4	52.21	52.3	7129522.0
2007-12-24 13:00:00	QQQ	ETF	52.3	52.32	52.21	52.25	1193634.0
2007-12-24 13:30:00	QQQ	ETF	52.23	52.25	52.23	52.23	9983.0
2007-12-24 14:00:00	QQQ	ETF	52.23	52.25	52.22	52.22	10440.0
2007-12-24 14:30:00	QQQ	ETF	52.25	52.25	52.24	52.25	700.0
2007-12-24 15:00:00	QQQ	ETF	52.24	52.25	52.23	52.25	2150.0
2007-12-24 15:30:00	QQQ	ETF	52.25	52.25	52.23	52.23	1200.0
2007-12-24 16:00:00	QQQ	ETF	52.24	52.25	52.24	52.25	600.0
2007-12-24 16:30:00	QQQ	ETF	52.23	52.23	52.23	52.23	100.0
2007-12-24 08:00:00	IWM	ETF	78.65	78.65	78.61	78.65	30600.0
2007-12-24 08:30:00	IWM	ETF	78.68	78.75	78.68	78.71	67100.0
2007-12-24 09:00:00	IWM	ETF	78.72	78.73	78.69	78.72	43500.0
2007-12-24 09:30:00	IWM	ETF	78.71	79.17	78.59	78.92	5975485.0
2007-12-24 10:00:00	IWM	ETF	78.91	79.01	78.88	78.93	3086054.0
2007-12-24 10:30:00	IWM	ETF	78.93	78.97	78.8	78.93	3242900.0
2007-12-24 11:00:00	IWM	ETF	78.93	79.1	78.92	79.05	2114836.0
2007-12-24 11:30:00	IWM	ETF	79.06	79.11	78.97	79.02	2347285.0
2007-12-24 12:00:00	IWM	ETF	79.02	79.1	79.0	79.09	1884698.0
2007-12-24 12:30:00	IWM	ETF	79.08	79.33	79.05	79.17	6367467.0
2007-12-24 13:00:00	IWM	ETF	79.18	79.4	79.04	79.16	3703100.0

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

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