PREVIEW / etf_1hour / 2009-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-05.parquet
  size:    144 KB
  rows:    4,403

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-10-05 04:00:00	SPY	ETF	103.3	103.3	103.09	103.16	1352.0
2009-10-05 05:00:00	SPY	ETF	103.26	103.26	103.1	103.1	2400.0
2009-10-05 06:00:00	SPY	ETF	103.21	103.26	103.14	103.26	17400.0
2009-10-05 07:00:00	SPY	ETF	103.25	103.28	103.15	103.25	222713.0
2009-10-05 08:00:00	SPY	ETF	103.25	103.26	102.88	102.93	1115336.0
2009-10-05 09:00:00	SPY	ETF	102.92	103.46	102.6	103.34	25216121.0
2009-10-05 10:00:00	SPY	ETF	103.335	103.62	102.76	103.6	34929180.0
2009-10-05 11:00:00	SPY	ETF	103.605	103.72	103.28	103.54	18139610.0
2009-10-05 12:00:00	SPY	ETF	103.53	103.84	103.47	103.76	10738382.0
2009-10-05 13:00:00	SPY	ETF	103.76	103.86	103.64	103.77	7222190.0
2009-10-05 14:00:00	SPY	ETF	103.76	104.32	103.59	104.16	19505003.0
2009-10-05 15:00:00	SPY	ETF	104.16	104.26	103.96	104.03	26066280.0
2009-10-05 16:00:00	SPY	ETF	104.03	104.2	102.552	104.17	5826248.0
2009-10-05 17:00:00	SPY	ETF	104.18	104.24	104.02	104.07	401596.0
2009-10-05 18:00:00	SPY	ETF	104.08	104.14	104.06	104.12	33231.0
2009-10-05 19:00:00	SPY	ETF	104.11	104.18	104.08	104.09	50972.0
2009-10-05 04:00:00	QQQ	ETF	41.2	41.2	41.14	41.14	4600.0
2009-10-05 05:00:00	QQQ	ETF	41.2	41.21	41.19	41.2	1158.0
2009-10-05 06:00:00	QQQ	ETF	41.19	41.22	41.19	41.2	7200.0
2009-10-05 07:00:00	QQQ	ETF	41.2	41.21	41.17	41.21	113160.0
2009-10-05 08:00:00	QQQ	ETF	41.21	41.21	41.08	41.09	597113.0
2009-10-05 09:00:00	QQQ	ETF	41.09	41.23	40.95	41.08	15724813.0
2009-10-05 10:00:00	QQQ	ETF	41.1	41.35	40.83	41.33	20952018.0
2009-10-05 11:00:00	QQQ	ETF	41.34	41.37	41.1	41.2	11459120.0
2009-10-05 12:00:00	QQQ	ETF	41.2	41.3	41.15	41.25	6129685.0
2009-10-05 13:00:00	QQQ	ETF	41.26	41.3	41.19	41.25	3665252.0
2009-10-05 14:00:00	QQQ	ETF	41.2501	41.4	41.13	41.31	11170930.0
2009-10-05 15:00:00	QQQ	ETF	41.31	41.351	41.2	41.2	19616450.0
2009-10-05 16:00:00	QQQ	ETF	41.2	41.3	40.8972	41.25	4499428.0
2009-10-05 17:00:00	QQQ	ETF	41.25	41.27	41.24	41.24	31922.0
2009-10-05 18:00:00	QQQ	ETF	41.24	41.26	41.22	41.25	37528.0
2009-10-05 19:00:00	QQQ	ETF	41.26	41.29	41.26	41.29	32696.0
2009-10-05 05:00:00	IWM	ETF	58.42	58.42	58.42	58.42	200.0
2009-10-05 07:00:00	IWM	ETF	58.5	58.5	58.43	58.5	5525.0
2009-10-05 08:00:00	IWM	ETF	58.5	58.5	58.27	58.29	124435.0
2009-10-05 09:00:00	IWM	ETF	58.28	58.85	58.08	58.69	8102386.0
2009-10-05 10:00:00	IWM	ETF	58.69	59.0	58.23	58.97	9776983.0
2009-10-05 11:00:00	IWM	ETF	58.96	59.03	58.4	58.71	6516455.0
2009-10-05 12:00:00	IWM	ETF	58.73	58.909	58.65	58.79	1983721.0
2009-10-05 13:00:00	IWM	ETF	58.78	58.89	58.69	58.8105	1381773.0
2009-10-05 14:00:00	IWM	ETF	58.82	59.29	58.65	59.14	4095271.0
2009-10-05 15:00:00	IWM	ETF	59.14	59.23	58.98	59.1	9593932.0
2009-10-05 16:00:00	IWM	ETF	59.09	59.16	58.0276	59.07	3902787.0
2009-10-05 17:00:00	IWM	ETF	59.1	59.11	59.05	59.11	7864.0
2009-10-05 18:00:00	IWM	ETF	59.07	59.09	59.07	59.09	200.0
2009-10-05 19:00:00	IWM	ETF	59.14	59.21	59.12	59.21	700.0
2009-10-05 05:00:00	DIA	ETF	95.3	95.31	95.29	95.31	400.0
2009-10-05 06:00:00	DIA	ETF	95.42	95.42	95.42	95.42	100.0
2009-10-05 07:00:00	DIA	ETF	95.43	95.43	95.37	95.37	300.0
2009-10-05 08:00:00	DIA	ETF	95.38	95.42	95.13	95.13	47725.0

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

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