PREVIEW / etf_1hour / 2007-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-23.parquet
  size:    79 KB
  rows:    2,657

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-05-23 06:00:00	SPY	ETF	153.07	153.1	152.96	153.0	28300.0
2007-05-23 07:00:00	SPY	ETF	152.95	153.02	152.87	152.87	66000.0
2007-05-23 08:00:00	SPY	ETF	152.92	153.1	152.86	153.06	2103100.0
2007-05-23 09:00:00	SPY	ETF	153.08	153.28	152.82	153.17	17425810.0
2007-05-23 10:00:00	SPY	ETF	153.18	153.5	153.06	153.38	19223694.0
2007-05-23 11:00:00	SPY	ETF	153.38	153.43	153.16	153.19	8643615.0
2007-05-23 12:00:00	SPY	ETF	153.19	153.31	153.15	153.3	6920585.0
2007-05-23 13:00:00	SPY	ETF	153.3	153.475	153.09	153.15	8812890.0
2007-05-23 14:00:00	SPY	ETF	153.14	153.22	152.37	152.87	38072892.0
2007-05-23 15:00:00	SPY	ETF	152.86	152.9	152.38	152.38	21684436.0
2007-05-23 16:00:00	SPY	ETF	152.39	153.45	152.36	152.47	3222400.0
2007-05-23 17:00:00	SPY	ETF	152.45	152.45	152.38	152.44	17200.0
2007-05-23 18:00:00	SPY	ETF	152.4	152.45	152.4	152.44	164900.0
2007-05-23 19:00:00	SPY	ETF	152.48	152.48	152.4	152.41	10200.0
2007-05-23 05:00:00	QQQ	ETF	47.2	47.2	47.2	47.2	1000.0
2007-05-23 07:00:00	QQQ	ETF	47.24	47.24	47.18	47.2	118300.0
2007-05-23 08:00:00	QQQ	ETF	47.2	47.26	47.19	47.23	549211.0
2007-05-23 09:00:00	QQQ	ETF	47.24	47.3	47.09	47.26	13008984.0
2007-05-23 10:00:00	QQQ	ETF	47.25	47.37	47.21	47.2799	16487975.0
2007-05-23 11:00:00	QQQ	ETF	47.28	47.32	47.18	47.27	5983141.0
2007-05-23 12:00:00	QQQ	ETF	47.27	47.32	47.23	47.31	6554122.0
2007-05-23 13:00:00	QQQ	ETF	47.32	47.36	47.14	47.18	9263040.0
2007-05-23 14:00:00	QQQ	ETF	47.18	47.21	46.88	47.001	31746348.0
2007-05-23 15:00:00	QQQ	ETF	47.01	47.04	46.82	46.8474	17619630.0
2007-05-23 16:00:00	QQQ	ETF	46.85	47.25	46.77	46.79	9682471.0
2007-05-23 17:00:00	QQQ	ETF	46.79	46.82	46.78	46.81	139655.0
2007-05-23 18:00:00	QQQ	ETF	46.8	46.81	46.79	46.8	170555.0
2007-05-23 19:00:00	QQQ	ETF	46.8	46.82	46.77	46.78	24783.0
2007-05-23 07:00:00	IWM	ETF	83.49	83.59	83.49	83.57	1700.0
2007-05-23 08:00:00	IWM	ETF	83.57	83.7	83.57	83.65	335300.0
2007-05-23 09:00:00	IWM	ETF	83.65	83.8	83.34	83.72	10082200.0
2007-05-23 10:00:00	IWM	ETF	83.72	84.1	83.7	83.95	10016200.0
2007-05-23 11:00:00	IWM	ETF	83.94	84.01	83.74	83.74	3441554.0
2007-05-23 12:00:00	IWM	ETF	83.74	83.89	83.7	83.87	2769398.0
2007-05-23 13:00:00	IWM	ETF	83.88	84.0	83.72	83.75	3165400.0
2007-05-23 14:00:00	IWM	ETF	83.75	83.9	83.12	83.48	14175100.0
2007-05-23 15:00:00	IWM	ETF	83.48	83.53	82.98	83.05	11478791.0
2007-05-23 16:00:00	IWM	ETF	83.05	83.1	82.9	83.0	1187700.0
2007-05-23 17:00:00	IWM	ETF	83.01	83.05	82.97	82.97	21300.0
2007-05-23 18:00:00	IWM	ETF	82.97	82.97	82.96	82.96	261200.0
2007-05-23 07:00:00	DIA	ETF	135.61	135.63	135.61	135.62	5400.0
2007-05-23 08:00:00	DIA	ETF	135.62	135.74	135.61	135.7	21400.0
2007-05-23 09:00:00	DIA	ETF	135.69	135.76	135.42	135.67	1245400.0
2007-05-23 10:00:00	DIA	ETF	135.67	135.99	135.64	135.86	1713200.0
2007-05-23 11:00:00	DIA	ETF	135.86	135.92	135.69	135.69	705900.0
2007-05-23 12:00:00	DIA	ETF	135.69	135.78	135.65	135.78	770300.0
2007-05-23 13:00:00	DIA	ETF	135.77	135.88	135.57	135.62	965400.0
2007-05-23 14:00:00	DIA	ETF	135.62	135.66	134.94	135.3	3190269.0
2007-05-23 15:00:00	DIA	ETF	135.31	135.39	135.04	135.09	1987700.0
2007-05-23 16:00:00	DIA	ETF	135.11	135.74	135.11	135.18	148400.0

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

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