PREVIEW / etf_1hour / 2009-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-25.parquet
  size:    132 KB
  rows:    4,059

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-03-25 04:00:00	SPY	ETF	81.0	81.24	81.0	81.2	1200.0
2009-03-25 05:00:00	SPY	ETF	81.29	81.33	81.08	81.08	4750.0
2009-03-25 06:00:00	SPY	ETF	81.11	81.11	80.92	80.96	30950.0
2009-03-25 07:00:00	SPY	ETF	80.93	80.97	80.66	80.93	383981.0
2009-03-25 08:00:00	SPY	ETF	80.93	81.28	80.5959	81.02	7972633.0
2009-03-25 09:00:00	SPY	ETF	81.01	81.94	80.98	81.81	39162437.0
2009-03-25 10:00:00	SPY	ETF	81.81	82.7	81.81	82.06	78036511.0
2009-03-25 11:00:00	SPY	ETF	82.0625	82.44	81.85	82.1194	37715690.0
2009-03-25 12:00:00	SPY	ETF	82.12	82.51	81.55	81.73	33457976.0
2009-03-25 13:00:00	SPY	ETF	81.73	81.91	80.59	80.7575	53209722.0
2009-03-25 14:00:00	SPY	ETF	80.75	80.78	79.18	79.33	75343695.0
2009-03-25 15:00:00	SPY	ETF	79.33	82.47	79.06	81.34	98981008.0
2009-03-25 16:00:00	SPY	ETF	81.35	82.7	80.48	81.45	11124308.0
2009-03-25 17:00:00	SPY	ETF	81.45	81.66	81.4	81.59	2959125.0
2009-03-25 18:00:00	SPY	ETF	81.55	81.58	81.47	81.58	56428.0
2009-03-25 19:00:00	SPY	ETF	81.56	81.6	81.45	81.5	204740.0
2009-03-25 05:00:00	QQQ	ETF	30.53	30.53	30.53	30.53	100.0
2009-03-25 06:00:00	QQQ	ETF	30.51	30.54	30.51	30.52	400.0
2009-03-25 07:00:00	QQQ	ETF	30.45	30.52	30.41	30.45	353119.0
2009-03-25 08:00:00	QQQ	ETF	30.45	30.6	30.4	30.54	2116595.0
2009-03-25 09:00:00	QQQ	ETF	30.54	30.8388	30.52	30.81	21670807.0
2009-03-25 10:00:00	QQQ	ETF	30.81	31.05	30.78	30.8105	31532744.0
2009-03-25 11:00:00	QQQ	ETF	30.8171	30.93	30.67	30.75	14380747.0
2009-03-25 12:00:00	QQQ	ETF	30.75	30.87	30.46	30.55	14508621.0
2009-03-25 13:00:00	QQQ	ETF	30.55	30.61	30.1	30.18	23995146.0
2009-03-25 14:00:00	QQQ	ETF	30.19	30.19	29.69	29.75	29658048.0
2009-03-25 15:00:00	QQQ	ETF	29.75	30.49	29.66	30.47	33180146.0
2009-03-25 16:00:00	QQQ	ETF	30.46	30.48	30.1889	30.44	10224401.0
2009-03-25 17:00:00	QQQ	ETF	30.45	30.54	30.4108	30.45	2127051.0
2009-03-25 18:00:00	QQQ	ETF	30.49	30.52	30.46	30.52	35238.0
2009-03-25 19:00:00	QQQ	ETF	30.51	30.52	30.46	30.5	30571.0
2009-03-25 06:00:00	IWM	ETF	41.75	41.75	41.75	41.75	100.0
2009-03-25 07:00:00	IWM	ETF	41.63	41.81	41.63	41.81	60687.0
2009-03-25 08:00:00	IWM	ETF	42.03	42.12	41.7	41.94	738863.0
2009-03-25 09:00:00	IWM	ETF	41.93	42.69	41.91	42.65	8839548.0
2009-03-25 10:00:00	IWM	ETF	42.65	43.28	42.65	42.91	16906247.0
2009-03-25 11:00:00	IWM	ETF	42.92	43.16	42.76	42.98	7261425.0
2009-03-25 12:00:00	IWM	ETF	42.98	43.22	42.69	42.8	6221136.0
2009-03-25 13:00:00	IWM	ETF	42.79	42.9	41.92	42.078	9161967.0
2009-03-25 14:00:00	IWM	ETF	42.07	42.07	40.81	40.97	17800154.0
2009-03-25 15:00:00	IWM	ETF	40.98	42.71	40.83	42.7	22803540.0
2009-03-25 16:00:00	IWM	ETF	42.7	42.81	41.6257	42.68	5128985.0
2009-03-25 17:00:00	IWM	ETF	42.75	42.8	42.75	42.75	53227.0
2009-03-25 18:00:00	IWM	ETF	42.75	42.75	42.75	42.75	500.0
2009-03-25 06:00:00	DIA	ETF	77.08	77.09	76.91	76.94	4231.0
2009-03-25 07:00:00	DIA	ETF	76.92	76.93	76.8	76.92	6077.0
2009-03-25 08:00:00	DIA	ETF	76.92	77.17	76.77	77.07	138375.0
2009-03-25 09:00:00	DIA	ETF	77.04	77.87	77.02	77.75	2761434.0
2009-03-25 10:00:00	DIA	ETF	77.77	78.62	77.77	78.158	5454244.0
2009-03-25 11:00:00	DIA	ETF	78.1594	78.489	77.99	78.18	2640709.0

> showing 50 of 4,059 rows — these rows as CSV

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