PREVIEW / etf_1hour / 2007-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-15.parquet
  size:    78 KB
  rows:    2,660

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-15 06:00:00	SPY	ETF	152.29	152.37	152.26	152.29	35400.0
2007-06-15 07:00:00	SPY	ETF	152.24	152.51	152.24	152.44	738900.0
2007-06-15 08:00:00	SPY	ETF	152.44	153.3	152.3	153.19	11113800.0
2007-06-15 09:00:00	SPY	ETF	153.19	153.44	153.12	153.24	24415745.0
2007-06-15 10:00:00	SPY	ETF	153.24	153.66	153.02	153.53	23973406.0
2007-06-15 11:00:00	SPY	ETF	153.53	153.58	153.2	153.31	14242700.0
2007-06-15 12:00:00	SPY	ETF	153.31	153.46	153.07	153.14	11635210.0
2007-06-15 13:00:00	SPY	ETF	153.15	153.34	152.96	153.22	16441588.0
2007-06-15 14:00:00	SPY	ETF	153.21	153.26	152.93	153.26	10594394.0
2007-06-15 15:00:00	SPY	ETF	153.25	153.33	153.0	153.04	18278025.0
2007-06-15 16:00:00	SPY	ETF	153.06	153.14	152.064	153.05	13309500.0
2007-06-15 17:00:00	SPY	ETF	153.05	153.12	153.04	153.12	403200.0
2007-06-15 18:00:00	SPY	ETF	153.05	153.07	153.05	153.07	3500.0
2007-06-15 19:00:00	SPY	ETF	153.05	153.05	152.97	153.0	16700.0
2007-06-15 06:00:00	QQQ	ETF	47.35	47.36	47.35	47.36	3900.0
2007-06-15 07:00:00	QQQ	ETF	47.36	47.46	47.36	47.44	544426.0
2007-06-15 08:00:00	QQQ	ETF	47.44	47.69	47.39	47.68	6702796.0
2007-06-15 09:00:00	QQQ	ETF	47.67	47.87	47.66	47.71	24141373.0
2007-06-15 10:00:00	QQQ	ETF	47.71	47.82	47.65	47.79	19537002.0
2007-06-15 11:00:00	QQQ	ETF	47.79	47.83	47.71	47.74	9363021.0
2007-06-15 12:00:00	QQQ	ETF	47.75	47.75	47.67	47.7	6053906.0
2007-06-15 13:00:00	QQQ	ETF	47.7	47.77	47.65	47.76	8360659.0
2007-06-15 14:00:00	QQQ	ETF	47.76	47.76	47.66	47.74	6857724.0
2007-06-15 15:00:00	QQQ	ETF	47.75	47.76	47.69	47.76	12034596.0
2007-06-15 16:00:00	QQQ	ETF	47.769	47.79	47.73	47.77	1429594.0
2007-06-15 17:00:00	QQQ	ETF	47.76	47.77	47.76	47.77	28803.0
2007-06-15 18:00:00	QQQ	ETF	47.76	47.77	47.76	47.77	18100.0
2007-06-15 19:00:00	QQQ	ETF	47.77	47.78	47.76	47.77	13350.0
2007-06-15 07:00:00	IWM	ETF	83.5	83.56	83.5	83.55	145500.0
2007-06-15 08:00:00	IWM	ETF	83.52	84.18	83.45	84.17	3503800.0
2007-06-15 09:00:00	IWM	ETF	84.17	84.61	84.11	84.33	17898835.0
2007-06-15 10:00:00	IWM	ETF	84.33	84.77	84.21	84.56	12714389.0
2007-06-15 11:00:00	IWM	ETF	84.56	84.69	84.42	84.46	8159300.0
2007-06-15 12:00:00	IWM	ETF	84.46	84.56	84.19	84.27	9441550.0
2007-06-15 13:00:00	IWM	ETF	84.27	84.35	84.13	84.32	5754000.0
2007-06-15 14:00:00	IWM	ETF	84.32	84.4	84.06	84.39	6560398.0
2007-06-15 15:00:00	IWM	ETF	84.39	84.46	84.23	84.3	7788800.0
2007-06-15 16:00:00	IWM	ETF	84.3	84.48	83.2397	84.31	3813200.0
2007-06-15 17:00:00	IWM	ETF	84.35	84.35	84.35	84.35	400.0
2007-06-15 18:00:00	IWM	ETF	84.31	84.31	84.29	84.29	3300.0
2007-06-15 19:00:00	IWM	ETF	84.29	84.29	84.29	84.29	100.0
2007-06-15 07:00:00	DIA	ETF	135.68	135.73	135.68	135.73	20000.0
2007-06-15 08:00:00	DIA	ETF	135.67	136.3	135.61	136.25	90500.0
2007-06-15 09:00:00	DIA	ETF	136.27	136.85	136.27	136.34	1861784.0
2007-06-15 10:00:00	DIA	ETF	136.36	136.77	136.26	136.69	3444556.0
2007-06-15 11:00:00	DIA	ETF	136.69	136.72	136.46	136.47	943100.0
2007-06-15 12:00:00	DIA	ETF	136.48	136.53	136.33	136.41	697500.0
2007-06-15 13:00:00	DIA	ETF	136.4	136.5	136.26	136.44	1051800.0
2007-06-15 14:00:00	DIA	ETF	136.43	136.46	136.18	136.46	1158400.0
2007-06-15 15:00:00	DIA	ETF	136.46	136.53	136.24	136.3	1404100.0

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

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