PREVIEW / etf_1hour / 2009-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-18.parquet
  size:    146 KB
  rows:    4,523

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-18 04:00:00	SPY	ETF	111.28	111.29	111.15	111.27	2800.0
2009-11-18 05:00:00	SPY	ETF	111.27	111.35	111.22	111.35	11000.0
2009-11-18 06:00:00	SPY	ETF	111.38	111.56	111.38	111.56	21700.0
2009-11-18 07:00:00	SPY	ETF	111.44	111.44	111.26	111.42	1478199.0
2009-11-18 08:00:00	SPY	ETF	111.33	111.49	110.96	111.12	5546032.0
2009-11-18 09:00:00	SPY	ETF	111.12	111.43	110.71	110.79	29608899.0
2009-11-18 10:00:00	SPY	ETF	110.79	111.28	110.57	111.08	30219108.0
2009-11-18 11:00:00	SPY	ETF	111.08	111.29	110.92	111.1	15168542.0
2009-11-18 12:00:00	SPY	ETF	111.11	111.17	110.8	110.82	10916981.0
2009-11-18 13:00:00	SPY	ETF	110.82	110.96	110.62	110.88	15100616.0
2009-11-18 14:00:00	SPY	ETF	110.88	111.09	110.8	110.9	11056094.0
2009-11-18 15:00:00	SPY	ETF	110.91	111.32	110.885	111.28	24565139.0
2009-11-18 16:00:00	SPY	ETF	111.28	111.4	103.78	111.37	11894328.0
2009-11-18 17:00:00	SPY	ETF	111.36	111.43	111.35	111.42	67345.0
2009-11-18 18:00:00	SPY	ETF	111.41	111.43	111.27	111.35	109327.0
2009-11-18 19:00:00	SPY	ETF	111.38	111.38	111.2	111.2	71014.0
2009-11-18 05:00:00	QQQ	ETF	44.52	44.52	44.52	44.52	4000.0
2009-11-18 06:00:00	QQQ	ETF	44.56	44.56	44.56	44.56	460.0
2009-11-18 07:00:00	QQQ	ETF	44.59	44.59	44.49	44.5	845072.0
2009-11-18 08:00:00	QQQ	ETF	44.51	44.53	44.38	44.42	2911485.0
2009-11-18 09:00:00	QQQ	ETF	44.42	44.49	44.15	44.18	14101029.0
2009-11-18 10:00:00	QQQ	ETF	44.18	44.4	44.08	44.25	24431969.0
2009-11-18 11:00:00	QQQ	ETF	44.26	44.36	44.18	44.27	13397962.0
2009-11-18 12:00:00	QQQ	ETF	44.27	44.285	44.16	44.17	6868051.0
2009-11-18 13:00:00	QQQ	ETF	44.16	44.18	44.05	44.155	8043517.0
2009-11-18 14:00:00	QQQ	ETF	44.1405	44.26	44.14	44.17	5688205.0
2009-11-18 15:00:00	QQQ	ETF	44.18	44.36	44.17	44.35	11804431.0
2009-11-18 16:00:00	QQQ	ETF	44.35	44.37	44.2569	44.35	2474512.0
2009-11-18 17:00:00	QQQ	ETF	44.36	44.38	44.34	44.37	79339.0
2009-11-18 18:00:00	QQQ	ETF	44.38	44.38	44.36	44.36	65870.0
2009-11-18 19:00:00	QQQ	ETF	44.37	44.37	44.29	44.3	53990.0
2009-11-18 06:00:00	IWM	ETF	60.34	60.37	60.34	60.36	3301.0
2009-11-18 07:00:00	IWM	ETF	60.33	60.36	60.28	60.36	75671.0
2009-11-18 08:00:00	IWM	ETF	60.36	60.41	60.06	60.12	815999.0
2009-11-18 09:00:00	IWM	ETF	60.13	60.38	59.79	59.87	10181956.0
2009-11-18 10:00:00	IWM	ETF	59.86	60.16	59.67	59.915	11531095.0
2009-11-18 11:00:00	IWM	ETF	59.92	60.07	59.74	59.87	6523254.0
2009-11-18 12:00:00	IWM	ETF	59.87	59.97	59.76	59.78	2954003.0
2009-11-18 13:00:00	IWM	ETF	59.78	59.84	59.6	59.685	5613898.0
2009-11-18 14:00:00	IWM	ETF	59.679	59.89	59.64	59.71	3505443.0
2009-11-18 15:00:00	IWM	ETF	59.72	60.17	59.72	60.16	6938549.0
2009-11-18 16:00:00	IWM	ETF	60.17	60.3116	59.8	60.3116	3748554.0
2009-11-18 17:00:00	IWM	ETF	60.19	60.25	60.16	60.22	13262.0
2009-11-18 18:00:00	IWM	ETF	60.23	60.25	60.21	60.21	7093.0
2009-11-18 19:00:00	IWM	ETF	60.19	60.2	60.12	60.12	1600.0
2009-11-18 08:00:00	DIA	ETF	104.65	104.75	104.31	104.41	12647.0
2009-11-18 09:00:00	DIA	ETF	104.39	104.62	103.99	104.06	1615780.0
2009-11-18 10:00:00	DIA	ETF	104.06	104.389	103.91	104.35	1703626.0
2009-11-18 11:00:00	DIA	ETF	104.35	104.4901	104.2	104.36	740828.0
2009-11-18 12:00:00	DIA	ETF	104.37	104.38	104.08	104.1	607098.0

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

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