PREVIEW / etf_1hour / 2009-09-18

all etf 1-hour files

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

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-18 04:00:00	SPY	ETF	106.36	106.4	106.26	106.38	5900.0
2009-09-18 05:00:00	SPY	ETF	106.53	106.78	106.39	106.72	10900.0
2009-09-18 06:00:00	SPY	ETF	106.76	106.86	106.68	106.86	30900.0
2009-09-18 07:00:00	SPY	ETF	106.92	106.92	106.8	106.83	213698.0
2009-09-18 08:00:00	SPY	ETF	106.83	107.04	106.73	107.04	1669742.0
2009-09-18 09:00:00	SPY	ETF	107.04	107.19	106.66	106.738	24015314.0
2009-09-18 10:00:00	SPY	ETF	106.74	106.9	106.46	106.76	31562716.0
2009-09-18 11:00:00	SPY	ETF	106.76	106.82	106.5	106.5	19910176.0
2009-09-18 12:00:00	SPY	ETF	106.49	106.89	106.36	106.87	17833396.0
2009-09-18 13:00:00	SPY	ETF	106.87	107.1	106.59	106.999	11599519.0
2009-09-18 14:00:00	SPY	ETF	107.0	107.1	106.84	106.88	10909425.0
2009-09-18 15:00:00	SPY	ETF	106.88	107.15	106.71	106.73	24536429.0
2009-09-18 16:00:00	SPY	ETF	106.73	107.0	106.46	106.6	10885921.0
2009-09-18 17:00:00	SPY	ETF	106.6	106.62	106.46	106.53	185863.0
2009-09-18 18:00:00	SPY	ETF	106.53	106.54	106.48	106.5	18627.0
2009-09-18 19:00:00	SPY	ETF	106.52	106.6	106.49	106.55	7884.0
2009-09-18 04:00:00	QQQ	ETF	42.2	42.2	42.2	42.2	200.0
2009-09-18 06:00:00	QQQ	ETF	42.35	42.42	42.35	42.42	2700.0
2009-09-18 07:00:00	QQQ	ETF	42.42	42.42	42.4	42.41	24013.0
2009-09-18 08:00:00	QQQ	ETF	42.41	42.49	42.38	42.49	500631.0
2009-09-18 09:00:00	QQQ	ETF	42.5	42.59	42.37	42.448	15622569.0
2009-09-18 10:00:00	QQQ	ETF	42.44	42.47	42.21	42.44	13842879.0
2009-09-18 11:00:00	QQQ	ETF	42.45	42.49	42.36	42.36	12991024.0
2009-09-18 12:00:00	QQQ	ETF	42.3699	42.51	42.31	42.501	9167512.0
2009-09-18 13:00:00	QQQ	ETF	42.51	42.62	42.47	42.58	6161526.0
2009-09-18 14:00:00	QQQ	ETF	42.58	42.61	42.46	42.47	6594814.0
2009-09-18 15:00:00	QQQ	ETF	42.47	42.55	42.41	42.44	14616250.0
2009-09-18 16:00:00	QQQ	ETF	42.44	42.547	42.26	42.42	5987304.0
2009-09-18 17:00:00	QQQ	ETF	42.41	42.42	42.38	42.4	26010.0
2009-09-18 18:00:00	QQQ	ETF	42.38	42.4	42.38	42.39	1750.0
2009-09-18 19:00:00	QQQ	ETF	42.4	42.4	42.39	42.4	7130.0
2009-09-18 06:00:00	IWM	ETF	61.85	61.85	61.85	61.85	1000.0
2009-09-18 07:00:00	IWM	ETF	61.86	61.94	61.86	61.92	6500.0
2009-09-18 08:00:00	IWM	ETF	61.96	62.09	61.87	62.07	202913.0
2009-09-18 09:00:00	IWM	ETF	62.07	62.11	61.49	61.53	5873661.0
2009-09-18 10:00:00	IWM	ETF	61.52	61.64	61.26	61.56	6873661.0
2009-09-18 11:00:00	IWM	ETF	61.55	61.63	61.42	61.5	5314035.0
2009-09-18 12:00:00	IWM	ETF	61.5	61.86	61.39	61.85	4039580.0
2009-09-18 13:00:00	IWM	ETF	61.85	61.97	61.79	61.9	2544423.0
2009-09-18 14:00:00	IWM	ETF	61.9	62.01	61.85	61.93	2022584.0
2009-09-18 15:00:00	IWM	ETF	61.93	62.07	61.82	61.88	6837788.0
2009-09-18 16:00:00	IWM	ETF	61.88	61.92	61.72	61.77	1193442.0
2009-09-18 17:00:00	IWM	ETF	61.77	61.78	61.72	61.78	14871.0
2009-09-18 18:00:00	IWM	ETF	61.78	61.78	61.78	61.78	800.0
2009-09-18 07:00:00	DIA	ETF	98.02	98.06	98.02	98.06	1600.0
2009-09-18 08:00:00	DIA	ETF	98.06	98.25	98.0	98.25	29793.0
2009-09-18 09:00:00	DIA	ETF	98.25	98.44	98.03	98.1099	1569269.0
2009-09-18 10:00:00	DIA	ETF	98.102	98.33	97.94	98.21	2025022.0
2009-09-18 11:00:00	DIA	ETF	98.2199	98.28	98.01	98.01	2021012.0
2009-09-18 12:00:00	DIA	ETF	98.01	98.3	97.92	98.29	1239493.0

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

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