PREVIEW / etf_1hour / 2009-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-26.parquet
  size:    125 KB
  rows:    3,831

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-26 04:00:00	SPY	ETF	82.86	82.86	82.55	82.56	3370.0
2009-01-26 05:00:00	SPY	ETF	82.91	83.29	82.91	83.17	1800.0
2009-01-26 06:00:00	SPY	ETF	83.02	83.28	83.0	83.23	80400.0
2009-01-26 07:00:00	SPY	ETF	83.28	83.39	82.55	82.91	1969958.0
2009-01-26 08:00:00	SPY	ETF	82.91	83.69	82.6	83.41	3470590.0
2009-01-26 09:00:00	SPY	ETF	83.41	84.61	82.1	84.33	35476862.0
2009-01-26 10:00:00	SPY	ETF	84.33	85.36	84.32	84.92	47971657.0
2009-01-26 11:00:00	SPY	ETF	84.93	85.25	84.26	84.52	31246857.0
2009-01-26 12:00:00	SPY	ETF	84.52	84.87	84.31	84.51	32949570.0
2009-01-26 13:00:00	SPY	ETF	84.52	84.74	83.5	83.67	39137859.0
2009-01-26 14:00:00	SPY	ETF	83.67	83.85	82.81	83.76	53571019.0
2009-01-26 15:00:00	SPY	ETF	83.74	84.45	83.38	83.7	60535626.0
2009-01-26 16:00:00	SPY	ETF	83.67	84.448	83.46	83.84	4769000.0
2009-01-26 17:00:00	SPY	ETF	83.84	84.7112	83.69	83.75	1675549.0
2009-01-26 18:00:00	SPY	ETF	83.75	84.04	83.74	83.93	212398.0
2009-01-26 19:00:00	SPY	ETF	83.93	84.03	83.87	83.99	103769.0
2009-01-26 04:00:00	QQQ	ETF	28.66	28.66	28.6	28.6	1000.0
2009-01-26 05:00:00	QQQ	ETF	28.69	28.77	28.69	28.77	1000.0
2009-01-26 06:00:00	QQQ	ETF	28.82	28.88	28.82	28.88	900.0
2009-01-26 07:00:00	QQQ	ETF	28.84	28.9	28.69	28.88	580774.0
2009-01-26 08:00:00	QQQ	ETF	28.9	28.99	28.8	28.93	612938.0
2009-01-26 09:00:00	QQQ	ETF	28.92	29.26	28.85	29.17	16670658.0
2009-01-26 10:00:00	QQQ	ETF	29.1799	29.59	29.17	29.43	18828601.0
2009-01-26 11:00:00	QQQ	ETF	29.43	29.5	29.22	29.3	10316003.0
2009-01-26 12:00:00	QQQ	ETF	29.31	29.44	29.26	29.35	13209205.0
2009-01-26 13:00:00	QQQ	ETF	29.34	29.4	29.02	29.09	15915300.0
2009-01-26 14:00:00	QQQ	ETF	29.09	29.11	28.75	29.09	23193478.0
2009-01-26 15:00:00	QQQ	ETF	29.09	29.32	28.96	29.11	24798151.0
2009-01-26 16:00:00	QQQ	ETF	29.11	29.17	28.9219	29.16	4594502.0
2009-01-26 17:00:00	QQQ	ETF	29.15	29.17	29.11	29.11	34627.0
2009-01-26 18:00:00	QQQ	ETF	29.12	29.21	29.12	29.17	56984.0
2009-01-26 19:00:00	QQQ	ETF	29.18	29.21	29.16	29.21	26980.0
2009-01-26 07:00:00	IWM	ETF	44.33	44.33	43.96	44.02	8400.0
2009-01-26 08:00:00	IWM	ETF	43.99	44.55	43.98	44.41	1470386.0
2009-01-26 09:00:00	IWM	ETF	44.39	45.45	44.27	45.03	8140014.0
2009-01-26 10:00:00	IWM	ETF	45.04	45.87	45.04	45.6	7391895.0
2009-01-26 11:00:00	IWM	ETF	45.59	45.76	45.1	45.22	3658687.0
2009-01-26 12:00:00	IWM	ETF	45.22	45.46	45.07	45.3	6332460.0
2009-01-26 13:00:00	IWM	ETF	45.29	45.39	44.6302	44.77	6714249.0
2009-01-26 14:00:00	IWM	ETF	44.77	44.86	44.18	44.79	9771019.0
2009-01-26 15:00:00	IWM	ETF	44.79	45.4	44.7	44.94	12699183.0
2009-01-26 16:00:00	IWM	ETF	44.94	44.96	44.67	44.88	1360781.0
2009-01-26 17:00:00	IWM	ETF	44.93	44.96	44.85	44.96	31780.0
2009-01-26 18:00:00	IWM	ETF	44.85	44.9	44.85	44.9	4800.0
2009-01-26 19:00:00	IWM	ETF	44.87	44.87	44.87	44.87	1000.0
2009-01-26 06:00:00	DIA	ETF	80.59	80.59	80.59	80.59	200.0
2009-01-26 07:00:00	DIA	ETF	80.66	80.7	80.04	80.25	10503.0
2009-01-26 08:00:00	DIA	ETF	80.26	80.79	80.2	80.63	92752.0
2009-01-26 09:00:00	DIA	ETF	80.59	81.43	80.54	81.29	3788441.0
2009-01-26 10:00:00	DIA	ETF	81.28	82.29	81.27	81.97	4338013.0

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

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