PREVIEW / etf_1hour / 2006-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-27.parquet
  size:    53 KB
  rows:    1,666

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-09-27 04:00:00	SPY	ETF	133.64	133.64	133.64	133.64	100.0
2006-09-27 07:00:00	SPY	ETF	133.72	133.82	133.72	133.8	175900.0
2006-09-27 08:00:00	SPY	ETF	133.74	133.83	133.33	133.34	2072000.0
2006-09-27 09:00:00	SPY	ETF	133.34	133.79	133.29	133.69	11446900.0
2006-09-27 10:00:00	SPY	ETF	133.68	133.95	133.4	133.65	14235100.0
2006-09-27 11:00:00	SPY	ETF	133.69	133.92	133.5	133.86	9009600.0
2006-09-27 12:00:00	SPY	ETF	133.86	133.97	133.63	133.75	4354100.0
2006-09-27 13:00:00	SPY	ETF	133.75	133.9	133.55	133.73	6415600.0
2006-09-27 14:00:00	SPY	ETF	133.71	133.81	133.3	133.53	14193500.0
2006-09-27 15:00:00	SPY	ETF	133.53	133.69	133.27	133.6302	12393000.0
2006-09-27 16:00:00	SPY	ETF	133.66	133.75	133.43	133.66	1760300.0
2006-09-27 17:00:00	SPY	ETF	133.7	133.72	133.6	133.7	444600.0
2006-09-27 18:00:00	SPY	ETF	133.7	133.7	133.67	133.67	800.0
2006-09-27 19:00:00	SPY	ETF	133.68	133.68	133.68	133.68	400.0
2006-09-27 09:00:00	QQQ	ETF	40.7	40.85	40.66	40.81	12226600.0
2006-09-27 10:00:00	QQQ	ETF	40.81	40.95	40.67	40.83	26859000.0
2006-09-27 11:00:00	QQQ	ETF	40.83	40.92	40.74	40.89	12125100.0
2006-09-27 12:00:00	QQQ	ETF	40.9	40.94	40.77	40.8	8576900.0
2006-09-27 13:00:00	QQQ	ETF	40.81	40.85	40.67	40.75	12430700.0
2006-09-27 14:00:00	QQQ	ETF	40.76	40.8	40.51	40.6	13136800.0
2006-09-27 15:00:00	QQQ	ETF	40.61	40.77	40.5	40.71	15871200.0
2006-09-27 07:00:00	IWM	ETF	72.45	72.51	72.45	72.51	4500.0
2006-09-27 08:00:00	IWM	ETF	72.48	72.56	72.11	72.17	358800.0
2006-09-27 09:00:00	IWM	ETF	72.17	72.74	72.11	72.59	4877600.0
2006-09-27 10:00:00	IWM	ETF	72.59	72.96	72.47	72.71	6961200.0
2006-09-27 11:00:00	IWM	ETF	72.71	72.92	72.55	72.86	4784800.0
2006-09-27 12:00:00	IWM	ETF	72.87	72.96	72.73	72.83	3267200.0
2006-09-27 13:00:00	IWM	ETF	72.83	72.89	72.54	72.78	4042000.0
2006-09-27 14:00:00	IWM	ETF	72.7886	72.89	72.43	72.63	5135700.0
2006-09-27 15:00:00	IWM	ETF	72.63	72.81	72.4	72.79	5702600.0
2006-09-27 16:00:00	IWM	ETF	72.8	72.99	72.79	72.89	299500.0
2006-09-27 17:00:00	IWM	ETF	72.93	72.96	72.93	72.95	9600.0
2006-09-27 07:00:00	DIA	ETF	116.8	116.8	116.8	116.8	300.0
2006-09-27 08:00:00	DIA	ETF	116.75	116.8	116.43	116.49	115400.0
2006-09-27 09:00:00	DIA	ETF	116.49	116.92	116.45	116.8598	3104200.0
2006-09-27 10:00:00	DIA	ETF	116.84	117.11	116.72	117.0	1975400.0
2006-09-27 11:00:00	DIA	ETF	117.0	117.09	116.83	117.04	1423800.0
2006-09-27 12:00:00	DIA	ETF	117.05	117.11	116.8	116.92	660000.0
2006-09-27 13:00:00	DIA	ETF	116.93	117.08	116.78	116.92	1710600.0
2006-09-27 14:00:00	DIA	ETF	116.9281	116.96	116.48	116.75	1649000.0
2006-09-27 15:00:00	DIA	ETF	116.76	116.9	116.53	116.87	1152600.0
2006-09-27 16:00:00	DIA	ETF	116.86	116.99	116.86	116.93	32500.0
2006-09-27 18:00:00	DIA	ETF	116.9	116.9	116.9	116.9	500.0
2006-09-27 19:00:00	DIA	ETF	116.92	116.92	116.92	116.92	200.0
2006-09-27 07:00:00	GLD	ETF	59.44	59.45	59.1	59.1	50000.0
2006-09-27 08:00:00	GLD	ETF	59.08	59.25	59.05	59.16	81300.0
2006-09-27 09:00:00	GLD	ETF	59.15	59.27	58.99	59.06	581600.0
2006-09-27 10:00:00	GLD	ETF	59.07	59.14	58.79	58.92	826900.0
2006-09-27 11:00:00	GLD	ETF	58.92	59.08	58.73	58.94	493700.0
2006-09-27 12:00:00	GLD	ETF	58.94	59.25	58.91	59.19	554000.0

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

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