PREVIEW / etf_1hour / 2009-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-09.parquet
  size:    140 KB
  rows:    4,339

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-09 04:00:00	SPY	ETF	106.9	106.9	106.66	106.66	2948.0
2009-10-09 05:00:00	SPY	ETF	106.66	106.66	106.45	106.48	7100.0
2009-10-09 06:00:00	SPY	ETF	106.48	106.7	106.48	106.65	7001.0
2009-10-09 07:00:00	SPY	ETF	106.72	106.86	106.66	106.66	135243.0
2009-10-09 08:00:00	SPY	ETF	106.65	106.72	106.33	106.64	2753571.0
2009-10-09 09:00:00	SPY	ETF	106.63	106.91	106.36	106.8901	18968940.0
2009-10-09 10:00:00	SPY	ETF	106.89	107.01	106.68	106.89	24555251.0
2009-10-09 11:00:00	SPY	ETF	106.89	107.03	106.78	106.81	18461386.0
2009-10-09 12:00:00	SPY	ETF	106.81	106.9	106.63	106.84	10812132.0
2009-10-09 13:00:00	SPY	ETF	106.8484	106.97	106.7317	106.881	9461733.0
2009-10-09 14:00:00	SPY	ETF	106.89	107.02	106.76	107.02	12804466.0
2009-10-09 15:00:00	SPY	ETF	107.02	107.26	106.98	107.24	24585237.0
2009-10-09 16:00:00	SPY	ETF	107.24	107.39	106.54	107.29	11941201.0
2009-10-09 17:00:00	SPY	ETF	107.3	107.36	107.26	107.32	49227.0
2009-10-09 18:00:00	SPY	ETF	107.35	107.39	107.32	107.38	13750.0
2009-10-09 19:00:00	SPY	ETF	107.39	107.4	107.38	107.39	23033.0
2009-10-09 05:00:00	QQQ	ETF	42.11	42.11	42.06	42.06	400.0
2009-10-09 06:00:00	QQQ	ETF	42.11	42.14	42.11	42.14	2100.0
2009-10-09 07:00:00	QQQ	ETF	42.15	42.19	42.13	42.13	107452.0
2009-10-09 08:00:00	QQQ	ETF	42.14	42.16	42.03	42.12	612946.0
2009-10-09 09:00:00	QQQ	ETF	42.13	42.44	42.06	42.4112	14544857.0
2009-10-09 10:00:00	QQQ	ETF	42.42	42.48	42.32	42.4079	8982709.0
2009-10-09 11:00:00	QQQ	ETF	42.4	42.48	42.36	42.39	4692603.0
2009-10-09 12:00:00	QQQ	ETF	42.39	42.43	42.33	42.3999	5112507.0
2009-10-09 13:00:00	QQQ	ETF	42.4	42.48	42.36	42.39	4183420.0
2009-10-09 14:00:00	QQQ	ETF	42.39	42.46	42.35	42.4501	3629882.0
2009-10-09 15:00:00	QQQ	ETF	42.455	42.55	42.39	42.46	15983475.0
2009-10-09 16:00:00	QQQ	ETF	42.46	42.56	42.45	42.51	3706213.0
2009-10-09 17:00:00	QQQ	ETF	42.51	42.53	42.5	42.5	14372.0
2009-10-09 18:00:00	QQQ	ETF	42.5	42.52	42.5	42.52	21380.0
2009-10-09 19:00:00	QQQ	ETF	42.52	42.6	42.51	42.56	10350.0
2009-10-09 06:00:00	IWM	ETF	60.74	60.74	60.74	60.74	177.0
2009-10-09 07:00:00	IWM	ETF	60.83	60.83	60.77	60.77	8600.0
2009-10-09 08:00:00	IWM	ETF	60.8	60.8	60.57	60.74	458202.0
2009-10-09 09:00:00	IWM	ETF	60.75	61.13	60.65	61.13	4895639.0
2009-10-09 10:00:00	IWM	ETF	61.12	61.3	60.96	61.1	6404579.0
2009-10-09 11:00:00	IWM	ETF	61.11	61.195	60.96	61.0	3199839.0
2009-10-09 12:00:00	IWM	ETF	60.9999	61.08	60.89	61.075	1683101.0
2009-10-09 13:00:00	IWM	ETF	61.07	61.2	61.0	61.1	2973444.0
2009-10-09 14:00:00	IWM	ETF	61.1	61.25	60.99	61.248	2358098.0
2009-10-09 15:00:00	IWM	ETF	61.25	61.51	61.22	61.45	9641177.0
2009-10-09 16:00:00	IWM	ETF	61.43	61.5114	61.39	61.46	926099.0
2009-10-09 17:00:00	IWM	ETF	61.43	61.52	61.4	61.52	6546.0
2009-10-09 18:00:00	IWM	ETF	61.47	61.49	61.47	61.49	3900.0
2009-10-09 19:00:00	IWM	ETF	61.52	61.54	61.51	61.52	1200.0
2009-10-09 07:00:00	DIA	ETF	98.03	98.09	98.03	98.03	1400.0
2009-10-09 08:00:00	DIA	ETF	97.93	97.99	97.71	97.95	22546.0
2009-10-09 09:00:00	DIA	ETF	97.93	98.24	97.69	98.2084	1016115.0
2009-10-09 10:00:00	DIA	ETF	98.21	98.33	98.05	98.2301	1528296.0
2009-10-09 11:00:00	DIA	ETF	98.23	98.4	98.16	98.29	679422.0

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

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