PREVIEW / etf_1hour / 2005-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-15.parquet
  size:    31 KB
  rows:    919

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
2005-08-15 07:00:00	SPY	ETF	123.29	123.29	123.11	123.15	146000.0
2005-08-15 08:00:00	SPY	ETF	123.13	123.15	123.03	123.06	89100.0
2005-08-15 09:00:00	SPY	ETF	123.09	123.33	123.0	123.12	6024600.0
2005-08-15 10:00:00	SPY	ETF	123.12	123.2	122.83	123.18	6047500.0
2005-08-15 11:00:00	SPY	ETF	123.2	123.29	122.97	123.15	2357600.0
2005-08-15 12:00:00	SPY	ETF	123.14	123.65	123.13	123.52	5919100.0
2005-08-15 13:00:00	SPY	ETF	123.52	123.87	123.5	123.74	5529500.0
2005-08-15 14:00:00	SPY	ETF	123.74	123.85	123.57	123.79	3425800.0
2005-08-15 15:00:00	SPY	ETF	123.82	123.86	123.57	123.65	4506200.0
2005-08-15 16:00:00	SPY	ETF	123.64	123.84	123.59	123.82	711600.0
2005-08-15 17:00:00	SPY	ETF	123.82	123.84	123.8	123.82	6500.0
2005-08-15 18:00:00	SPY	ETF	123.84	123.86	123.82	123.85	4600.0
2005-08-15 19:00:00	SPY	ETF	123.81	123.85	123.81	123.84	1800.0
2005-08-15 09:00:00	QQQ	ETF	39.14	39.22	39.1	39.2	6740000.0
2005-08-15 10:00:00	QQQ	ETF	39.19	39.22	39.08	39.21	8475000.0
2005-08-15 11:00:00	QQQ	ETF	39.21	39.27	39.17	39.22	5337000.0
2005-08-15 12:00:00	QQQ	ETF	39.23	39.57	39.22	39.5	14138800.0
2005-08-15 13:00:00	QQQ	ETF	39.5	39.63	39.47	39.57	8838500.0
2005-08-15 14:00:00	QQQ	ETF	39.57	39.58	39.48	39.54	6210800.0
2005-08-15 15:00:00	QQQ	ETF	39.55	39.56	39.43	39.46	8453000.0
2005-08-15 08:00:00	IWM	ETF	65.56	65.56	65.56	65.56	8400.0
2005-08-15 09:00:00	IWM	ETF	65.56	65.9	65.41	65.51	1930700.0
2005-08-15 10:00:00	IWM	ETF	65.51	65.56	65.25	65.49	3993600.0
2005-08-15 11:00:00	IWM	ETF	65.49	65.7	65.41	65.6	2350500.0
2005-08-15 12:00:00	IWM	ETF	65.6	66.2	65.57	66.12	6146300.0
2005-08-15 13:00:00	IWM	ETF	66.12	66.49	66.04	66.34	2748300.0
2005-08-15 14:00:00	IWM	ETF	66.34	66.37	66.15	66.33	2406900.0
2005-08-15 15:00:00	IWM	ETF	66.33	66.35	66.09	66.22	3537900.0
2005-08-15 16:00:00	IWM	ETF	66.21	66.3	66.19	66.3	44000.0
2005-08-15 17:00:00	IWM	ETF	66.25	66.25	66.25	66.25	400.0
2005-08-15 18:00:00	IWM	ETF	66.24	66.24	66.24	66.24	700.0
2005-08-15 19:00:00	IWM	ETF	66.26	66.26	66.26	66.26	500.0
2005-08-15 08:00:00	DIA	ETF	105.98	105.98	105.98	105.98	100.0
2005-08-15 09:00:00	DIA	ETF	106.05	106.27	105.91	105.99	510600.0
2005-08-15 10:00:00	DIA	ETF	105.99	106.1	105.73	106.02	599500.0
2005-08-15 11:00:00	DIA	ETF	106.02	106.17	105.88	106.02	371300.0
2005-08-15 12:00:00	DIA	ETF	106.03	106.45	106.01	106.32	754100.0
2005-08-15 13:00:00	DIA	ETF	106.33	106.7	106.3	106.58	878100.0
2005-08-15 14:00:00	DIA	ETF	106.6	106.69	106.46	106.65	232100.0
2005-08-15 15:00:00	DIA	ETF	106.66	106.69	106.41	106.5	1273500.0
2005-08-15 16:00:00	DIA	ETF	106.52	106.65	106.52	106.63	102500.0
2005-08-15 08:00:00	GLD	ETF	44.33	44.34	44.31	44.33	9500.0
2005-08-15 09:00:00	GLD	ETF	44.3	44.3	44.14	44.25	340100.0
2005-08-15 10:00:00	GLD	ETF	44.25	44.27	44.1	44.1	162400.0
2005-08-15 11:00:00	GLD	ETF	44.1	44.14	43.98	44.1	561800.0
2005-08-15 12:00:00	GLD	ETF	44.1	44.13	44.06	44.06	76800.0
2005-08-15 13:00:00	GLD	ETF	44.06	44.15	44.06	44.15	73100.0
2005-08-15 14:00:00	GLD	ETF	44.13	44.17	44.094	44.14	131100.0
2005-08-15 15:00:00	GLD	ETF	44.14	44.15	44.09	44.12	168200.0
2005-08-15 16:00:00	GLD	ETF	44.12	44.12	44.12	44.12	100.0

> showing 50 of 919 rows — these rows as CSV

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