PREVIEW / etf_1hour / 2009-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-21.parquet
  size:    128 KB
  rows:    3,918

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-21 04:00:00	SPY	ETF	81.25	81.33	81.0	81.0	3300.0
2009-01-21 05:00:00	SPY	ETF	80.98	81.87	80.98	81.87	8000.0
2009-01-21 06:00:00	SPY	ETF	81.79	82.25	81.28	81.81	111400.0
2009-01-21 07:00:00	SPY	ETF	81.65	81.79	81.26	81.35	1036832.0
2009-01-21 08:00:00	SPY	ETF	81.34	82.0	81.04	81.8	3242128.0
2009-01-21 09:00:00	SPY	ETF	81.79	82.4	81.52	82.25	36748436.0
2009-01-21 10:00:00	SPY	ETF	82.27	82.46	80.47	80.56	63844002.0
2009-01-21 11:00:00	SPY	ETF	80.55	81.71	80.54	81.31	46307764.0
2009-01-21 12:00:00	SPY	ETF	81.31	81.82	81.15	81.62	31026362.0
2009-01-21 13:00:00	SPY	ETF	81.63	82.13	81.18	82.12	35603526.0
2009-01-21 14:00:00	SPY	ETF	82.12	83.02	81.8	82.95	46404556.0
2009-01-21 15:00:00	SPY	ETF	82.93	84.24	81.65	84.04	79354233.0
2009-01-21 16:00:00	SPY	ETF	84.05	84.67	80.5925	84.29	19198951.0
2009-01-21 17:00:00	SPY	ETF	84.29	84.55	84.27	84.45	560009.0
2009-01-21 18:00:00	SPY	ETF	84.43	84.54	84.37	84.37	361164.0
2009-01-21 19:00:00	SPY	ETF	84.39	84.39	84.03	84.1	155317.0
2009-01-21 04:00:00	QQQ	ETF	28.21	28.21	28.21	28.21	443.0
2009-01-21 05:00:00	QQQ	ETF	28.2	28.39	28.2	28.39	1560.0
2009-01-21 06:00:00	QQQ	ETF	28.37	28.49	28.34	28.44	1600.0
2009-01-21 07:00:00	QQQ	ETF	28.4	28.43	28.24	28.24	269153.0
2009-01-21 08:00:00	QQQ	ETF	28.25	28.65	28.21	28.41	992289.0
2009-01-21 09:00:00	QQQ	ETF	28.42	28.65	28.34	28.61	18591154.0
2009-01-21 10:00:00	QQQ	ETF	28.61	28.68	28.1	28.13	24849858.0
2009-01-21 11:00:00	QQQ	ETF	28.125	28.4	28.11	28.31	14053646.0
2009-01-21 12:00:00	QQQ	ETF	28.31	28.48	28.24	28.35	11657046.0
2009-01-21 13:00:00	QQQ	ETF	28.35	28.525	28.23	28.52	14096068.0
2009-01-21 14:00:00	QQQ	ETF	28.52	28.76	28.38	28.76	19600849.0
2009-01-21 15:00:00	QQQ	ETF	28.77	29.19	28.71	29.14	39025323.0
2009-01-21 16:00:00	QQQ	ETF	29.15	29.64	29.02	29.43	5500210.0
2009-01-21 17:00:00	QQQ	ETF	29.44	29.51	29.42	29.49	156475.0
2009-01-21 18:00:00	QQQ	ETF	29.47	29.49	29.41	29.47	48176.0
2009-01-21 19:00:00	QQQ	ETF	29.46	29.46	29.39	29.41	43518.0
2009-01-21 06:00:00	IWM	ETF	43.79	44.04	43.77	43.77	2300.0
2009-01-21 07:00:00	IWM	ETF	43.85	43.85	43.67	43.67	14955.0
2009-01-21 08:00:00	IWM	ETF	43.61	43.91	43.53	43.86	168805.0
2009-01-21 09:00:00	IWM	ETF	43.88	44.16	43.44	44.0	5692329.0
2009-01-21 10:00:00	IWM	ETF	44.0	44.07	43.05	43.05	11689810.0
2009-01-21 11:00:00	IWM	ETF	43.04	43.85	43.04	43.59	6586042.0
2009-01-21 12:00:00	IWM	ETF	43.6	43.97	43.51	43.92	3876654.0
2009-01-21 13:00:00	IWM	ETF	43.92	44.08	43.55	44.07	5299435.0
2009-01-21 14:00:00	IWM	ETF	44.07	44.75	43.8899	44.71	9109294.0
2009-01-21 15:00:00	IWM	ETF	44.71	45.69	43.2904	45.5	19964428.0
2009-01-21 16:00:00	IWM	ETF	45.5	45.91	43.22	45.72	3041798.0
2009-01-21 17:00:00	IWM	ETF	45.67	45.86	45.67	45.83	126325.0
2009-01-21 18:00:00	IWM	ETF	45.83	45.85	45.83	45.85	2400.0
2009-01-21 19:00:00	IWM	ETF	45.5	45.55	45.5	45.55	300.0
2009-01-21 04:00:00	DIA	ETF	80.0	80.0	80.0	80.0	100.0
2009-01-21 06:00:00	DIA	ETF	80.49	80.66	80.45	80.45	2355.0
2009-01-21 07:00:00	DIA	ETF	80.37	80.49	80.11	80.11	38303.0
2009-01-21 08:00:00	DIA	ETF	80.15	80.63	80.15	80.51	110020.0

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

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