PREVIEW / etf_1hour / 2009-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-10.parquet
  size:    144 KB
  rows:    4,491

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-12-10 04:00:00	SPY	ETF	110.1	110.2	110.07	110.11	1600.0
2009-12-10 05:00:00	SPY	ETF	110.28	110.47	110.28	110.34	3302.0
2009-12-10 06:00:00	SPY	ETF	110.43	110.48	110.4	110.44	10424.0
2009-12-10 07:00:00	SPY	ETF	110.49	110.65	110.43	110.55	195016.0
2009-12-10 08:00:00	SPY	ETF	110.48	110.94	110.48	110.73	2446104.0
2009-12-10 09:00:00	SPY	ETF	110.74	111.12	110.64	110.81	19564450.0
2009-12-10 10:00:00	SPY	ETF	110.82	110.94	110.5	110.829	20040440.0
2009-12-10 11:00:00	SPY	ETF	110.83	111.04	110.74	110.78	13246997.0
2009-12-10 12:00:00	SPY	ETF	110.78	110.97	110.65	110.87	9516110.0
2009-12-10 13:00:00	SPY	ETF	110.87	110.88	110.56	110.83	15877655.0
2009-12-10 14:00:00	SPY	ETF	110.82	110.99	110.75	110.82	10451405.0
2009-12-10 15:00:00	SPY	ETF	110.82	110.83	110.45	110.65	26156344.0
2009-12-10 16:00:00	SPY	ETF	110.65	111.03	110.064	110.83	15051654.0
2009-12-10 17:00:00	SPY	ETF	110.84	110.88	110.81	110.82	155571.0
2009-12-10 18:00:00	SPY	ETF	110.83	110.86	110.8	110.86	24353.0
2009-12-10 19:00:00	SPY	ETF	110.89	110.9	110.78	110.79	32498.0
2009-12-10 06:00:00	QQQ	ETF	44.24	44.3	44.24	44.3	450.0
2009-12-10 07:00:00	QQQ	ETF	44.3	44.37	44.29	44.36	470550.0
2009-12-10 08:00:00	QQQ	ETF	44.05	44.43	44.05	44.28	1660993.0
2009-12-10 09:00:00	QQQ	ETF	44.28	44.54	44.21	44.38	13995733.0
2009-12-10 10:00:00	QQQ	ETF	44.38	44.495	44.32	44.431	11090426.0
2009-12-10 11:00:00	QQQ	ETF	44.43	44.51	44.4	44.42	7669561.0
2009-12-10 12:00:00	QQQ	ETF	44.42	44.49	44.38	44.4899	3974129.0
2009-12-10 13:00:00	QQQ	ETF	44.49	44.49	44.3	44.41	8969909.0
2009-12-10 14:00:00	QQQ	ETF	44.41	44.47	44.38	44.41	4819688.0
2009-12-10 15:00:00	QQQ	ETF	44.4101	44.45	44.25	44.29	12682356.0
2009-12-10 16:00:00	QQQ	ETF	44.29	44.3589	44.0809	44.34	5346048.0
2009-12-10 17:00:00	QQQ	ETF	44.35	44.36	44.33	44.35	13622.0
2009-12-10 18:00:00	QQQ	ETF	44.35	44.37	44.34	44.37	18287.0
2009-12-10 19:00:00	QQQ	ETF	44.34	44.36	44.32	44.35	16598.0
2009-12-10 07:00:00	IWM	ETF	60.18	60.3	60.18	60.27	54696.0
2009-12-10 08:00:00	IWM	ETF	60.23	60.49	60.2	60.27	548593.0
2009-12-10 09:00:00	IWM	ETF	60.26	60.44	60.03	60.07	7307718.0
2009-12-10 10:00:00	IWM	ETF	60.06	60.2	59.89	60.1	7182762.0
2009-12-10 11:00:00	IWM	ETF	60.0996	60.19	60.01	60.15	3651123.0
2009-12-10 12:00:00	IWM	ETF	60.1589	60.29	60.08	60.21	3665240.0
2009-12-10 13:00:00	IWM	ETF	60.2192	60.22	59.74	59.94	6247014.0
2009-12-10 14:00:00	IWM	ETF	59.9495	60.05	59.83	59.8599	4742818.0
2009-12-10 15:00:00	IWM	ETF	59.86	59.89	59.36	59.63	12040912.0
2009-12-10 16:00:00	IWM	ETF	59.62	60.3	59.4101	59.83	3511938.0
2009-12-10 17:00:00	IWM	ETF	59.85	59.88	59.83	59.86	27548.0
2009-12-10 18:00:00	IWM	ETF	59.8	59.86	59.8	59.86	500.0
2009-12-10 19:00:00	IWM	ETF	59.82	59.85	59.8	59.83	1200.0
2009-12-10 07:00:00	DIA	ETF	103.92	103.92	103.92	103.92	100.0
2009-12-10 08:00:00	DIA	ETF	103.81	104.28	103.81	103.96	74550.0
2009-12-10 09:00:00	DIA	ETF	103.92	104.62	103.9	104.3	1706082.0
2009-12-10 10:00:00	DIA	ETF	104.31	104.37	103.98	104.29	1447835.0
2009-12-10 11:00:00	DIA	ETF	104.28	104.47	104.23	104.27	771281.0
2009-12-10 12:00:00	DIA	ETF	104.28	104.39	104.14	104.28	532586.0
2009-12-10 13:00:00	DIA	ETF	104.26	104.27	104.02	104.24	919639.0

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

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