PREVIEW / etf_1hour / 2007-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-12.parquet
  size:    81 KB
  rows:    2,734

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-09-12 04:00:00	SPY	ETF	147.36	147.36	147.36	147.36	100.0
2007-09-12 05:00:00	SPY	ETF	147.13	147.13	147.08	147.13	27500.0
2007-09-12 06:00:00	SPY	ETF	147.25	147.25	147.25	147.25	2500.0
2007-09-12 07:00:00	SPY	ETF	147.33	147.33	146.96	147.02	577100.0
2007-09-12 08:00:00	SPY	ETF	147.03	147.49	146.91	147.19	1084900.0
2007-09-12 09:00:00	SPY	ETF	147.12	147.73	146.98	147.65	20559513.0
2007-09-12 10:00:00	SPY	ETF	147.65	148.02	147.32	147.64	28988500.0
2007-09-12 11:00:00	SPY	ETF	147.64	148.21	147.56	147.95	21795600.0
2007-09-12 12:00:00	SPY	ETF	147.95	148.18	147.58	147.81	11850900.0
2007-09-12 13:00:00	SPY	ETF	147.81	148.15	147.45	147.99	14588500.0
2007-09-12 14:00:00	SPY	ETF	147.99	148.44	147.85	148.21	15755100.0
2007-09-12 15:00:00	SPY	ETF	148.21	148.22	147.48	147.64	28818000.0
2007-09-12 16:00:00	SPY	ETF	147.65	147.9884	147.5994	147.91	3633300.0
2007-09-12 17:00:00	SPY	ETF	147.93	147.94	147.73	147.84	103700.0
2007-09-12 18:00:00	SPY	ETF	147.84	147.84	147.76	147.81	13700.0
2007-09-12 19:00:00	SPY	ETF	147.81	147.83	147.7	147.71	13300.0
2007-09-12 06:00:00	QQQ	ETF	48.86	48.88	48.86	48.86	10300.0
2007-09-12 07:00:00	QQQ	ETF	48.83	48.85	48.72	48.79	697219.0
2007-09-12 08:00:00	QQQ	ETF	48.79	48.85	48.74	48.77	929245.0
2007-09-12 09:00:00	QQQ	ETF	48.75	49.09	48.75	49.08	12571776.0
2007-09-12 10:00:00	QQQ	ETF	49.0775	49.23	48.99	49.14	13550160.0
2007-09-12 11:00:00	QQQ	ETF	49.13	49.37	49.1	49.27	10661015.0
2007-09-12 12:00:00	QQQ	ETF	49.26	49.33	49.1	49.16	7677514.0
2007-09-12 13:00:00	QQQ	ETF	49.15	49.24	49.01	49.19	9693035.0
2007-09-12 14:00:00	QQQ	ETF	49.19	49.31	49.08	49.16	8503185.0
2007-09-12 15:00:00	QQQ	ETF	49.16	49.17	48.87	48.93	16799446.0
2007-09-12 16:00:00	QQQ	ETF	48.93	49.07	48.92	49.05	1396753.0
2007-09-12 17:00:00	QQQ	ETF	49.03	49.05	48.99	49.0	70030.0
2007-09-12 18:00:00	QQQ	ETF	49.0	49.02	48.99	49.02	15000.0
2007-09-12 19:00:00	QQQ	ETF	49.03	49.03	48.99	49.0	12393.0
2007-09-12 07:00:00	IWM	ETF	77.82	77.86	77.78	77.81	12700.0
2007-09-12 08:00:00	IWM	ETF	77.79	77.99	77.6	77.7	240000.0
2007-09-12 09:00:00	IWM	ETF	77.69	78.12	77.59	78.0	6478800.0
2007-09-12 10:00:00	IWM	ETF	77.99	78.08	77.68	77.81	8643400.0
2007-09-12 11:00:00	IWM	ETF	77.81	78.16	77.73	77.9	4725400.0
2007-09-12 12:00:00	IWM	ETF	77.91	78.1	77.61	77.74	3108400.0
2007-09-12 13:00:00	IWM	ETF	77.73	77.89	77.38	77.82	7955400.0
2007-09-12 14:00:00	IWM	ETF	77.82	78.15	77.71	77.97	8802100.0
2007-09-12 15:00:00	IWM	ETF	77.97	77.98	77.42	77.46	13289100.0
2007-09-12 16:00:00	IWM	ETF	77.47	77.58	77.4	77.5	1961800.0
2007-09-12 17:00:00	IWM	ETF	77.54	77.54	77.5	77.5	30500.0
2007-09-12 18:00:00	IWM	ETF	77.5	77.5	77.5	77.5	7000.0
2007-09-12 19:00:00	IWM	ETF	77.53	77.53	77.53	77.53	500.0
2007-09-12 07:00:00	DIA	ETF	132.88	132.88	132.83	132.83	1000.0
2007-09-12 08:00:00	DIA	ETF	132.78	132.95	132.7	132.93	18100.0
2007-09-12 09:00:00	DIA	ETF	132.86	133.2	132.73	133.14	1382500.0
2007-09-12 10:00:00	DIA	ETF	133.14	133.39	132.87	133.09	1712200.0
2007-09-12 11:00:00	DIA	ETF	133.11	133.57	133.02	133.35	1276100.0
2007-09-12 12:00:00	DIA	ETF	133.35	133.58	133.09	133.26	719700.0
2007-09-12 13:00:00	DIA	ETF	133.24	133.5	132.95	133.38	1768500.0

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

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