PREVIEW / etf_1hour / 2007-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-30.parquet
  size:    82 KB
  rows:    2,700

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-08-30 04:00:00	SPY	ETF	146.34	146.44	146.34	146.44	2500.0
2007-08-30 05:00:00	SPY	ETF	146.12	146.12	145.87	145.87	1500.0
2007-08-30 06:00:00	SPY	ETF	145.86	145.88	145.6	145.61	313700.0
2007-08-30 07:00:00	SPY	ETF	145.66	145.98	145.6	145.95	1041200.0
2007-08-30 08:00:00	SPY	ETF	146.0	146.12	145.7	145.84	4752600.0
2007-08-30 09:00:00	SPY	ETF	145.84	146.34	145.31	146.05	32625506.0
2007-08-30 10:00:00	SPY	ETF	146.051	146.55	145.87	146.3705	27303500.0
2007-08-30 11:00:00	SPY	ETF	146.37	147.19	146.34	146.87	26535900.0
2007-08-30 12:00:00	SPY	ETF	146.865	147.0	145.86	146.86	30573100.0
2007-08-30 13:00:00	SPY	ETF	146.858	146.99	146.16	146.62	13422600.0
2007-08-30 14:00:00	SPY	ETF	146.62	146.72	145.54	145.67	19829900.0
2007-08-30 15:00:00	SPY	ETF	145.67	146.5	145.64	146.14	27802800.0
2007-08-30 16:00:00	SPY	ETF	146.11	146.7	145.95	146.41	4984900.0
2007-08-30 17:00:00	SPY	ETF	146.35	146.58	146.34	146.5	173300.0
2007-08-30 18:00:00	SPY	ETF	146.5	146.52	146.15	146.39	344000.0
2007-08-30 19:00:00	SPY	ETF	146.37	146.37	146.23	146.26	134900.0
2007-08-30 04:00:00	QQQ	ETF	48.11	48.11	48.11	48.11	1000.0
2007-08-30 05:00:00	QQQ	ETF	48.09	48.09	48.09	48.09	300.0
2007-08-30 06:00:00	QQQ	ETF	47.98	48.0	47.91	47.91	26700.0
2007-08-30 07:00:00	QQQ	ETF	47.95	48.05	47.91	48.02	991785.0
2007-08-30 08:00:00	QQQ	ETF	48.01	48.07	47.92	47.95	3475261.0
2007-08-30 09:00:00	QQQ	ETF	47.94	48.27	47.75	48.18	13800944.0
2007-08-30 10:00:00	QQQ	ETF	48.18	48.58	48.14	48.49	25121979.0
2007-08-30 11:00:00	QQQ	ETF	48.49	48.74	48.4801	48.62	15875164.0
2007-08-30 12:00:00	QQQ	ETF	48.61	48.66	48.32	48.61	18548440.0
2007-08-30 13:00:00	QQQ	ETF	48.61	48.65	48.3914	48.54	8431378.0
2007-08-30 14:00:00	QQQ	ETF	48.55	48.58	48.03	48.1	14864126.0
2007-08-30 15:00:00	QQQ	ETF	48.09	48.37	48.09	48.31	12821916.0
2007-08-30 16:00:00	QQQ	ETF	48.32	48.5	48.29	48.49	1901060.0
2007-08-30 17:00:00	QQQ	ETF	48.49	48.59	48.48	48.53	480979.0
2007-08-30 18:00:00	QQQ	ETF	48.54	48.54	48.48	48.49	40427.0
2007-08-30 19:00:00	QQQ	ETF	48.5	48.5	48.48	48.5	17176.0
2007-08-30 07:00:00	IWM	ETF	78.1	78.19	78.0	78.19	46400.0
2007-08-30 08:00:00	IWM	ETF	78.17	78.2	77.92	77.94	2026900.0
2007-08-30 09:00:00	IWM	ETF	77.94	78.5	77.5	78.21	7152765.0
2007-08-30 10:00:00	IWM	ETF	78.21	78.51	77.99	78.28	7752800.0
2007-08-30 11:00:00	IWM	ETF	78.29	78.95	78.29	78.78	8182400.0
2007-08-30 12:00:00	IWM	ETF	78.78	78.78	78.05	78.68	6829100.0
2007-08-30 13:00:00	IWM	ETF	78.67	78.71	78.09	78.3	4541700.0
2007-08-30 14:00:00	IWM	ETF	78.31	78.45	77.58	77.71	9048100.0
2007-08-30 15:00:00	IWM	ETF	77.7	78.34	77.69	78.03	7025500.0
2007-08-30 16:00:00	IWM	ETF	78.03	78.15	77.93	78.15	1652300.0
2007-08-30 17:00:00	IWM	ETF	78.19	78.37	78.12	78.37	44300.0
2007-08-30 18:00:00	IWM	ETF	78.26	78.27	78.26	78.27	14000.0
2007-08-30 07:00:00	DIA	ETF	132.27	132.32	132.1	132.18	38000.0
2007-08-30 08:00:00	DIA	ETF	132.38	132.42	132.2	132.25	66800.0
2007-08-30 09:00:00	DIA	ETF	132.27	132.38	131.75	132.26	1748100.0
2007-08-30 10:00:00	DIA	ETF	132.25	132.59	132.11	132.43	1572500.0
2007-08-30 11:00:00	DIA	ETF	132.43	133.1	132.43	132.91	1468500.0
2007-08-30 12:00:00	DIA	ETF	132.91	133.05	132.19	132.98	2412700.0

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

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