PREVIEW / etf_1hour / 2009-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-21.parquet
  size:    142 KB
  rows:    4,404

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-09-21 04:00:00	SPY	ETF	105.92	106.12	105.85	105.85	12420.0
2009-09-21 05:00:00	SPY	ETF	105.85	105.87	105.72	105.75	9242.0
2009-09-21 06:00:00	SPY	ETF	105.82	105.95	105.74	105.91	29400.0
2009-09-21 07:00:00	SPY	ETF	105.9	106.05	105.84	105.88	480682.0
2009-09-21 08:00:00	SPY	ETF	105.9	106.85	105.63	105.87	2710691.0
2009-09-21 09:00:00	SPY	ETF	105.87	106.25	105.67	105.82	21127589.0
2009-09-21 10:00:00	SPY	ETF	105.8299	107.0	105.66	106.0475	24656487.0
2009-09-21 11:00:00	SPY	ETF	106.04	106.61	106.01	106.4683	18340635.0
2009-09-21 12:00:00	SPY	ETF	106.4601	106.54	106.25	106.31	7913097.0
2009-09-21 13:00:00	SPY	ETF	106.31	106.47	106.18	106.41	15624404.0
2009-09-21 14:00:00	SPY	ETF	106.41	106.54	106.27	106.4101	11278106.0
2009-09-21 15:00:00	SPY	ETF	106.42	106.72	106.19	106.45	26461697.0
2009-09-21 16:00:00	SPY	ETF	106.45	106.8018	106.3	106.43	14859065.0
2009-09-21 17:00:00	SPY	ETF	106.41	106.8018	106.4	106.47	6036396.0
2009-09-21 18:00:00	SPY	ETF	106.44	106.45	106.4	106.44	25217.0
2009-09-21 19:00:00	SPY	ETF	106.46	106.61	106.41	106.58	86961.0
2009-09-21 04:00:00	QQQ	ETF	42.13	42.19	42.13	42.19	3788.0
2009-09-21 05:00:00	QQQ	ETF	42.12	42.15	42.06	42.06	72500.0
2009-09-21 06:00:00	QQQ	ETF	42.14	42.14	42.09	42.13	3700.0
2009-09-21 07:00:00	QQQ	ETF	42.14	42.21	42.14	42.17	132288.0
2009-09-21 08:00:00	QQQ	ETF	42.18	42.35	42.08	42.22	2943055.0
2009-09-21 09:00:00	QQQ	ETF	42.21	42.4	42.15	42.2201	11142342.0
2009-09-21 10:00:00	QQQ	ETF	42.23	42.42	42.16	42.39	13321955.0
2009-09-21 11:00:00	QQQ	ETF	42.39	42.69	42.37	42.622	10778731.0
2009-09-21 12:00:00	QQQ	ETF	42.63	42.64	42.52	42.55	4727818.0
2009-09-21 13:00:00	QQQ	ETF	42.55	42.6	42.49	42.588	3122951.0
2009-09-21 14:00:00	QQQ	ETF	42.59	42.63	42.49	42.588	5086087.0
2009-09-21 15:00:00	QQQ	ETF	42.589	42.7	42.51	42.58	13633687.0
2009-09-21 16:00:00	QQQ	ETF	42.57	42.59	42.51	42.52	4800205.0
2009-09-21 17:00:00	QQQ	ETF	42.51	42.55	42.51	42.55	7611.0
2009-09-21 18:00:00	QQQ	ETF	42.54	42.56	42.53	42.56	53380.0
2009-09-21 19:00:00	QQQ	ETF	42.54	42.62	42.54	42.62	36361.0
2009-09-21 06:00:00	IWM	ETF	61.2	61.2	61.17	61.17	266.0
2009-09-21 07:00:00	IWM	ETF	61.33	61.41	61.26	61.31	129413.0
2009-09-21 08:00:00	IWM	ETF	61.32	61.37	61.1	61.24	521753.0
2009-09-21 09:00:00	IWM	ETF	61.24	61.72	61.18	61.32	7540568.0
2009-09-21 10:00:00	IWM	ETF	61.32	61.53	61.09	61.5	7193062.0
2009-09-21 11:00:00	IWM	ETF	61.49	61.86	61.43	61.73	3602125.0
2009-09-21 12:00:00	IWM	ETF	61.72	61.7599	61.56	61.582	2036971.0
2009-09-21 13:00:00	IWM	ETF	61.58	61.71	61.48	61.7	2198834.0
2009-09-21 14:00:00	IWM	ETF	61.69	61.81	61.57	61.74	2662426.0
2009-09-21 15:00:00	IWM	ETF	61.74	61.96	61.59	61.73	6154042.0
2009-09-21 16:00:00	IWM	ETF	61.73	61.8988	61.41	61.67	5123067.0
2009-09-21 17:00:00	IWM	ETF	61.7	61.7	61.66	61.7	1669.0
2009-09-21 19:00:00	IWM	ETF	61.68	61.68	61.68	61.68	300.0
2009-09-21 07:00:00	DIA	ETF	97.51	97.57	97.48	97.51	1500.0
2009-09-21 08:00:00	DIA	ETF	97.48	97.55	97.32	97.47	73549.0
2009-09-21 09:00:00	DIA	ETF	97.45	97.71	97.27	97.33	1481219.0
2009-09-21 10:00:00	DIA	ETF	97.346	97.63	97.23	97.5	1870481.0
2009-09-21 11:00:00	DIA	ETF	97.5	98.0	97.47	97.92	908945.0

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

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