PREVIEW / etf_1hour / 2007-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-24.parquet
  size:    83 KB
  rows:    2,716

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-24 05:00:00	SPY	ETF	146.11	146.11	146.11	146.11	100.0
2007-08-24 06:00:00	SPY	ETF	146.26	146.28	146.14	146.28	14000.0
2007-08-24 07:00:00	SPY	ETF	146.25	146.5	146.25	146.32	330400.0
2007-08-24 08:00:00	SPY	ETF	146.32	146.74	146.3	146.55	2761200.0
2007-08-24 09:00:00	SPY	ETF	146.55	146.76	145.95	146.53	14420246.0
2007-08-24 10:00:00	SPY	ETF	146.53	147.19	146.44	146.62	24006100.0
2007-08-24 11:00:00	SPY	ETF	146.61	146.98	146.57	146.98	10924800.0
2007-08-24 12:00:00	SPY	ETF	146.98	147.46	146.79	147.27	15229400.0
2007-08-24 13:00:00	SPY	ETF	147.27	147.53	147.22	147.43	14856700.0
2007-08-24 14:00:00	SPY	ETF	147.43	147.95	147.38	147.95	13443300.0
2007-08-24 15:00:00	SPY	ETF	147.94	148.25	147.54	148.16	23206700.0
2007-08-24 16:00:00	SPY	ETF	148.17	148.39	148.16	148.39	5176600.0
2007-08-24 17:00:00	SPY	ETF	148.37	148.42	148.35	148.4	40500.0
2007-08-24 18:00:00	SPY	ETF	148.37	148.39	148.29	148.29	18700.0
2007-08-24 19:00:00	SPY	ETF	148.3	148.39	148.28	148.3	11500.0
2007-08-24 06:00:00	QQQ	ETF	47.39	47.41	47.39	47.41	2200.0
2007-08-24 07:00:00	QQQ	ETF	47.38	47.44	47.38	47.4	100622.0
2007-08-24 08:00:00	QQQ	ETF	47.41	47.53	47.39	47.42	1170319.0
2007-08-24 09:00:00	QQQ	ETF	47.42	47.52	47.25	47.44	8703845.0
2007-08-24 10:00:00	QQQ	ETF	47.44	47.65	47.44	47.56	13957680.0
2007-08-24 11:00:00	QQQ	ETF	47.57	47.73	47.55	47.72	8045244.0
2007-08-24 12:00:00	QQQ	ETF	47.72	47.96	47.67	47.8601	16324729.0
2007-08-24 13:00:00	QQQ	ETF	47.87	47.95	47.85	47.9	6577697.0
2007-08-24 14:00:00	QQQ	ETF	47.9	48.14	47.87	48.14	10257287.0
2007-08-24 15:00:00	QQQ	ETF	48.132	48.23	48.01	48.21	12261864.0
2007-08-24 16:00:00	QQQ	ETF	48.22	48.31	48.2	48.26	2894053.0
2007-08-24 17:00:00	QQQ	ETF	48.26	48.26	48.21	48.21	49168.0
2007-08-24 18:00:00	QQQ	ETF	48.2	48.25	48.2	48.25	22825.0
2007-08-24 19:00:00	QQQ	ETF	48.28	48.32	48.23	48.23	6778.0
2007-08-24 07:00:00	IWM	ETF	78.46	78.55	78.46	78.49	1200.0
2007-08-24 08:00:00	IWM	ETF	78.5	78.79	78.43	78.63	160100.0
2007-08-24 09:00:00	IWM	ETF	78.62	78.75	78.36	78.44	5642554.0
2007-08-24 10:00:00	IWM	ETF	78.45	79.16	78.44	78.61	10668700.0
2007-08-24 11:00:00	IWM	ETF	78.62	78.93	78.59	78.85	5979100.0
2007-08-24 12:00:00	IWM	ETF	78.85	79.05	78.71	78.91	3807200.0
2007-08-24 13:00:00	IWM	ETF	78.91	79.1	78.68	78.86	7714200.0
2007-08-24 14:00:00	IWM	ETF	78.87	79.41	78.85	79.4	10761600.0
2007-08-24 15:00:00	IWM	ETF	79.4	79.65	79.15	79.54	9440800.0
2007-08-24 16:00:00	IWM	ETF	79.54	79.7	79.35	79.63	4922600.0
2007-08-24 17:00:00	IWM	ETF	79.64	79.64	79.64	79.64	900.0
2007-08-24 18:00:00	IWM	ETF	79.365	79.61	79.365	79.61	5100.0
2007-08-24 07:00:00	DIA	ETF	132.1	132.1	132.06	132.06	300.0
2007-08-24 08:00:00	DIA	ETF	132.05	132.34	132.03	132.25	59200.0
2007-08-24 09:00:00	DIA	ETF	132.18	132.43	132.03	132.32	656500.0
2007-08-24 10:00:00	DIA	ETF	132.33	132.83	132.33	132.46	1409000.0
2007-08-24 11:00:00	DIA	ETF	132.47	132.71	132.42	132.7	1111300.0
2007-08-24 12:00:00	DIA	ETF	132.71	133.08	132.57	132.97	1407500.0
2007-08-24 13:00:00	DIA	ETF	132.97	133.21	132.92	133.18	557800.0
2007-08-24 14:00:00	DIA	ETF	133.19	133.47	133.03	133.45	1082200.0
2007-08-24 15:00:00	DIA	ETF	133.43	133.75	133.16	133.69	1584100.0

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

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