PREVIEW / etf_1hour / 2007-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-18.parquet
  size:    77 KB
  rows:    2,661

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-18 05:00:00	SPY	ETF	153.52	153.52	153.52	153.52	1900.0
2007-06-18 06:00:00	SPY	ETF	153.34	153.34	153.34	153.34	4300.0
2007-06-18 07:00:00	SPY	ETF	153.37	153.41	153.29	153.31	404300.0
2007-06-18 08:00:00	SPY	ETF	153.29	153.51	153.29	153.46	1201500.0
2007-06-18 09:00:00	SPY	ETF	153.45	153.48	153.11	153.18	10070066.0
2007-06-18 10:00:00	SPY	ETF	153.18	153.19	152.66	152.9	22500597.0
2007-06-18 11:00:00	SPY	ETF	152.9	153.12	152.77	153.04	7584480.0
2007-06-18 12:00:00	SPY	ETF	153.05	153.21	152.93	153.17	8913413.0
2007-06-18 13:00:00	SPY	ETF	153.16	153.21	152.87	153.0	9201940.0
2007-06-18 14:00:00	SPY	ETF	153.0	153.13	152.83	153.06	8036789.0
2007-06-18 15:00:00	SPY	ETF	153.06	153.1	152.79	152.9	13034276.0
2007-06-18 16:00:00	SPY	ETF	152.91	153.36	152.6	152.62	5161700.0
2007-06-18 17:00:00	SPY	ETF	152.65	152.68	152.6	152.67	149900.0
2007-06-18 18:00:00	SPY	ETF	152.68	152.75	152.67	152.68	16000.0
2007-06-18 19:00:00	SPY	ETF	152.67	152.73	152.67	152.73	1100.0
2007-06-18 04:00:00	QQQ	ETF	47.85	47.9	47.85	47.9	1200.0
2007-06-18 07:00:00	QQQ	ETF	47.78	47.82	47.76	47.78	294544.0
2007-06-18 08:00:00	QQQ	ETF	47.78	47.87	47.78	47.86	967423.0
2007-06-18 09:00:00	QQQ	ETF	47.87	47.88	47.75	47.83	9764071.0
2007-06-18 10:00:00	QQQ	ETF	47.82	47.83	47.67	47.76	13942697.0
2007-06-18 11:00:00	QQQ	ETF	47.76	47.83	47.7	47.78	7898384.0
2007-06-18 12:00:00	QQQ	ETF	47.79	47.87	47.74	47.86	3826608.0
2007-06-18 13:00:00	QQQ	ETF	47.86	47.87	47.74	47.77	6624325.0
2007-06-18 14:00:00	QQQ	ETF	47.78	47.81	47.72	47.8	6465987.0
2007-06-18 15:00:00	QQQ	ETF	47.8	47.86	47.78	47.8	11936167.0
2007-06-18 16:00:00	QQQ	ETF	47.8	47.83	47.6	47.65	8046672.0
2007-06-18 17:00:00	QQQ	ETF	47.62	47.68	47.62	47.65	328248.0
2007-06-18 18:00:00	QQQ	ETF	47.65	47.68	47.64	47.65	93566.0
2007-06-18 19:00:00	QQQ	ETF	47.68	47.69	47.67	47.67	10300.0
2007-06-18 07:00:00	IWM	ETF	84.41	84.44	84.36	84.39	5900.0
2007-06-18 08:00:00	IWM	ETF	84.45	84.63	84.45	84.56	122500.0
2007-06-18 09:00:00	IWM	ETF	84.59	84.63	84.13	84.2	8167097.0
2007-06-18 10:00:00	IWM	ETF	84.2	84.2	83.7	84.13	13914435.0
2007-06-18 11:00:00	IWM	ETF	84.13	84.29	84.0	84.13	3730600.0
2007-06-18 12:00:00	IWM	ETF	84.14	84.41	84.03	84.33	5087800.0
2007-06-18 13:00:00	IWM	ETF	84.33	84.42	84.05	84.13	3656400.0
2007-06-18 14:00:00	IWM	ETF	84.13	84.25	84.0	84.18	5278475.0
2007-06-18 15:00:00	IWM	ETF	84.18	84.31	84.08	84.22	9424232.0
2007-06-18 16:00:00	IWM	ETF	84.22	84.3423	83.89	83.9	1964300.0
2007-06-18 17:00:00	IWM	ETF	83.9	83.95	83.82	83.83	464400.0
2007-06-18 19:00:00	IWM	ETF	83.95	83.95	83.95	83.95	1000.0
2007-06-18 07:00:00	DIA	ETF	136.53	136.55	136.48	136.48	8800.0
2007-06-18 08:00:00	DIA	ETF	136.46	136.61	136.46	136.55	16300.0
2007-06-18 09:00:00	DIA	ETF	136.57	136.57	136.31	136.45	1440900.0
2007-06-18 10:00:00	DIA	ETF	136.45	136.45	135.93	136.09	3499693.0
2007-06-18 11:00:00	DIA	ETF	136.09	136.3	136.0	136.2	926150.0
2007-06-18 12:00:00	DIA	ETF	136.21	136.34	136.08	136.32	1013400.0
2007-06-18 13:00:00	DIA	ETF	136.32	136.35	136.07	136.15	958800.0
2007-06-18 14:00:00	DIA	ETF	136.15	136.23	136.01	136.21	841100.0
2007-06-18 15:00:00	DIA	ETF	136.21	136.25	135.96	136.05	1049540.0

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

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