PREVIEW / etf_1hour / 2009-11-24

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-24.parquet
  size:    144 KB
  rows:    4,492

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-11-24 04:00:00	SPY	ETF	110.78	110.78	110.73	110.73	1635.0
2009-11-24 05:00:00	SPY	ETF	110.76	111.11	110.76	111.1	8700.0
2009-11-24 06:00:00	SPY	ETF	111.1	111.1	110.93	110.95	12450.0
2009-11-24 07:00:00	SPY	ETF	110.94	111.14	110.92	111.13	319488.0
2009-11-24 08:00:00	SPY	ETF	111.09	111.15	110.52	110.99	2452525.0
2009-11-24 09:00:00	SPY	ETF	110.98	111.17	110.14	110.41	21031313.0
2009-11-24 10:00:00	SPY	ETF	110.28	110.96	110.01	110.81	34968718.0
2009-11-24 11:00:00	SPY	ETF	110.82	110.88	110.42	110.67	14468969.0
2009-11-24 12:00:00	SPY	ETF	110.68	110.73	110.49	110.53	8093390.0
2009-11-24 13:00:00	SPY	ETF	110.53	110.76	110.515	110.69	7800786.0
2009-11-24 14:00:00	SPY	ETF	110.7	111.14	110.56	111.04	18997941.0
2009-11-24 15:00:00	SPY	ETF	111.05	111.2022	110.75	110.95	21008695.0
2009-11-24 16:00:00	SPY	ETF	110.96	111.04	110.31	110.84	8478054.0
2009-11-24 17:00:00	SPY	ETF	110.84	110.85	110.77	110.8	73650.0
2009-11-24 18:00:00	SPY	ETF	110.81	110.86	110.73	110.8	63166.0
2009-11-24 19:00:00	SPY	ETF	110.81	110.98	110.77	110.77	63050.0
2009-11-24 06:00:00	QQQ	ETF	44.09	44.09	44.09	44.09	1200.0
2009-11-24 07:00:00	QQQ	ETF	44.07	44.17	44.07	44.14	87300.0
2009-11-24 08:00:00	QQQ	ETF	44.13	44.16	43.92	44.07	771165.0
2009-11-24 09:00:00	QQQ	ETF	44.07	44.17	43.75	43.82	13318384.0
2009-11-24 10:00:00	QQQ	ETF	43.82	44.0192	43.73	43.945	15897291.0
2009-11-24 11:00:00	QQQ	ETF	43.96	44.0	43.83	43.8999	5816191.0
2009-11-24 12:00:00	QQQ	ETF	43.9	43.91	43.81	43.82	3592234.0
2009-11-24 13:00:00	QQQ	ETF	43.82	43.93	43.815	43.89	4181714.0
2009-11-24 14:00:00	QQQ	ETF	43.8899	44.08	43.85	44.04	6620391.0
2009-11-24 15:00:00	QQQ	ETF	44.05	44.08	43.94	43.99	7124742.0
2009-11-24 16:00:00	QQQ	ETF	43.98	44.02	43.8475	44.02	2240781.0
2009-11-24 17:00:00	QQQ	ETF	44.0	44.0	43.97	43.99	226200.0
2009-11-24 18:00:00	QQQ	ETF	44.0	44.0	43.96	43.99	8430.0
2009-11-24 19:00:00	QQQ	ETF	43.99	44.05	43.99	44.01	46525.0
2009-11-24 07:00:00	IWM	ETF	59.61	59.79	59.61	59.74	7767.0
2009-11-24 08:00:00	IWM	ETF	59.75	59.78	59.09	59.65	356105.0
2009-11-24 09:00:00	IWM	ETF	59.64	59.74	58.75	58.83	7827667.0
2009-11-24 10:00:00	IWM	ETF	58.86	59.23	58.62	59.11	11765150.0
2009-11-24 11:00:00	IWM	ETF	59.12	59.19	58.9	59.17	5290350.0
2009-11-24 12:00:00	IWM	ETF	59.17	59.22	59.03	59.04	2550481.0
2009-11-24 13:00:00	IWM	ETF	59.04	59.12	58.93	58.96	2725832.0
2009-11-24 14:00:00	IWM	ETF	58.95	59.45	58.84	59.398	5832988.0
2009-11-24 15:00:00	IWM	ETF	59.4	59.43	59.0	59.35	6042941.0
2009-11-24 16:00:00	IWM	ETF	59.35	59.5853	59.1016	59.39	1562343.0
2009-11-24 17:00:00	IWM	ETF	59.36	59.37	59.33	59.33	999.0
2009-11-24 18:00:00	IWM	ETF	59.36	59.36	59.31	59.32	2703.0
2009-11-24 06:00:00	DIA	ETF	103.7	103.7	103.7	103.7	100.0
2009-11-24 07:00:00	DIA	ETF	104.35	104.6	104.35	104.6	330.0
2009-11-24 08:00:00	DIA	ETF	104.55	104.56	104.32	104.44	7890.0
2009-11-24 09:00:00	DIA	ETF	104.42	104.55	103.68	103.73	2289064.0
2009-11-24 10:00:00	DIA	ETF	103.78	104.37	103.59	104.26	2556104.0
2009-11-24 11:00:00	DIA	ETF	104.26	104.31	103.89	104.1	913758.0
2009-11-24 12:00:00	DIA	ETF	104.1	104.15	103.96	104.0	971036.0
2009-11-24 13:00:00	DIA	ETF	103.996	104.19	103.98	104.14	662289.0

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

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