PREVIEW / etf_1hour / 2009-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-18.parquet
  size:    148 KB
  rows:    4,567

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-18 04:00:00	SPY	ETF	109.9	110.41	109.9	110.41	9138.0
2009-12-18 05:00:00	SPY	ETF	110.46	110.63	110.41	110.41	11241.0
2009-12-18 06:00:00	SPY	ETF	110.46	110.51	110.09	110.16	50082.0
2009-12-18 07:00:00	SPY	ETF	110.14	110.42	110.13	110.31	238055.0
2009-12-18 08:00:00	SPY	ETF	110.32	110.48	110.05	110.06	1911883.0
2009-12-18 09:00:00	SPY	ETF	110.05	110.3	109.91	110.05	21525908.0
2009-12-18 10:00:00	SPY	ETF	110.05	110.2	109.62	109.735	25024766.0
2009-12-18 11:00:00	SPY	ETF	109.74	109.78	109.28	109.4799	22827275.0
2009-12-18 12:00:00	SPY	ETF	109.48	109.85	109.39	109.8	17395060.0
2009-12-18 13:00:00	SPY	ETF	109.81	110.06	109.76	109.9	15396722.0
2009-12-18 14:00:00	SPY	ETF	109.9	109.99	109.79	109.95	10053921.0
2009-12-18 15:00:00	SPY	ETF	109.96	110.28	109.72	110.23	29347469.0
2009-12-18 16:00:00	SPY	ETF	110.24	110.42	109.34	110.4	24657877.0
2009-12-18 17:00:00	SPY	ETF	110.4	110.52	110.38	110.41	2746257.0
2009-12-18 18:00:00	SPY	ETF	110.41	110.52	110.16	110.29	1913372.0
2009-12-18 19:00:00	SPY	ETF	110.28	110.39	110.28	110.34	36087.0
2009-12-18 04:00:00	QQQ	ETF	44.13	44.13	44.13	44.13	400.0
2009-12-18 05:00:00	QQQ	ETF	44.17	44.17	44.11	44.11	7400.0
2009-12-18 06:00:00	QQQ	ETF	44.11	44.11	44.01	44.02	24300.0
2009-12-18 07:00:00	QQQ	ETF	44.02	44.1	44.01	44.08	95377.0
2009-12-18 08:00:00	QQQ	ETF	44.08	44.1	43.99	44.02	1269491.0
2009-12-18 09:00:00	QQQ	ETF	44.02	44.34	44.01	44.2501	16204258.0
2009-12-18 10:00:00	QQQ	ETF	44.26	44.31	44.05	44.1299	12541583.0
2009-12-18 11:00:00	QQQ	ETF	44.13	44.16	44.0	44.09	11860793.0
2009-12-18 12:00:00	QQQ	ETF	44.09	44.29	44.06	44.28	12077501.0
2009-12-18 13:00:00	QQQ	ETF	44.27	44.37	44.2	44.3	13739263.0
2009-12-18 14:00:00	QQQ	ETF	44.3	44.37	44.27	44.35	5515761.0
2009-12-18 15:00:00	QQQ	ETF	44.35	44.48	44.23	44.46	15472899.0
2009-12-18 16:00:00	QQQ	ETF	44.48	44.52	44.08	44.52	5791935.0
2009-12-18 17:00:00	QQQ	ETF	44.5	44.52	44.5	44.5	35700.0
2009-12-18 18:00:00	QQQ	ETF	44.5	44.51	44.48	44.49	8050.0
2009-12-18 19:00:00	QQQ	ETF	44.51	44.52	44.47	44.47	41655.0
2009-12-18 07:00:00	IWM	ETF	61.19	61.25	61.16	61.21	28200.0
2009-12-18 08:00:00	IWM	ETF	61.2	61.23	60.97	60.97	463196.0
2009-12-18 09:00:00	IWM	ETF	61.0	61.14	60.76	60.81	6488490.0
2009-12-18 10:00:00	IWM	ETF	60.82	60.89	60.38	60.53	7725551.0
2009-12-18 11:00:00	IWM	ETF	60.53	60.58	60.32	60.45	8169055.0
2009-12-18 12:00:00	IWM	ETF	60.46	60.82	60.4	60.76	7130269.0
2009-12-18 13:00:00	IWM	ETF	60.769	61.08	60.76	60.875	7231912.0
2009-12-18 14:00:00	IWM	ETF	60.875	60.95	60.74	60.94	3181269.0
2009-12-18 15:00:00	IWM	ETF	60.935	61.17	60.65	61.14	12894410.0
2009-12-18 16:00:00	IWM	ETF	61.14	61.49	60.5907	61.32	5655101.0
2009-12-18 17:00:00	IWM	ETF	61.32	61.4	61.27	61.34	28767.0
2009-12-18 18:00:00	IWM	ETF	61.35	61.35	61.14	61.17	15595.0
2009-12-18 19:00:00	IWM	ETF	61.21	61.36	61.21	61.36	200.0
2009-12-18 07:00:00	DIA	ETF	103.51	103.54	103.4	103.5	1500.0
2009-12-18 08:00:00	DIA	ETF	103.54	103.57	103.33	103.36	27330.0
2009-12-18 09:00:00	DIA	ETF	103.35	103.64	103.17	103.24	1213106.0
2009-12-18 10:00:00	DIA	ETF	103.25	103.32	102.82	102.91	1525339.0
2009-12-18 11:00:00	DIA	ETF	102.92	102.95	102.43	102.6	1877423.0

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

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