PREVIEW / etf_1hour / 2009-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-27.parquet
  size:    141 KB
  rows:    4,290

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-27 04:00:00	SPY	ETF	103.3	103.33	103.25	103.25	1100.0
2009-08-27 05:00:00	SPY	ETF	103.2	103.25	103.2	103.25	5300.0
2009-08-27 06:00:00	SPY	ETF	103.22	103.22	102.92	102.98	6500.0
2009-08-27 07:00:00	SPY	ETF	102.99	103.21	102.96	103.12	606723.0
2009-08-27 08:00:00	SPY	ETF	103.12	103.55	102.99	103.22	6069363.0
2009-08-27 09:00:00	SPY	ETF	103.21	103.27	102.24	102.25	27287651.0
2009-08-27 10:00:00	SPY	ETF	102.24	102.34	101.94	102.08	36891790.0
2009-08-27 11:00:00	SPY	ETF	102.075	102.59	102.0	102.57	14796431.0
2009-08-27 12:00:00	SPY	ETF	102.57	102.91	102.53	102.81	16866431.0
2009-08-27 13:00:00	SPY	ETF	102.8	103.21	102.62	103.09	20500470.0
2009-08-27 14:00:00	SPY	ETF	103.085	103.72	103.085	103.53	26504420.0
2009-08-27 15:00:00	SPY	ETF	103.53	103.61	103.31	103.45	32929978.0
2009-08-27 16:00:00	SPY	ETF	103.45	103.713	102.06	103.44	7729189.0
2009-08-27 17:00:00	SPY	ETF	103.44	103.51	103.1716	103.5	2305737.0
2009-08-27 18:00:00	SPY	ETF	103.45	103.5	103.42	103.45	122207.0
2009-08-27 19:00:00	SPY	ETF	103.43	103.48	103.35	103.45	188568.0
2009-08-27 05:00:00	QQQ	ETF	40.31	40.31	40.31	40.31	5000.0
2009-08-27 06:00:00	QQQ	ETF	40.19	40.2	40.19	40.2	5000.0
2009-08-27 07:00:00	QQQ	ETF	40.21	40.32	40.21	40.3	19800.0
2009-08-27 08:00:00	QQQ	ETF	40.3	40.42	40.26	40.32	398964.0
2009-08-27 09:00:00	QQQ	ETF	40.33	40.34	39.85	39.86	10942998.0
2009-08-27 10:00:00	QQQ	ETF	39.86	39.88	39.67	39.77	22043739.0
2009-08-27 11:00:00	QQQ	ETF	39.76	39.95	39.72	39.94	7410573.0
2009-08-27 12:00:00	QQQ	ETF	39.94	40.06	39.93	40.01	10465483.0
2009-08-27 13:00:00	QQQ	ETF	40.01	40.27	39.93	40.23	10080684.0
2009-08-27 14:00:00	QQQ	ETF	40.24	40.47	40.23	40.34	17754019.0
2009-08-27 15:00:00	QQQ	ETF	40.34	40.45	40.26	40.4	24039878.0
2009-08-27 16:00:00	QQQ	ETF	40.4	40.4667	39.79	40.3025	7820355.0
2009-08-27 17:00:00	QQQ	ETF	40.3025	40.43	40.3025	40.43	1363284.0
2009-08-27 18:00:00	QQQ	ETF	40.41	40.41	40.37	40.39	26145.0
2009-08-27 19:00:00	QQQ	ETF	40.37	40.42	40.37	40.42	96549.0
2009-08-27 07:00:00	IWM	ETF	58.3	58.44	58.3	58.4	13400.0
2009-08-27 08:00:00	IWM	ETF	58.43	58.64	58.33	58.45	489366.0
2009-08-27 09:00:00	IWM	ETF	58.46	58.51	57.56	57.57	5739714.0
2009-08-27 10:00:00	IWM	ETF	57.55	57.59	57.23	57.321	6856843.0
2009-08-27 11:00:00	IWM	ETF	57.32	57.7901	57.27	57.78	3550720.0
2009-08-27 12:00:00	IWM	ETF	57.77	58.02	57.699	57.85	5010869.0
2009-08-27 13:00:00	IWM	ETF	57.84	58.24	57.67	58.1503	4408727.0
2009-08-27 14:00:00	IWM	ETF	58.16	58.6	58.155	58.43	5226882.0
2009-08-27 15:00:00	IWM	ETF	58.43	58.49	58.24	58.43	7660380.0
2009-08-27 16:00:00	IWM	ETF	58.43	58.47	58.3	58.39	3466227.0
2009-08-27 17:00:00	IWM	ETF	58.4	58.43	58.37	58.43	4130.0
2009-08-27 18:00:00	IWM	ETF	58.44	58.59	58.32	58.44	26972.0
2009-08-27 19:00:00	IWM	ETF	58.43	58.44	58.38	58.39	943.0
2009-08-27 08:00:00	DIA	ETF	95.45	95.75	95.35	95.55	169351.0
2009-08-27 09:00:00	DIA	ETF	95.62	95.62	94.9	94.91	2700729.0
2009-08-27 10:00:00	DIA	ETF	94.91	94.94	94.602	94.71	2530681.0
2009-08-27 11:00:00	DIA	ETF	94.71	95.29	94.64	95.27	1043325.0
2009-08-27 12:00:00	DIA	ETF	95.28	95.56	95.24	95.48	1284858.0
2009-08-27 13:00:00	DIA	ETF	95.47	95.76	95.3201	95.63	1380264.0

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

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