PREVIEW / etf_30min / 2007-07-03

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-03.parquet
  size:    71 KB
  rows:    2,513

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-07-03 06:00:00	SPY	ETF	152.31	152.31	152.31	152.31	3500.0
2007-07-03 06:30:00	SPY	ETF	152.3	152.3	152.3	152.3	25100.0
2007-07-03 07:00:00	SPY	ETF	152.3	152.34	152.25	152.25	78300.0
2007-07-03 07:30:00	SPY	ETF	152.27	152.33	152.25	152.29	445900.0
2007-07-03 08:00:00	SPY	ETF	151.79	152.36	151.79	152.29	518600.0
2007-07-03 08:30:00	SPY	ETF	152.29	152.29	152.16	152.22	507200.0
2007-07-03 09:00:00	SPY	ETF	152.22	152.24	152.16	152.18	321600.0
2007-07-03 09:30:00	SPY	ETF	152.18	152.4	151.99	152.4	11803013.0
2007-07-03 10:00:00	SPY	ETF	152.39	152.5	152.22	152.44	10053514.0
2007-07-03 10:30:00	SPY	ETF	152.44	152.45	152.28	152.31	6924885.0
2007-07-03 11:00:00	SPY	ETF	152.31	152.32	152.08	152.17	4673323.0
2007-07-03 11:30:00	SPY	ETF	152.16	152.24	152.03	152.21	4747291.0
2007-07-03 12:00:00	SPY	ETF	152.21	152.34	152.1406	152.3	4666349.0
2007-07-03 12:30:00	SPY	ETF	152.3	152.41	152.22	152.37	6637617.0
2007-07-03 13:00:00	SPY	ETF	152.38	152.45	152.31	152.34	1090900.0
2007-07-03 16:30:00	SPY	ETF	152.18	152.18	152.15	152.15	700.0
2007-07-03 06:30:00	QQQ	ETF	48.17	48.17	48.17	48.17	100.0
2007-07-03 07:00:00	QQQ	ETF	48.18	48.18	48.14	48.14	44200.0
2007-07-03 07:30:00	QQQ	ETF	48.13	48.18	48.12	48.16	39752.0
2007-07-03 08:00:00	QQQ	ETF	48.16	48.19	48.16	48.17	222785.0
2007-07-03 08:30:00	QQQ	ETF	48.16	48.16	48.12	48.14	218627.0
2007-07-03 09:00:00	QQQ	ETF	48.14	48.14	48.08	48.1	349079.0
2007-07-03 09:30:00	QQQ	ETF	48.1	48.18	48.04	48.17	7593223.0
2007-07-03 10:00:00	QQQ	ETF	48.17	48.25	48.12	48.24	8572754.0
2007-07-03 10:30:00	QQQ	ETF	48.23	48.26	48.21	48.25	2585402.0
2007-07-03 11:00:00	QQQ	ETF	48.24	48.25	48.2	48.22	1962235.0
2007-07-03 11:30:00	QQQ	ETF	48.22	48.24	48.17	48.23	3282580.0
2007-07-03 12:00:00	QQQ	ETF	48.23	48.25	48.2	48.2423	2684376.0
2007-07-03 12:30:00	QQQ	ETF	48.25	48.29	48.22	48.28	5155273.0
2007-07-03 13:00:00	QQQ	ETF	48.28	48.32	48.27	48.31	85310.0
2007-07-03 16:00:00	QQQ	ETF	48.31	48.31	48.3	48.31	2896.0
2007-07-03 07:30:00	IWM	ETF	84.23	84.23	84.23	84.23	19700.0
2007-07-03 08:00:00	IWM	ETF	83.99	84.34	83.99	84.27	396600.0
2007-07-03 08:30:00	IWM	ETF	84.26	84.26	84.26	84.26	13000.0
2007-07-03 09:00:00	IWM	ETF	84.2	84.2	84.12	84.13	164800.0
2007-07-03 09:30:00	IWM	ETF	84.12	84.32	84.03	84.26	4384400.0
2007-07-03 10:00:00	IWM	ETF	84.26	84.35	84.1	84.35	6454000.0
2007-07-03 10:30:00	IWM	ETF	84.35	84.38	84.15	84.24	3240614.0
2007-07-03 11:00:00	IWM	ETF	84.24	84.27	84.15	84.23	3459700.0
2007-07-03 11:30:00	IWM	ETF	84.22	84.26	84.18	84.24	1908600.0
2007-07-03 12:00:00	IWM	ETF	84.25	84.49	84.25	84.47	5008420.0
2007-07-03 12:30:00	IWM	ETF	84.47	84.51	84.15	84.33	3744740.0
2007-07-03 13:00:00	IWM	ETF	84.33	84.44	84.29	84.36	367400.0
2007-07-03 07:00:00	DIA	ETF	135.63	135.63	135.63	135.63	100.0
2007-07-03 08:00:00	DIA	ETF	135.27	135.64	135.27	135.6	6900.0
2007-07-03 08:30:00	DIA	ETF	135.55	135.55	135.5	135.54	15000.0
2007-07-03 09:00:00	DIA	ETF	135.5	135.52	135.5	135.5	3700.0
2007-07-03 09:30:00	DIA	ETF	135.51	135.74	135.34	135.74	3727700.0
2007-07-03 10:00:00	DIA	ETF	135.73	135.83	135.5	135.81	843000.0
2007-07-03 10:30:00	DIA	ETF	135.82	135.86	135.7	135.74	471601.0

> showing 50 of 2,513 rows — these rows as CSV

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