PREVIEW / etf_1hour / 2006-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-01.parquet
  size:    40 KB
  rows:    1,232

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
2006-03-01 06:00:00	SPY	ETF	128.64	128.64	128.64	128.64	100.0
2006-03-01 07:00:00	SPY	ETF	128.64	128.67	128.64	128.66	183900.0
2006-03-01 08:00:00	SPY	ETF	128.66	128.7	128.23	128.65	1275700.0
2006-03-01 09:00:00	SPY	ETF	128.63	128.83	128.23	128.77	7323000.0
2006-03-01 10:00:00	SPY	ETF	128.77	128.9	128.5	128.82	8792600.0
2006-03-01 11:00:00	SPY	ETF	128.82	129.22	128.75	129.2	8438500.0
2006-03-01 12:00:00	SPY	ETF	129.2	129.27	129.04	129.15	4680400.0
2006-03-01 13:00:00	SPY	ETF	129.15	129.3	129.08	129.25	4171300.0
2006-03-01 14:00:00	SPY	ETF	129.24	129.36	129.14	129.26	4545000.0
2006-03-01 15:00:00	SPY	ETF	129.26	129.49	129.25	129.39	5840400.0
2006-03-01 16:00:00	SPY	ETF	129.38	129.4	128.955	129.29	925700.0
2006-03-01 17:00:00	SPY	ETF	129.3	129.35	129.28	129.35	4100.0
2006-03-01 18:00:00	SPY	ETF	129.31	129.31	129.28	129.3	6800.0
2006-03-01 19:00:00	SPY	ETF	129.28	129.29	129.27	129.27	18600.0
2006-03-01 09:00:00	QQQ	ETF	41.21	41.33	41.19	41.3	10525100.0
2006-03-01 10:00:00	QQQ	ETF	41.29	41.44	41.15	41.38	16321000.0
2006-03-01 11:00:00	QQQ	ETF	41.38	41.62	41.36	41.61	11796600.0
2006-03-01 12:00:00	QQQ	ETF	41.61	41.67	41.56	41.61	6411800.0
2006-03-01 13:00:00	QQQ	ETF	41.6	41.64	41.55	41.61	8402600.0
2006-03-01 14:00:00	QQQ	ETF	41.61	41.73	41.57	41.69	10544600.0
2006-03-01 15:00:00	QQQ	ETF	41.7	41.77	41.64	41.66	12408000.0
2006-03-01 07:00:00	IWM	ETF	72.04	72.04	72.04	72.04	1000.0
2006-03-01 08:00:00	IWM	ETF	72.71	72.8	72.58	72.76	310500.0
2006-03-01 09:00:00	IWM	ETF	72.75	72.91	72.58	72.77	2600900.0
2006-03-01 10:00:00	IWM	ETF	72.76	73.17	72.62	73.05	5891100.0
2006-03-01 11:00:00	IWM	ETF	73.06	73.49	73.06	73.49	4361700.0
2006-03-01 12:00:00	IWM	ETF	73.49	73.52	73.37	73.51	1984400.0
2006-03-01 13:00:00	IWM	ETF	73.51	73.62	73.42	73.61	2603800.0
2006-03-01 14:00:00	IWM	ETF	73.62	73.77	73.55	73.69	3456800.0
2006-03-01 15:00:00	IWM	ETF	73.69	73.83	73.68	73.79	4233900.0
2006-03-01 16:00:00	IWM	ETF	73.76	73.92	73.76	73.86	256800.0
2006-03-01 17:00:00	IWM	ETF	73.89	73.89	73.89	73.89	600.0
2006-03-01 07:00:00	DIA	ETF	110.25	110.25	110.25	110.25	300.0
2006-03-01 08:00:00	DIA	ETF	110.21	110.3	109.73	110.3	4700.0
2006-03-01 09:00:00	DIA	ETF	110.17	110.38	110.17	110.33	608700.0
2006-03-01 10:00:00	DIA	ETF	110.32	110.41	110.09	110.34	685600.0
2006-03-01 11:00:00	DIA	ETF	110.35	110.65	110.29	110.64	1115200.0
2006-03-01 12:00:00	DIA	ETF	110.63	110.74	110.52	110.59	791000.0
2006-03-01 13:00:00	DIA	ETF	110.59	110.64	110.5	110.63	336900.0
2006-03-01 14:00:00	DIA	ETF	110.631	110.69	110.5	110.57	408500.0
2006-03-01 15:00:00	DIA	ETF	110.57	110.7	110.46	110.51	735100.0
2006-03-01 16:00:00	DIA	ETF	110.5	110.53	110.46	110.46	10100.0
2006-03-01 17:00:00	DIA	ETF	110.52	110.52	110.52	110.52	400.0
2006-03-01 18:00:00	DIA	ETF	110.46	110.46	110.46	110.46	400.0
2006-03-01 07:00:00	GLD	ETF	56.06	56.06	56.01	56.02	4000.0
2006-03-01 08:00:00	GLD	ETF	56.06	56.12	55.88	56.0	55600.0
2006-03-01 09:00:00	GLD	ETF	56.03	56.25	55.9	56.11	1001600.0
2006-03-01 10:00:00	GLD	ETF	56.1	56.33	56.02	56.19	813300.0
2006-03-01 11:00:00	GLD	ETF	56.21	56.42	55.92	55.92	1083100.0
2006-03-01 12:00:00	GLD	ETF	55.92	56.22	55.92	56.18	207500.0

> showing 50 of 1,232 rows — these rows as CSV

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