PREVIEW / etf_1hour / 2007-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-04.parquet
  size:    66 KB
  rows:    2,133

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-04-04 06:00:00	SPY	ETF	143.75	143.75	143.75	143.75	1000.0
2007-04-04 07:00:00	SPY	ETF	143.74	143.79	143.68	143.74	121000.0
2007-04-04 08:00:00	SPY	ETF	143.71	143.85	143.48	143.48	1467400.0
2007-04-04 09:00:00	SPY	ETF	143.49	143.91	143.39	143.63	14134092.0
2007-04-04 10:00:00	SPY	ETF	143.64	143.8	143.16	143.62	13078035.0
2007-04-04 11:00:00	SPY	ETF	143.62	143.84	143.59	143.75	7058702.0
2007-04-04 12:00:00	SPY	ETF	143.75	143.95	143.74	143.84	5557700.0
2007-04-04 13:00:00	SPY	ETF	143.84	143.84	143.54	143.7	6446469.0
2007-04-04 14:00:00	SPY	ETF	143.7	143.82	143.43	143.75	5167450.0
2007-04-04 15:00:00	SPY	ETF	143.75	143.94	143.71	143.79	7418975.0
2007-04-04 16:00:00	SPY	ETF	143.8	143.84	143.71	143.83	2580600.0
2007-04-04 17:00:00	SPY	ETF	143.82	143.83	143.78	143.83	42400.0
2007-04-04 18:00:00	SPY	ETF	143.81	143.84	143.79	143.84	9400.0
2007-04-04 19:00:00	SPY	ETF	143.8	143.8	143.78	143.78	13100.0
2007-04-04 07:00:00	QQQ	ETF	44.22	44.22	44.17	44.18	99800.0
2007-04-04 08:00:00	QQQ	ETF	44.2	44.24	44.13	44.16	750756.0
2007-04-04 09:00:00	QQQ	ETF	44.17	44.31	44.13	44.24	15417119.0
2007-04-04 10:00:00	QQQ	ETF	44.24	44.3	44.13	44.23	22994700.0
2007-04-04 11:00:00	QQQ	ETF	44.22	44.33	44.21	44.28	10167800.0
2007-04-04 12:00:00	QQQ	ETF	44.28	44.38	44.28	44.33	9275700.0
2007-04-04 13:00:00	QQQ	ETF	44.34	44.34	44.17	44.22	8324700.0
2007-04-04 14:00:00	QQQ	ETF	44.22	44.28	44.19	44.26	3376200.0
2007-04-04 15:00:00	QQQ	ETF	44.25	44.3	44.23	44.3	6876000.0
2007-04-04 16:00:00	QQQ	ETF	44.29	44.36	44.28	44.35	7318796.0
2007-04-04 17:00:00	QQQ	ETF	44.35	44.36	44.33	44.36	316397.0
2007-04-04 18:00:00	QQQ	ETF	44.35	44.35	44.34	44.35	12650.0
2007-04-04 19:00:00	QQQ	ETF	44.34	44.36	44.32	44.34	21315.0
2007-04-04 07:00:00	IWM	ETF	80.14	80.14	80.14	80.14	300.0
2007-04-04 08:00:00	IWM	ETF	80.5	80.61	80.39	80.48	136400.0
2007-04-04 09:00:00	IWM	ETF	80.46	80.65	80.0	80.31	5233100.0
2007-04-04 10:00:00	IWM	ETF	80.31	80.39	80.11	80.31	6213500.0
2007-04-04 11:00:00	IWM	ETF	80.32	80.48	80.29	80.4	3141000.0
2007-04-04 12:00:00	IWM	ETF	80.39	80.59	80.37	80.55	4524309.0
2007-04-04 13:00:00	IWM	ETF	80.55	80.56	80.29	80.395	3227131.0
2007-04-04 14:00:00	IWM	ETF	80.4	80.49	80.33	80.45	2178800.0
2007-04-04 15:00:00	IWM	ETF	80.45	80.53	80.39	80.42	4993942.0
2007-04-04 16:00:00	IWM	ETF	80.42	80.54	80.42	80.52	285900.0
2007-04-04 17:00:00	IWM	ETF	80.53	80.54	80.51	80.54	17400.0
2007-04-04 18:00:00	IWM	ETF	80.54	80.54	80.53	80.53	3600.0
2007-04-04 19:00:00	IWM	ETF	80.53	80.53	80.53	80.53	600.0
2007-04-04 08:00:00	DIA	ETF	125.05	125.25	124.92	124.92	28500.0
2007-04-04 09:00:00	DIA	ETF	124.88	125.2	124.83	125.08	748900.0
2007-04-04 10:00:00	DIA	ETF	125.08	125.17	124.87	125.04	1130900.0
2007-04-04 11:00:00	DIA	ETF	125.04	125.23	125.04	125.2	542600.0
2007-04-04 12:00:00	DIA	ETF	125.19	125.34	125.17	125.24	492300.0
2007-04-04 13:00:00	DIA	ETF	125.24	125.24	125.03	125.12	330600.0
2007-04-04 14:00:00	DIA	ETF	125.13	125.22	125.05	125.16	371700.0
2007-04-04 15:00:00	DIA	ETF	125.16	125.28	125.11	125.17	984500.0
2007-04-04 16:00:00	DIA	ETF	125.19	125.2	125.17	125.17	98200.0
2007-04-04 05:00:00	GLD	ETF	65.5	65.5	65.5	65.5	100.0

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

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