PREVIEW / etf_1hour / 2006-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-27.parquet
  size:    58 KB
  rows:    1,837

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-12-27 04:00:00	SPY	ETF	142.1	142.1	142.09	142.09	1700.0
2006-12-27 06:00:00	SPY	ETF	142.17	142.17	142.06	142.06	85000.0
2006-12-27 07:00:00	SPY	ETF	142.1	142.13	142.01	142.01	21100.0
2006-12-27 08:00:00	SPY	ETF	142.03	142.1	141.95	142.0	391200.0
2006-12-27 09:00:00	SPY	ETF	142.02	142.34	141.83	142.13	6739700.0
2006-12-27 10:00:00	SPY	ETF	142.13	142.25	141.97	142.17	8787100.0
2006-12-27 11:00:00	SPY	ETF	142.17	142.3	142.15	142.21	3517800.0
2006-12-27 12:00:00	SPY	ETF	142.21	142.26	142.15	142.17	2311300.0
2006-12-27 13:00:00	SPY	ETF	142.17	142.31	142.16	142.3	1697700.0
2006-12-27 14:00:00	SPY	ETF	142.29	142.46	142.28	142.43	4953100.0
2006-12-27 15:00:00	SPY	ETF	142.438	142.6	142.42	142.59	5649500.0
2006-12-27 16:00:00	SPY	ETF	142.6	142.6	142.42	142.44	2636200.0
2006-12-27 17:00:00	SPY	ETF	142.46	142.51	142.29	142.38	778700.0
2006-12-27 18:00:00	SPY	ETF	142.45	142.45	142.42	142.43	6600.0
2006-12-27 19:00:00	SPY	ETF	142.45	142.46	142.45	142.45	2300.0
2006-12-27 09:00:00	QQQ	ETF	43.19	43.35	43.16	43.27	10736900.0
2006-12-27 10:00:00	QQQ	ETF	43.26	43.31	43.1	43.23	11396000.0
2006-12-27 11:00:00	QQQ	ETF	43.23	43.33	43.21	43.28	6046400.0
2006-12-27 12:00:00	QQQ	ETF	43.28	43.35	43.27	43.31	4526600.0
2006-12-27 13:00:00	QQQ	ETF	43.31	43.35	43.28	43.33	4449000.0
2006-12-27 14:00:00	QQQ	ETF	43.34	43.38	43.3	43.35	5367900.0
2006-12-27 15:00:00	QQQ	ETF	43.35	43.4	43.32	43.34	7410900.0
2006-12-27 08:00:00	IWM	ETF	78.52	78.54	78.41	78.45	120200.0
2006-12-27 09:00:00	IWM	ETF	78.44	78.93	78.35	78.76	8857400.0
2006-12-27 10:00:00	IWM	ETF	78.76	78.92	78.58	78.87	8814700.0
2006-12-27 11:00:00	IWM	ETF	78.87	78.98	78.83	78.87	5267700.0
2006-12-27 12:00:00	IWM	ETF	78.87	78.93	78.81	78.88	3020200.0
2006-12-27 13:00:00	IWM	ETF	78.87	78.9	78.79	78.9	1988600.0
2006-12-27 14:00:00	IWM	ETF	78.89	79.09	78.85	79.05	4755900.0
2006-12-27 15:00:00	IWM	ETF	79.06	79.15	78.99	79.15	5295500.0
2006-12-27 16:00:00	IWM	ETF	79.16	79.17	79.05	79.05	376300.0
2006-12-27 17:00:00	IWM	ETF	79.05	79.05	79.05	79.05	100.0
2006-12-27 19:00:00	IWM	ETF	79.15	79.15	79.09	79.09	4500.0
2006-12-27 08:00:00	DIA	ETF	124.4	124.44	124.39	124.43	34800.0
2006-12-27 09:00:00	DIA	ETF	124.41	124.71	124.25	124.58	1217400.0
2006-12-27 10:00:00	DIA	ETF	124.59	124.74	124.52	124.72	1502700.0
2006-12-27 11:00:00	DIA	ETF	124.72	124.77	124.62	124.67	550000.0
2006-12-27 12:00:00	DIA	ETF	124.66	124.71	124.61	124.64	390200.0
2006-12-27 13:00:00	DIA	ETF	124.64	124.74	124.62	124.74	224300.0
2006-12-27 14:00:00	DIA	ETF	124.74	124.85	124.73	124.82	871100.0
2006-12-27 15:00:00	DIA	ETF	124.82	124.99	124.82	124.97	846700.0
2006-12-27 16:00:00	DIA	ETF	124.99	124.99	124.88	124.88	23200.0
2006-12-27 17:00:00	DIA	ETF	124.88	124.88	124.88	124.88	1000.0
2006-12-27 19:00:00	DIA	ETF	124.88	124.88	124.88	124.88	100.0
2006-12-27 07:00:00	GLD	ETF	62.22	62.22	62.22	62.22	2000.0
2006-12-27 08:00:00	GLD	ETF	62.31	62.32	62.2	62.22	25400.0
2006-12-27 09:00:00	GLD	ETF	62.2	62.46	62.2	62.39	499900.0
2006-12-27 10:00:00	GLD	ETF	62.39	62.4	62.21	62.25	837800.0
2006-12-27 11:00:00	GLD	ETF	62.2328	62.37	62.17	62.32	499000.0
2006-12-27 12:00:00	GLD	ETF	62.3	62.36	62.25	62.25	247500.0

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

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