PREVIEW / etf_1hour / 2009-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-28.parquet
  size:    139 KB
  rows:    4,260

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-08-28 04:00:00	SPY	ETF	103.51	103.76	103.51	103.76	3491.0
2009-08-28 05:00:00	SPY	ETF	103.78	103.82	103.77	103.77	7947.0
2009-08-28 06:00:00	SPY	ETF	103.79	103.92	103.78	103.92	1400.0
2009-08-28 07:00:00	SPY	ETF	103.9	104.07	103.82	103.84	773031.0
2009-08-28 08:00:00	SPY	ETF	103.83	104.0	103.68	103.75	2295359.0
2009-08-28 09:00:00	SPY	ETF	103.76	104.35	103.49	103.52	29798092.0
2009-08-28 10:00:00	SPY	ETF	103.52	103.76	103.14	103.49	28302648.0
2009-08-28 11:00:00	SPY	ETF	103.49	103.56	103.08	103.17	12259117.0
2009-08-28 12:00:00	SPY	ETF	103.18	103.29	102.67	102.8	15832017.0
2009-08-28 13:00:00	SPY	ETF	102.8	103.22	102.79	103.09	10944350.0
2009-08-28 14:00:00	SPY	ETF	103.09	103.35	102.99	103.255	12953452.0
2009-08-28 15:00:00	SPY	ETF	103.25	103.45	103.01	103.33	22343097.0
2009-08-28 16:00:00	SPY	ETF	103.34	103.4	103.05	103.1	7272315.0
2009-08-28 17:00:00	SPY	ETF	103.1	103.4713	103.06	103.08	1046198.0
2009-08-28 18:00:00	SPY	ETF	103.1	103.33	103.06	103.08	22333.0
2009-08-28 19:00:00	SPY	ETF	103.1	103.15	103.09	103.11	33493.0
2009-08-28 06:00:00	QQQ	ETF	40.56	40.56	40.51	40.56	6291.0
2009-08-28 07:00:00	QQQ	ETF	40.55	40.6	40.51	40.54	126771.0
2009-08-28 08:00:00	QQQ	ETF	40.53	40.62	40.4	40.57	4748568.0
2009-08-28 09:00:00	QQQ	ETF	40.58	41.08	40.57	40.66	29455141.0
2009-08-28 10:00:00	QQQ	ETF	40.66	40.78	40.42	40.61	17938334.0
2009-08-28 11:00:00	QQQ	ETF	40.608	40.62	40.42	40.47	7678524.0
2009-08-28 12:00:00	QQQ	ETF	40.47	40.51	40.16	40.17	11705843.0
2009-08-28 13:00:00	QQQ	ETF	40.18	40.41	40.17	40.34	6857256.0
2009-08-28 14:00:00	QQQ	ETF	40.34	40.5	40.3	40.48	6400370.0
2009-08-28 15:00:00	QQQ	ETF	40.47	40.6	40.33	40.44	13066266.0
2009-08-28 16:00:00	QQQ	ETF	40.44	40.91	40.26	40.4	11379230.0
2009-08-28 17:00:00	QQQ	ETF	40.41	40.43	40.41	40.41	14515.0
2009-08-28 18:00:00	QQQ	ETF	40.43	40.45	40.4	40.41	15654.0
2009-08-28 19:00:00	QQQ	ETF	40.42	40.42	40.39	40.39	6445.0
2009-08-28 06:00:00	IWM	ETF	58.62	58.62	58.62	58.62	100.0
2009-08-28 07:00:00	IWM	ETF	58.68	58.75	58.63	58.64	7433.0
2009-08-28 08:00:00	IWM	ETF	58.64	58.72	58.56	58.61	233587.0
2009-08-28 09:00:00	IWM	ETF	58.61	59.18	58.35	58.38	7035037.0
2009-08-28 10:00:00	IWM	ETF	58.38	58.55	58.04	58.26	7005005.0
2009-08-28 11:00:00	IWM	ETF	58.25	58.29	57.93	58.0	3293491.0
2009-08-28 12:00:00	IWM	ETF	58.0	58.1	57.66	57.73	4184701.0
2009-08-28 13:00:00	IWM	ETF	57.74	58.05	57.73	57.9	2736588.0
2009-08-28 14:00:00	IWM	ETF	57.89	58.13	57.78	58.09	3386128.0
2009-08-28 15:00:00	IWM	ETF	58.0999	58.27	57.88	58.05	5841619.0
2009-08-28 16:00:00	IWM	ETF	58.06	58.11	57.9004	57.97	3920497.0
2009-08-28 17:00:00	IWM	ETF	57.96	58.0	57.95	57.95	1050.0
2009-08-28 18:00:00	IWM	ETF	57.96	57.96	57.93	57.93	1000.0
2009-08-28 19:00:00	IWM	ETF	57.92	57.93	57.92	57.92	1100.0
2009-08-28 07:00:00	DIA	ETF	96.16	96.26	96.14	96.14	1575.0
2009-08-28 08:00:00	DIA	ETF	96.09	96.2	96.0	96.0	26150.0
2009-08-28 09:00:00	DIA	ETF	96.01	96.5	95.671	95.69	1704527.0
2009-08-28 10:00:00	DIA	ETF	95.68	95.91	95.39	95.69	2554388.0
2009-08-28 11:00:00	DIA	ETF	95.67	95.72	95.37	95.4413	1385411.0
2009-08-28 12:00:00	DIA	ETF	95.46	95.54	95.01	95.15	1926504.0

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

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