PREVIEW / etf_1hour / 2006-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-30.parquet
  size:    49 KB
  rows:    1,608

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-08-30 04:00:00	SPY	ETF	130.69	130.72	130.69	130.72	1300.0
2006-08-30 07:00:00	SPY	ETF	130.74	130.81	130.69	130.69	137200.0
2006-08-30 08:00:00	SPY	ETF	130.71	130.88	130.58	130.79	1010300.0
2006-08-30 09:00:00	SPY	ETF	130.81	130.94	130.59	130.64	7732100.0
2006-08-30 10:00:00	SPY	ETF	130.63	131.04	130.6	130.87	11440400.0
2006-08-30 11:00:00	SPY	ETF	130.87	130.92	130.6	130.68	4756800.0
2006-08-30 12:00:00	SPY	ETF	130.68	130.89	130.55	130.75	5624600.0
2006-08-30 13:00:00	SPY	ETF	130.75	130.89	130.64	130.83	4485900.0
2006-08-30 14:00:00	SPY	ETF	130.82	130.89	130.62	130.76	4117600.0
2006-08-30 15:00:00	SPY	ETF	130.77	130.95	130.74	130.74	9156400.0
2006-08-30 16:00:00	SPY	ETF	130.75	130.89	130.64	130.72	618200.0
2006-08-30 17:00:00	SPY	ETF	130.71	130.76	130.68	130.76	12900.0
2006-08-30 18:00:00	SPY	ETF	130.76	130.76	130.7	130.7	1500.0
2006-08-30 19:00:00	SPY	ETF	130.74	130.75	130.74	130.74	2700.0
2006-08-30 09:00:00	QQQ	ETF	38.74	38.79	38.6	38.66	11584300.0
2006-08-30 10:00:00	QQQ	ETF	38.66	38.9	38.66	38.84	15069500.0
2006-08-30 11:00:00	QQQ	ETF	38.85	38.89	38.69	38.75	9440800.0
2006-08-30 12:00:00	QQQ	ETF	38.75	38.88	38.72	38.85	5722700.0
2006-08-30 13:00:00	QQQ	ETF	38.84	39.03	38.8	38.84	8545500.0
2006-08-30 14:00:00	QQQ	ETF	38.85	38.89	38.74	38.83	6980300.0
2006-08-30 15:00:00	QQQ	ETF	38.82	38.96	38.81	38.91	11979800.0
2006-08-30 08:00:00	IWM	ETF	71.28	71.39	71.28	71.34	544600.0
2006-08-30 09:00:00	IWM	ETF	71.33	71.42	71.04	71.13	3250000.0
2006-08-30 10:00:00	IWM	ETF	71.11	71.8	71.09	71.74	10984700.0
2006-08-30 11:00:00	IWM	ETF	71.74	72.0	71.48	71.6	5449700.0
2006-08-30 12:00:00	IWM	ETF	71.6	71.83	71.5	71.77	2605100.0
2006-08-30 13:00:00	IWM	ETF	71.76	71.91	71.68	71.81	4691100.0
2006-08-30 14:00:00	IWM	ETF	71.81	71.84	71.51	71.63	6239000.0
2006-08-30 15:00:00	IWM	ETF	71.63	71.95	71.61	71.71	5603500.0
2006-08-30 16:00:00	IWM	ETF	71.71	71.88	71.12	71.82	456300.0
2006-08-30 17:00:00	IWM	ETF	71.85	71.85	71.82	71.82	6900.0
2006-08-30 18:00:00	IWM	ETF	71.79	71.79	71.79	71.79	200.0
2006-08-30 19:00:00	IWM	ETF	71.85	71.85	71.85	71.85	1000.0
2006-08-30 08:00:00	DIA	ETF	113.65	113.75	113.64	113.72	11000.0
2006-08-30 09:00:00	DIA	ETF	113.73	113.85	113.56	113.59	624200.0
2006-08-30 10:00:00	DIA	ETF	113.58	114.07	113.57	113.92	1120000.0
2006-08-30 11:00:00	DIA	ETF	113.92	113.96	113.65	113.71	560200.0
2006-08-30 12:00:00	DIA	ETF	113.71	113.83	113.63	113.77	299900.0
2006-08-30 13:00:00	DIA	ETF	113.78	113.9	113.71	113.85	319700.0
2006-08-30 14:00:00	DIA	ETF	113.86	113.87	113.65	113.78	524500.0
2006-08-30 15:00:00	DIA	ETF	113.8	113.96	113.77	113.82	658800.0
2006-08-30 16:00:00	DIA	ETF	113.826	113.85	113.7	113.73	47100.0
2006-08-30 08:00:00	GLD	ETF	60.96	61.34	60.94	61.34	41000.0
2006-08-30 09:00:00	GLD	ETF	61.31	61.69	61.31	61.45	494600.0
2006-08-30 10:00:00	GLD	ETF	61.44	61.56	61.22	61.45	876600.0
2006-08-30 11:00:00	GLD	ETF	61.46	61.49	61.26	61.27	398000.0
2006-08-30 12:00:00	GLD	ETF	61.28	61.61	61.0901	61.14	380600.0
2006-08-30 13:00:00	GLD	ETF	61.12	61.38	61.12	61.38	265800.0
2006-08-30 14:00:00	GLD	ETF	61.38	61.45	61.34	61.4	240200.0
2006-08-30 15:00:00	GLD	ETF	61.3988	61.43	61.38	61.43	195700.0

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

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