PREVIEW / etf_1hour / 2007-07-03

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-03.parquet
  size:    51 KB
  rows:    1,599

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.3	152.3	28600.0
2007-07-03 07:00:00	SPY	ETF	152.3	152.34	152.25	152.29	524200.0
2007-07-03 08:00:00	SPY	ETF	151.79	152.36	151.79	152.22	1025800.0
2007-07-03 09:00:00	SPY	ETF	152.22	152.4	151.99	152.4	12124613.0
2007-07-03 10:00:00	SPY	ETF	152.39	152.5	152.22	152.31	16978399.0
2007-07-03 11:00:00	SPY	ETF	152.31	152.32	152.03	152.21	9420614.0
2007-07-03 12:00:00	SPY	ETF	152.21	152.41	152.1406	152.37	11303966.0
2007-07-03 13:00:00	SPY	ETF	152.38	152.45	152.31	152.34	1090900.0
2007-07-03 16:00:00	SPY	ETF	152.18	152.18	152.15	152.15	700.0
2007-07-03 06:00: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.12	48.16	83952.0
2007-07-03 08:00:00	QQQ	ETF	48.16	48.19	48.12	48.14	441412.0
2007-07-03 09:00:00	QQQ	ETF	48.14	48.18	48.04	48.17	7942302.0
2007-07-03 10:00:00	QQQ	ETF	48.17	48.26	48.12	48.25	11158156.0
2007-07-03 11:00:00	QQQ	ETF	48.24	48.25	48.17	48.23	5244815.0
2007-07-03 12:00:00	QQQ	ETF	48.23	48.29	48.2	48.28	7839649.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:00: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.26	409600.0
2007-07-03 09:00:00	IWM	ETF	84.2	84.32	84.03	84.26	4549200.0
2007-07-03 10:00:00	IWM	ETF	84.26	84.38	84.1	84.24	9694614.0
2007-07-03 11:00:00	IWM	ETF	84.24	84.27	84.15	84.24	5368300.0
2007-07-03 12:00:00	IWM	ETF	84.25	84.51	84.15	84.33	8753160.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.54	21900.0
2007-07-03 09:00:00	DIA	ETF	135.5	135.74	135.34	135.74	3731400.0
2007-07-03 10:00:00	DIA	ETF	135.73	135.86	135.5	135.74	1314601.0
2007-07-03 11:00:00	DIA	ETF	135.73	135.75	135.5	135.62	946182.0
2007-07-03 12:00:00	DIA	ETF	135.64	135.79	135.62	135.72	816146.0
2007-07-03 13:00:00	DIA	ETF	135.72	135.73	135.65	135.69	58800.0
2007-07-03 08:00:00	GLD	ETF	65.06	65.06	64.98	64.99	55300.0
2007-07-03 09:00:00	GLD	ETF	64.97	65.02	64.87	64.91	327200.0
2007-07-03 10:00:00	GLD	ETF	64.91	64.93	64.58	64.73	909200.0
2007-07-03 11:00:00	GLD	ETF	64.73	64.76	64.62	64.68	235300.0
2007-07-03 12:00:00	GLD	ETF	64.69	64.78	64.65	64.77	249000.0
2007-07-03 13:00:00	GLD	ETF	64.74	64.75	64.71	64.74	4400.0
2007-07-03 08:00:00	TLT	ETF	85.2	85.2	85.2	85.2	500.0
2007-07-03 09:00:00	TLT	ETF	85.25	85.34	85.15	85.25	202400.0
2007-07-03 10:00:00	TLT	ETF	85.26	85.34	84.85	84.85	196545.0
2007-07-03 11:00:00	TLT	ETF	84.84	84.9	84.75	84.76	530930.0
2007-07-03 12:00:00	TLT	ETF	84.75	84.8	84.71	84.75	346000.0
2007-07-03 13:00:00	TLT	ETF	84.75	84.77	84.72	84.77	76300.0

> showing 44 of 1,599 rows — these rows as CSV

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