PREVIEW / etf_1hour / 2009-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-16.parquet
  size:    129 KB
  rows:    3,946

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
2009-01-16 04:00:00	SPY	ETF	85.2	85.75	85.14	85.75	16419.0
2009-01-16 05:00:00	SPY	ETF	85.6	85.76	85.35	85.35	3900.0
2009-01-16 06:00:00	SPY	ETF	85.25	86.16	85.2	85.99	218100.0
2009-01-16 07:00:00	SPY	ETF	86.0	86.07	85.59	85.84	1287928.0
2009-01-16 08:00:00	SPY	ETF	85.85	86.08	85.0	85.51	4972019.0
2009-01-16 09:00:00	SPY	ETF	85.52	85.9876	85.1	85.25	43850013.0
2009-01-16 10:00:00	SPY	ETF	85.25	85.9	84.89	85.04	49112277.0
2009-01-16 11:00:00	SPY	ETF	85.04	85.1	83.84	84.04	46729444.0
2009-01-16 12:00:00	SPY	ETF	84.04	84.42	83.05	83.84	46542136.0
2009-01-16 13:00:00	SPY	ETF	83.84	84.44	83.47	84.37	42479390.0
2009-01-16 14:00:00	SPY	ETF	84.37	85.3	84.06	84.97	55346426.0
2009-01-16 15:00:00	SPY	ETF	84.97	85.51	84.62	84.98	84361271.0
2009-01-16 16:00:00	SPY	ETF	84.97	85.32	84.7625	85.29	17016975.0
2009-01-16 17:00:00	SPY	ETF	85.3	85.55	85.29	85.43	848984.0
2009-01-16 18:00:00	SPY	ETF	85.43	85.52	85.4	85.46	78646.0
2009-01-16 19:00:00	SPY	ETF	85.46	85.49	85.42	85.42	16875.0
2009-01-16 04:00:00	QQQ	ETF	29.26	29.26	29.26	29.26	200.0
2009-01-16 05:00:00	QQQ	ETF	29.45	29.45	29.39	29.39	200.0
2009-01-16 06:00:00	QQQ	ETF	29.39	29.57	29.35	29.53	86082.0
2009-01-16 07:00:00	QQQ	ETF	29.53	29.55	29.45	29.5	327234.0
2009-01-16 08:00:00	QQQ	ETF	29.51	29.51	29.33	29.43	1826203.0
2009-01-16 09:00:00	QQQ	ETF	29.41	29.6	29.26	29.31	28114691.0
2009-01-16 10:00:00	QQQ	ETF	29.31	29.47	29.16	29.28	21252408.0
2009-01-16 11:00:00	QQQ	ETF	29.28	29.3	28.95	29.0201	20279493.0
2009-01-16 12:00:00	QQQ	ETF	29.0205	29.06	28.7	28.98	21357956.0
2009-01-16 13:00:00	QQQ	ETF	28.98	29.21	28.85	29.16	15731851.0
2009-01-16 14:00:00	QQQ	ETF	29.17	29.3818	29.08	29.38	19019626.0
2009-01-16 15:00:00	QQQ	ETF	29.38	29.56	29.25	29.43	31618448.0
2009-01-16 16:00:00	QQQ	ETF	29.43	29.5365	29.39	29.48	10112164.0
2009-01-16 17:00:00	QQQ	ETF	29.5	29.6	29.48	29.54	164942.0
2009-01-16 18:00:00	QQQ	ETF	29.52	29.54	29.5	29.5	8422.0
2009-01-16 19:00:00	QQQ	ETF	29.52	29.59	29.52	29.53	10370.0
2009-01-16 05:00:00	IWM	ETF	46.5	46.5	46.5	46.5	1000.0
2009-01-16 06:00:00	IWM	ETF	46.5	47.0	46.5	46.97	67996.0
2009-01-16 07:00:00	IWM	ETF	46.91	47.0	46.8	47.0	87637.0
2009-01-16 08:00:00	IWM	ETF	46.842	47.02	46.7	46.78	317685.0
2009-01-16 09:00:00	IWM	ETF	46.78	47.07	46.19	46.42	8099047.0
2009-01-16 10:00:00	IWM	ETF	46.41	46.74	46.16	46.29	10953289.0
2009-01-16 11:00:00	IWM	ETF	46.29	46.37	45.57	45.69	7260713.0
2009-01-16 12:00:00	IWM	ETF	45.69	45.73	44.97	45.47	10762071.0
2009-01-16 13:00:00	IWM	ETF	45.47	45.98	45.22	45.93	8312711.0
2009-01-16 14:00:00	IWM	ETF	45.94	46.23	45.72	46.19	8561935.0
2009-01-16 15:00:00	IWM	ETF	46.19	46.62	45.99	46.48	18080439.0
2009-01-16 16:00:00	IWM	ETF	46.48	46.61	46.0261	46.558	5600178.0
2009-01-16 17:00:00	IWM	ETF	46.52	46.52	46.52	46.52	75100.0
2009-01-16 19:00:00	IWM	ETF	46.63	46.63	46.63	46.63	100.0
2009-01-16 04:00:00	DIA	ETF	83.24	83.24	83.24	83.24	136.0
2009-01-16 06:00:00	DIA	ETF	82.97	83.66	82.97	83.66	1000.0
2009-01-16 07:00:00	DIA	ETF	83.32	83.58	83.25	83.49	13611.0
2009-01-16 08:00:00	DIA	ETF	83.4	83.43	82.9	83.15	251147.0

> showing 50 of 3,946 rows — these rows as CSV

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