PREVIEW / etf_1hour / 2009-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-28.parquet
  size:    130 KB
  rows:    3,978

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-01-28 04:00:00	SPY	ETF	86.1	86.21	86.07	86.1	20164.0
2009-01-28 05:00:00	SPY	ETF	86.17	86.34	86.02	86.02	21900.0
2009-01-28 06:00:00	SPY	ETF	86.09	86.38	86.05	86.38	130733.0
2009-01-28 07:00:00	SPY	ETF	86.28	86.5	85.95	86.5	1528877.0
2009-01-28 08:00:00	SPY	ETF	86.5	86.78	86.0	86.49	5193392.0
2009-01-28 09:00:00	SPY	ETF	86.5	86.7	86.07	86.12	35466142.0
2009-01-28 10:00:00	SPY	ETF	86.12	86.8525	86.07	86.72	37897862.0
2009-01-28 11:00:00	SPY	ETF	86.72	86.97	86.46	86.62	35654203.0
2009-01-28 12:00:00	SPY	ETF	86.62	86.9	86.58	86.761	14872601.0
2009-01-28 13:00:00	SPY	ETF	86.76	87.59	86.65	87.25	29668929.0
2009-01-28 14:00:00	SPY	ETF	87.255	87.95	86.98	87.58	73505408.0
2009-01-28 15:00:00	SPY	ETF	87.58	87.73	86.53	87.43	82210735.0
2009-01-28 16:00:00	SPY	ETF	87.42	87.64	86.7	87.46	12121052.0
2009-01-28 17:00:00	SPY	ETF	87.45	87.54	87.38	87.42	201173.0
2009-01-28 18:00:00	SPY	ETF	87.43	87.52	87.3	87.35	178462.0
2009-01-28 19:00:00	SPY	ETF	87.34	87.34	87.16	87.26	143862.0
2009-01-28 04:00:00	QQQ	ETF	29.91	29.94	29.86	29.94	7445.0
2009-01-28 05:00:00	QQQ	ETF	29.94	29.94	29.82	29.82	9353.0
2009-01-28 06:00:00	QQQ	ETF	29.87	29.94	29.87	29.94	7578.0
2009-01-28 07:00:00	QQQ	ETF	29.92	29.92	29.74	29.89	554133.0
2009-01-28 08:00:00	QQQ	ETF	29.86	29.98	29.5949	29.9	1644873.0
2009-01-28 09:00:00	QQQ	ETF	29.91	30.03	29.8	29.87	15929479.0
2009-01-28 10:00:00	QQQ	ETF	29.88	30.19	29.86	30.12	19752779.0
2009-01-28 11:00:00	QQQ	ETF	30.12	30.27	30.11	30.2	13678469.0
2009-01-28 12:00:00	QQQ	ETF	30.2	30.31	30.19	30.25	7797028.0
2009-01-28 13:00:00	QQQ	ETF	30.25	30.54	30.22	30.4279	11136592.0
2009-01-28 14:00:00	QQQ	ETF	30.43	30.65	30.33	30.52	26269552.0
2009-01-28 15:00:00	QQQ	ETF	30.52	30.57	30.08	30.35	33770158.0
2009-01-28 16:00:00	QQQ	ETF	30.36	30.4787	30.21	30.25	3427076.0
2009-01-28 17:00:00	QQQ	ETF	30.25	30.34	30.24	30.24	105141.0
2009-01-28 18:00:00	QQQ	ETF	30.25	30.29	30.2	30.21	49440.0
2009-01-28 19:00:00	QQQ	ETF	30.2	30.23	30.2	30.21	26285.0
2009-01-28 04:00:00	IWM	ETF	46.0	46.0	46.0	46.0	100.0
2009-01-28 05:00:00	IWM	ETF	46.0	46.0	46.0	46.0	100.0
2009-01-28 06:00:00	IWM	ETF	46.28	46.4	46.26	46.26	5200.0
2009-01-28 07:00:00	IWM	ETF	46.21	46.26	46.0	46.24	106550.0
2009-01-28 08:00:00	IWM	ETF	46.23	46.48	46.13	46.43	403907.0
2009-01-28 09:00:00	IWM	ETF	46.44	46.59	46.16	46.29	4937250.0
2009-01-28 10:00:00	IWM	ETF	46.29	46.72	46.19	46.64	7548827.0
2009-01-28 11:00:00	IWM	ETF	46.65	46.93	46.62	46.78	5809010.0
2009-01-28 12:00:00	IWM	ETF	46.78	47.05	46.76	47.02	4340255.0
2009-01-28 13:00:00	IWM	ETF	47.02	47.32	46.96	47.22	7622648.0
2009-01-28 14:00:00	IWM	ETF	47.23	47.49	46.92	47.29	12469474.0
2009-01-28 15:00:00	IWM	ETF	47.3	47.4	46.7	47.24	16032189.0
2009-01-28 16:00:00	IWM	ETF	47.22	47.47	45.489	47.3	2522948.0
2009-01-28 17:00:00	IWM	ETF	47.32	47.32	46.2657	47.3	7100.0
2009-01-28 18:00:00	IWM	ETF	47.3	47.45	47.16	47.16	2400.0
2009-01-28 19:00:00	IWM	ETF	47.22	47.33	47.06	47.07	7950.0
2009-01-28 04:00:00	DIA	ETF	82.39	82.39	82.39	82.39	200.0
2009-01-28 06:00:00	DIA	ETF	82.82	83.0	82.82	83.0	400.0

> showing 50 of 3,978 rows — these rows as CSV

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