PREVIEW / etf_1hour / 2009-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-01.parquet
  size:    129 KB
  rows:    3,964

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-04-01 04:00:00	SPY	ETF	78.78	78.88	78.75	78.84	3500.0
2009-04-01 05:00:00	SPY	ETF	78.9	79.15	78.9	79.06	27500.0
2009-04-01 06:00:00	SPY	ETF	79.19	79.22	79.05	79.05	24000.0
2009-04-01 07:00:00	SPY	ETF	79.05	79.55	79.05	79.14	1043503.0
2009-04-01 08:00:00	SPY	ETF	79.14	79.52	78.4	78.82	5643707.0
2009-04-01 09:00:00	SPY	ETF	78.8	79.22	78.33	78.9	33730086.0
2009-04-01 10:00:00	SPY	ETF	78.8901	80.41	78.8901	80.14	85522691.0
2009-04-01 11:00:00	SPY	ETF	80.13	80.6	79.89	80.51	40602371.0
2009-04-01 12:00:00	SPY	ETF	80.51	80.92	80.29	80.37	29913445.0
2009-04-01 13:00:00	SPY	ETF	80.37	81.01	80.18	80.96	30564581.0
2009-04-01 14:00:00	SPY	ETF	80.96	81.29	80.35	81.0175	39798293.0
2009-04-01 15:00:00	SPY	ETF	81.0175	81.42	78.4	81.03	80400138.0
2009-04-01 16:00:00	SPY	ETF	81.03	81.36	79.3	81.26	14416754.0
2009-04-01 17:00:00	SPY	ETF	81.26	81.4	81.22	81.39	286842.0
2009-04-01 18:00:00	SPY	ETF	81.37	81.39	81.29	81.29	282286.0
2009-04-01 19:00:00	SPY	ETF	81.29	81.31	81.25	81.29	109120.0
2009-04-01 04:00:00	QQQ	ETF	30.07	30.16	30.07	30.16	985.0
2009-04-01 05:00:00	QQQ	ETF	30.2	30.2	30.2	30.2	100.0
2009-04-01 06:00:00	QQQ	ETF	30.21	30.21	30.15	30.15	1000.0
2009-04-01 07:00:00	QQQ	ETF	30.15	30.26	30.14	30.14	665154.0
2009-04-01 08:00:00	QQQ	ETF	30.14	30.32	29.85	30.0	3335579.0
2009-04-01 09:00:00	QQQ	ETF	29.99	30.07	29.79	29.94	15677916.0
2009-04-01 10:00:00	QQQ	ETF	29.9401	30.58	29.9401	30.51	32110531.0
2009-04-01 11:00:00	QQQ	ETF	30.5	30.67	30.4	30.64	15783666.0
2009-04-01 12:00:00	QQQ	ETF	30.64	30.76	30.5	30.57	10364919.0
2009-04-01 13:00:00	QQQ	ETF	30.57	30.74	30.5	30.7188	9634703.0
2009-04-01 14:00:00	QQQ	ETF	30.72	30.87	30.69	30.8	14579887.0
2009-04-01 15:00:00	QQQ	ETF	30.8	30.88	30.4701	30.78	30763497.0
2009-04-01 16:00:00	QQQ	ETF	30.7799	30.9044	29.9	30.77	3198458.0
2009-04-01 17:00:00	QQQ	ETF	30.77	30.84	30.75	30.84	321110.0
2009-04-01 18:00:00	QQQ	ETF	30.83	30.83	30.79	30.8	88527.0
2009-04-01 19:00:00	QQQ	ETF	30.8	30.82	30.8	30.81	56952.0
2009-04-01 06:00:00	IWM	ETF	41.82	41.82	41.68	41.72	900.0
2009-04-01 07:00:00	IWM	ETF	41.76	42.01	41.76	41.87	40851.0
2009-04-01 08:00:00	IWM	ETF	41.87	42.05	41.48	41.65	891070.0
2009-04-01 09:00:00	IWM	ETF	41.66	41.66	41.11	41.44	6748073.0
2009-04-01 10:00:00	IWM	ETF	41.44	42.63	41.43	42.4	15731035.0
2009-04-01 11:00:00	IWM	ETF	42.4	42.78	42.31	42.7	7272579.0
2009-04-01 12:00:00	IWM	ETF	42.699	42.94	42.37	42.46	4905201.0
2009-04-01 13:00:00	IWM	ETF	42.44	42.86	42.33	42.79	4841027.0
2009-04-01 14:00:00	IWM	ETF	42.79	43.0	42.59	42.68	5710035.0
2009-04-01 15:00:00	IWM	ETF	42.68	42.91	42.09	42.85	13649316.0
2009-04-01 16:00:00	IWM	ETF	42.85	42.93	42.67	42.79	2144768.0
2009-04-01 17:00:00	IWM	ETF	42.81	42.89	42.2542	42.85	1504450.0
2009-04-01 18:00:00	IWM	ETF	42.93	42.93	42.8	42.88	1347.0
2009-04-01 19:00:00	IWM	ETF	42.88	42.88	42.88	42.88	100.0
2009-04-01 06:00:00	DIA	ETF	75.45	75.46	75.45	75.46	500.0
2009-04-01 07:00:00	DIA	ETF	75.59	75.83	75.49	75.5	22688.0
2009-04-01 08:00:00	DIA	ETF	75.53	75.65	75.01	75.1	367051.0
2009-04-01 09:00:00	DIA	ETF	75.09	75.28	74.8	75.26	2830590.0

> showing 50 of 3,964 rows — these rows as CSV

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