PREVIEW / etf_1hour / 2006-01-27

all etf 1-hour files

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

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-01-27 04:00:00	SPY	ETF	127.82	127.82	127.75	127.75	50100.0
2006-01-27 06:00:00	SPY	ETF	127.77	127.77	127.77	127.77	100.0
2006-01-27 07:00:00	SPY	ETF	127.79	127.86	127.74	127.83	118900.0
2006-01-27 08:00:00	SPY	ETF	127.86	127.95	127.36	127.47	2364200.0
2006-01-27 09:00:00	SPY	ETF	127.44	127.93	127.43	127.91	8116300.0
2006-01-27 10:00:00	SPY	ETF	127.88	128.63	127.86	128.34	19436200.0
2006-01-27 11:00:00	SPY	ETF	128.33	128.56	128.25	128.45	5233300.0
2006-01-27 12:00:00	SPY	ETF	128.45	128.66	128.42	128.48	5479200.0
2006-01-27 13:00:00	SPY	ETF	128.48	128.54	127.93	128.14	7956400.0
2006-01-27 14:00:00	SPY	ETF	128.16	128.3	128.05	128.29	4784600.0
2006-01-27 15:00:00	SPY	ETF	128.29	128.48	128.21	128.32	9274800.0
2006-01-27 16:00:00	SPY	ETF	128.3	128.58	128.3	128.54	789500.0
2006-01-27 17:00:00	SPY	ETF	128.57	128.65	128.53	128.54	21400.0
2006-01-27 18:00:00	SPY	ETF	128.53	128.53	128.4	128.4	23400.0
2006-01-27 09:00:00	QQQ	ETF	41.81	42.09	41.74	42.06	21871100.0
2006-01-27 10:00:00	QQQ	ETF	42.05	42.39	42.03	42.15	24955900.0
2006-01-27 11:00:00	QQQ	ETF	42.15	42.2	42.05	42.16	8681800.0
2006-01-27 12:00:00	QQQ	ETF	42.16	42.23	42.12	42.15	5148500.0
2006-01-27 13:00:00	QQQ	ETF	42.14	42.15	41.87	41.92	11251300.0
2006-01-27 14:00:00	QQQ	ETF	41.92	42.02	41.89	41.96	9485300.0
2006-01-27 15:00:00	QQQ	ETF	41.97	42.11	41.94	42.1	13310700.0
2006-01-27 06:00:00	IWM	ETF	72.7	72.7	72.7	72.7	100.0
2006-01-27 07:00:00	IWM	ETF	72.66	72.7	72.66	72.7	23600.0
2006-01-27 08:00:00	IWM	ETF	72.72	72.81	72.46	72.53	245000.0
2006-01-27 09:00:00	IWM	ETF	72.52	72.67	72.26	72.64	2973700.0
2006-01-27 10:00:00	IWM	ETF	72.64	73.24	72.62	72.98	9195400.0
2006-01-27 11:00:00	IWM	ETF	72.98	73.01	72.82	72.91	3023900.0
2006-01-27 12:00:00	IWM	ETF	72.92	72.96	72.75	72.79	2044800.0
2006-01-27 13:00:00	IWM	ETF	72.8	72.8	72.45	72.46	3720500.0
2006-01-27 14:00:00	IWM	ETF	72.46	72.75	72.45	72.69	2829600.0
2006-01-27 15:00:00	IWM	ETF	72.69	72.79	72.63	72.65	3696100.0
2006-01-27 16:00:00	IWM	ETF	72.65	72.85	72.63	72.68	145200.0
2006-01-27 07:00:00	DIA	ETF	108.4	108.4	108.36	108.36	9500.0
2006-01-27 08:00:00	DIA	ETF	108.42	108.47	108.08	108.16	44900.0
2006-01-27 09:00:00	DIA	ETF	108.12	108.33	107.97	108.27	1320400.0
2006-01-27 10:00:00	DIA	ETF	108.26	108.97	108.25	108.8	1692000.0
2006-01-27 11:00:00	DIA	ETF	108.8	109.16	108.73	109.1112	858000.0
2006-01-27 12:00:00	DIA	ETF	109.11	109.27	109.08	109.1	570000.0
2006-01-27 13:00:00	DIA	ETF	109.1	109.11	108.66	108.83	1198700.0
2006-01-27 14:00:00	DIA	ETF	108.84	109.0	108.76	108.94	884600.0
2006-01-27 15:00:00	DIA	ETF	108.94	109.15	108.9	108.93	1035800.0
2006-01-27 16:00:00	DIA	ETF	108.94	109.15	108.92	109.15	212100.0
2006-01-27 17:00:00	DIA	ETF	109.15	109.15	109.15	109.15	500.0
2006-01-27 08:00:00	GLD	ETF	56.09	56.25	55.86	56.13	74400.0
2006-01-27 09:00:00	GLD	ETF	56.11	56.23	55.8	56.14	856600.0
2006-01-27 10:00:00	GLD	ETF	56.14	56.14	55.47	55.57	1307700.0
2006-01-27 11:00:00	GLD	ETF	55.58	55.8	55.53	55.65	503500.0
2006-01-27 12:00:00	GLD	ETF	55.66	55.74	55.56	55.7	266100.0
2006-01-27 13:00:00	GLD	ETF	55.69	55.76	55.65	55.73	362000.0
2006-01-27 14:00:00	GLD	ETF	55.71	55.78	55.55	55.66	310900.0

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

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