PREVIEW / etf_1hour / 2009-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-23.parquet
  size:    146 KB
  rows:    4,445

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-07-23 04:00:00	SPY	ETF	95.66	95.75	95.66	95.72	3850.0
2009-07-23 05:00:00	SPY	ETF	95.81	95.81	95.75	95.75	200.0
2009-07-23 06:00:00	SPY	ETF	95.72	95.76	95.48	95.59	31700.0
2009-07-23 07:00:00	SPY	ETF	95.52	95.98	95.52	95.87	742736.0
2009-07-23 08:00:00	SPY	ETF	95.88	96.08	95.66	95.67	3599840.0
2009-07-23 09:00:00	SPY	ETF	95.67	96.41	95.53	96.35	25960913.0
2009-07-23 10:00:00	SPY	ETF	96.36	97.32	96.17	97.16	50594580.0
2009-07-23 11:00:00	SPY	ETF	97.16	97.78	96.9	97.52	30797851.0
2009-07-23 12:00:00	SPY	ETF	97.52	97.89	97.51	97.87	19073468.0
2009-07-23 13:00:00	SPY	ETF	97.87	98.06	96.88	97.75	20111796.0
2009-07-23 14:00:00	SPY	ETF	97.75	98.0	97.67	97.89	24221077.0
2009-07-23 15:00:00	SPY	ETF	97.89	98.08	97.48	97.68	53472607.0
2009-07-23 16:00:00	SPY	ETF	97.68	97.8	95.5222	96.83	28137418.0
2009-07-23 17:00:00	SPY	ETF	96.83	96.9	96.7	96.82	1136642.0
2009-07-23 18:00:00	SPY	ETF	96.84	96.96	96.8	96.94	305813.0
2009-07-23 19:00:00	SPY	ETF	96.94	96.97	96.9	96.92	72310.0
2009-07-23 04:00:00	QQQ	ETF	38.45	38.5	38.45	38.5	2700.0
2009-07-23 05:00:00	QQQ	ETF	38.47	38.47	38.47	38.47	200.0
2009-07-23 06:00:00	QQQ	ETF	38.48	38.5	38.36	38.4	23700.0
2009-07-23 07:00:00	QQQ	ETF	38.43	38.54	38.39	38.48	289721.0
2009-07-23 08:00:00	QQQ	ETF	38.48	38.56	38.41	38.41	1669571.0
2009-07-23 09:00:00	QQQ	ETF	38.41	38.84	38.38	38.82	19562279.0
2009-07-23 10:00:00	QQQ	ETF	38.82	39.14	38.74	39.045	29597679.0
2009-07-23 11:00:00	QQQ	ETF	39.05	39.35	39.04	39.24	18590521.0
2009-07-23 12:00:00	QQQ	ETF	39.2301	39.42	39.23	39.41	11740759.0
2009-07-23 13:00:00	QQQ	ETF	39.4001	39.49	38.98	39.37	9008228.0
2009-07-23 14:00:00	QQQ	ETF	39.37	39.43	39.3	39.4	10816177.0
2009-07-23 15:00:00	QQQ	ETF	39.4	39.49	39.27	39.35	25699579.0
2009-07-23 16:00:00	QQQ	ETF	39.35	39.463	38.4929	38.73	22208188.0
2009-07-23 17:00:00	QQQ	ETF	38.73	38.8	38.7	38.8	709611.0
2009-07-23 18:00:00	QQQ	ETF	38.78	39.39	38.76	38.81	464904.0
2009-07-23 19:00:00	QQQ	ETF	38.81	38.83	38.79	38.83	148455.0
2009-07-23 06:00:00	IWM	ETF	52.86	52.86	52.85	52.85	5000.0
2009-07-23 07:00:00	IWM	ETF	52.78	53.04	52.78	52.95	116824.0
2009-07-23 08:00:00	IWM	ETF	52.96	53.09	52.9	52.9	1088448.0
2009-07-23 09:00:00	IWM	ETF	52.89	53.54	52.77	53.53	7620388.0
2009-07-23 10:00:00	IWM	ETF	53.49	54.2	53.44	54.02	11036495.0
2009-07-23 11:00:00	IWM	ETF	54.03	54.46	54.01	54.34	7768943.0
2009-07-23 12:00:00	IWM	ETF	54.34	54.67	54.34	54.64	6173396.0
2009-07-23 13:00:00	IWM	ETF	54.63	54.82	54.53	54.58	5585856.0
2009-07-23 14:00:00	IWM	ETF	54.575	54.73	54.56	54.66	5658945.0
2009-07-23 15:00:00	IWM	ETF	54.67	54.75	54.37	54.55	10544888.0
2009-07-23 16:00:00	IWM	ETF	54.55	54.68	52.8745	54.02	6104104.0
2009-07-23 17:00:00	IWM	ETF	54.02	54.06	53.91	53.96	32866.0
2009-07-23 18:00:00	IWM	ETF	53.96	53.99	53.91	53.91	6471.0
2009-07-23 19:00:00	IWM	ETF	53.9	53.96	53.84	53.95	6830.0
2009-07-23 07:00:00	DIA	ETF	88.95	89.29	88.95	89.22	8075.0
2009-07-23 08:00:00	DIA	ETF	89.19	89.26	89.02	89.04	64750.0
2009-07-23 09:00:00	DIA	ETF	89.02	89.59	88.84	89.51	2668003.0
2009-07-23 10:00:00	DIA	ETF	89.52	90.41	89.42	90.23	3609625.0

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

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