PREVIEW / etf_1hour / 2009-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-26.parquet
  size:    136 KB
  rows:    4,228

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-05-26 04:00:00	SPY	ETF	88.69	88.78	88.61	88.66	1150.0
2009-05-26 05:00:00	SPY	ETF	88.61	88.68	88.49	88.68	2292.0
2009-05-26 06:00:00	SPY	ETF	88.7	88.7	88.2	88.39	66273.0
2009-05-26 07:00:00	SPY	ETF	88.35	88.73	88.23	88.59	1105226.0
2009-05-26 08:00:00	SPY	ETF	88.4	89.15	88.4	88.7	4410692.0
2009-05-26 09:00:00	SPY	ETF	88.69	89.39	88.31	89.39	25481087.0
2009-05-26 10:00:00	SPY	ETF	89.37	90.88	89.28	90.7018	65691450.0
2009-05-26 11:00:00	SPY	ETF	90.71	91.0	90.58	90.89	20201988.0
2009-05-26 12:00:00	SPY	ETF	90.89	91.38	90.75	91.26	17967737.0
2009-05-26 13:00:00	SPY	ETF	91.27	91.42	91.13	91.372	17462582.0
2009-05-26 14:00:00	SPY	ETF	91.38	91.56	91.11	91.1199	24811673.0
2009-05-26 15:00:00	SPY	ETF	91.12	91.4	90.79	91.32	49514519.0
2009-05-26 16:00:00	SPY	ETF	91.32	91.47	88.75	91.35	7530160.0
2009-05-26 17:00:00	SPY	ETF	91.33	91.44	89.0322	91.35	1259088.0
2009-05-26 18:00:00	SPY	ETF	91.35	91.35	91.28	91.32	29708.0
2009-05-26 19:00:00	SPY	ETF	91.3	91.43	91.3	91.31	118302.0
2009-05-26 04:00:00	QQQ	ETF	33.28	33.28	33.25	33.25	400.0
2009-05-26 05:00:00	QQQ	ETF	33.23	33.23	33.23	33.23	200.0
2009-05-26 06:00:00	QQQ	ETF	33.21	33.21	33.1	33.1	2051.0
2009-05-26 07:00:00	QQQ	ETF	33.1	33.31	33.1	33.31	772880.0
2009-05-26 08:00:00	QQQ	ETF	33.3	33.47	33.2	33.4	2870372.0
2009-05-26 09:00:00	QQQ	ETF	33.38	33.98	33.18	33.97	22298678.0
2009-05-26 10:00:00	QQQ	ETF	33.97	34.62	33.97	34.53	39628514.0
2009-05-26 11:00:00	QQQ	ETF	34.53	34.7	34.47	34.66	11129138.0
2009-05-26 12:00:00	QQQ	ETF	34.66	34.76	34.59	34.712	6960920.0
2009-05-26 13:00:00	QQQ	ETF	34.71	34.82	34.68	34.8	8336724.0
2009-05-26 14:00:00	QQQ	ETF	34.79	34.83	34.65	34.65	11587455.0
2009-05-26 15:00:00	QQQ	ETF	34.65	34.8	34.57	34.789	25949483.0
2009-05-26 16:00:00	QQQ	ETF	34.78	34.82	33.5591	34.75	10037631.0
2009-05-26 17:00:00	QQQ	ETF	34.75	34.82	34.75	34.8	64440.0
2009-05-26 18:00:00	QQQ	ETF	34.78	34.78	34.74	34.78	42200.0
2009-05-26 19:00:00	QQQ	ETF	34.78	34.82	34.76	34.78	83899.0
2009-05-26 05:00:00	IWM	ETF	47.43	47.43	47.43	47.43	445.0
2009-05-26 06:00:00	IWM	ETF	47.17	47.17	47.17	47.17	297.0
2009-05-26 07:00:00	IWM	ETF	47.14	47.52	47.14	47.5	221700.0
2009-05-26 08:00:00	IWM	ETF	47.52	47.95	47.38	47.45	2017391.0
2009-05-26 09:00:00	IWM	ETF	47.45	48.33	47.26	48.29	9308416.0
2009-05-26 10:00:00	IWM	ETF	48.3	49.52	48.29	49.39	13926778.0
2009-05-26 11:00:00	IWM	ETF	49.39	49.83	49.1	49.79	6793941.0
2009-05-26 12:00:00	IWM	ETF	49.79	50.03	49.66	50.0	4528128.0
2009-05-26 13:00:00	IWM	ETF	50.0	50.07	49.86	49.96	4828703.0
2009-05-26 14:00:00	IWM	ETF	49.97	50.16	49.72	49.73	5931484.0
2009-05-26 15:00:00	IWM	ETF	49.72	50.09	49.6575	50.05	11531339.0
2009-05-26 16:00:00	IWM	ETF	50.05	50.1202	47.8277	50.0	4186740.0
2009-05-26 17:00:00	IWM	ETF	50.0	50.03	50.0	50.03	1800.0
2009-05-26 04:00:00	DIA	ETF	82.46	82.46	82.46	82.46	100.0
2009-05-26 07:00:00	DIA	ETF	82.4	82.53	82.4	82.5	402.0
2009-05-26 08:00:00	DIA	ETF	82.55	82.8	82.53	82.68	43450.0
2009-05-26 09:00:00	DIA	ETF	82.58	83.08	82.27	83.06	1424953.0
2009-05-26 10:00:00	DIA	ETF	83.06	84.6	83.05	84.44	3830026.0

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

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