PREVIEW / etf_1hour / 2007-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-29.parquet
  size:    82 KB
  rows:    2,767

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-06-29 05:00:00	SPY	ETF	150.35	150.35	150.35	150.35	16900.0
2007-06-29 06:00:00	SPY	ETF	150.2	150.2	149.9	150.03	28700.0
2007-06-29 07:00:00	SPY	ETF	149.93	150.15	149.93	150.08	378100.0
2007-06-29 08:00:00	SPY	ETF	150.12	150.7	150.12	150.7	3261800.0
2007-06-29 09:00:00	SPY	ETF	150.7	151.47	150.69	151.27	19942790.0
2007-06-29 10:00:00	SPY	ETF	151.26	151.65	151.12	151.16	19484148.0
2007-06-29 11:00:00	SPY	ETF	151.16	151.29	150.85	151.0	10718747.0
2007-06-29 12:00:00	SPY	ETF	151.01	151.04	150.24	150.5	19034500.0
2007-06-29 13:00:00	SPY	ETF	150.5	150.82	150.24	150.66	17658775.0
2007-06-29 14:00:00	SPY	ETF	150.66	150.71	149.96	150.3	24543258.0
2007-06-29 15:00:00	SPY	ETF	150.29	150.42	149.15	150.06	61361783.0
2007-06-29 16:00:00	SPY	ETF	150.25	150.45	149.98	150.31	5917400.0
2007-06-29 17:00:00	SPY	ETF	150.3	150.43	150.1784	150.33	6642900.0
2007-06-29 18:00:00	SPY	ETF	150.31	150.33	150.28	150.33	1700.0
2007-06-29 19:00:00	SPY	ETF	150.32	150.33	150.28	150.28	4100.0
2007-06-29 05:00:00	QQQ	ETF	47.57	47.57	47.57	47.57	20000.0
2007-06-29 06:00:00	QQQ	ETF	47.51	47.51	47.46	47.47	23300.0
2007-06-29 07:00:00	QQQ	ETF	47.43	47.54	47.41	47.51	187877.0
2007-06-29 08:00:00	QQQ	ETF	47.54	47.74	47.53	47.72	2361501.0
2007-06-29 09:00:00	QQQ	ETF	47.72	47.81	47.71	47.77	12547249.0
2007-06-29 10:00:00	QQQ	ETF	47.76	47.88	47.76	47.78	14203366.0
2007-06-29 11:00:00	QQQ	ETF	47.79	47.84	47.68	47.76	9809439.0
2007-06-29 12:00:00	QQQ	ETF	47.76	47.77	47.53	47.62	18529046.0
2007-06-29 13:00:00	QQQ	ETF	47.63	47.73	47.58	47.68	7931402.0
2007-06-29 14:00:00	QQQ	ETF	47.69	47.69	47.52	47.59	11109817.0
2007-06-29 15:00:00	QQQ	ETF	47.59	47.62	47.21	47.56	36227341.0
2007-06-29 16:00:00	QQQ	ETF	47.56	47.7	47.56	47.64	4782215.0
2007-06-29 17:00:00	QQQ	ETF	47.6	47.66	47.51	47.51	228732.0
2007-06-29 18:00:00	QQQ	ETF	47.62	47.62	47.62	47.62	1000.0
2007-06-29 19:00:00	QQQ	ETF	47.57	47.6	47.57	47.57	4400.0
2007-06-29 07:00:00	IWM	ETF	83.13	83.15	83.12	83.12	14600.0
2007-06-29 08:00:00	IWM	ETF	83.16	83.62	83.16	83.62	971100.0
2007-06-29 09:00:00	IWM	ETF	83.61	84.11	83.51	83.93	12698806.0
2007-06-29 10:00:00	IWM	ETF	83.94	84.19	83.88	83.95	15222240.0
2007-06-29 11:00:00	IWM	ETF	83.94	84.12	83.8	83.89	8026740.0
2007-06-29 12:00:00	IWM	ETF	83.89	83.94	83.35	83.52	10880867.0
2007-06-29 13:00:00	IWM	ETF	83.52	83.75	83.39	83.69	4633730.0
2007-06-29 14:00:00	IWM	ETF	83.68	83.69	83.16	83.37	7331567.0
2007-06-29 15:00:00	IWM	ETF	83.39	83.43	82.7	82.78	32787095.0
2007-06-29 16:00:00	IWM	ETF	82.78	83.4509	82.66	82.96	8547400.0
2007-06-29 17:00:00	IWM	ETF	83.01	83.02	83.01	83.02	60000.0
2007-06-29 07:00:00	DIA	ETF	133.88	133.88	133.87	133.87	5100.0
2007-06-29 08:00:00	DIA	ETF	133.93	134.27	133.89	134.22	34500.0
2007-06-29 09:00:00	DIA	ETF	134.31	134.84	134.25	134.75	1328506.0
2007-06-29 10:00:00	DIA	ETF	134.74	135.12	134.7	134.73	3855017.0
2007-06-29 11:00:00	DIA	ETF	134.73	134.86	134.48	134.61	1533526.0
2007-06-29 12:00:00	DIA	ETF	134.61	134.64	133.92	134.2	2302632.0
2007-06-29 13:00:00	DIA	ETF	134.19	134.41	133.97	134.3	1899931.0
2007-06-29 14:00:00	DIA	ETF	134.29	134.32	133.75	134.05	2451462.0
2007-06-29 15:00:00	DIA	ETF	134.05	134.1	132.85	134.0	4924892.0

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

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