PREVIEW / etf_1hour / 2005-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-18.parquet
  size:    29 KB
  rows:    921

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
2005-07-18 07:00:00	SPY	ETF	122.6	122.61	122.56	122.6	17400.0
2005-07-18 08:00:00	SPY	ETF	122.57	122.63	122.57	122.6	197200.0
2005-07-18 09:00:00	SPY	ETF	122.58	122.63	122.33	122.39	9910500.0
2005-07-18 10:00:00	SPY	ETF	122.38	122.63	122.2	122.47	18135000.0
2005-07-18 11:00:00	SPY	ETF	122.46	122.62	122.35	122.44	4516000.0
2005-07-18 12:00:00	SPY	ETF	122.43	122.5	122.3	122.46	2072200.0
2005-07-18 13:00:00	SPY	ETF	122.47	122.57	122.27	122.44	2354300.0
2005-07-18 14:00:00	SPY	ETF	122.46	122.52	122.27	122.35	4873200.0
2005-07-18 15:00:00	SPY	ETF	122.36	122.42	122.05	122.17	6733100.0
2005-07-18 16:00:00	SPY	ETF	122.2	122.55	122.1	122.55	2795800.0
2005-07-18 17:00:00	SPY	ETF	122.53	122.56	122.52	122.53	37500.0
2005-07-18 18:00:00	SPY	ETF	122.53	122.54	122.49	122.49	108300.0
2005-07-18 19:00:00	SPY	ETF	122.48	122.52	122.48	122.48	3500.0
2005-07-18 09:00:00	QQQ	ETF	38.78	38.83	38.69	38.75	9826900.0
2005-07-18 10:00:00	QQQ	ETF	38.74	38.89	38.69	38.77	14232700.0
2005-07-18 11:00:00	QQQ	ETF	38.77	38.83	38.71	38.73	5961800.0
2005-07-18 12:00:00	QQQ	ETF	38.73	38.8	38.69	38.79	7282300.0
2005-07-18 13:00:00	QQQ	ETF	38.78	38.82	38.7	38.78	5795000.0
2005-07-18 14:00:00	QQQ	ETF	38.79	38.8	38.71	38.74	3661300.0
2005-07-18 15:00:00	QQQ	ETF	38.74	38.8	38.71	38.72	7568400.0
2005-07-18 08:00:00	IWM	ETF	65.95	65.95	65.86	65.89	60800.0
2005-07-18 09:00:00	IWM	ETF	65.93	66.08	65.59	65.69	3698200.0
2005-07-18 10:00:00	IWM	ETF	65.67	65.78	65.43	65.5	2045100.0
2005-07-18 11:00:00	IWM	ETF	65.51	65.72	65.43	65.54	1677700.0
2005-07-18 12:00:00	IWM	ETF	65.54	65.61	65.37	65.6	1356300.0
2005-07-18 13:00:00	IWM	ETF	65.61	65.83	65.51	65.74	1384400.0
2005-07-18 14:00:00	IWM	ETF	65.75	65.81	65.67	65.77	1161800.0
2005-07-18 15:00:00	IWM	ETF	65.77	65.8	65.48	65.48	2524800.0
2005-07-18 16:00:00	IWM	ETF	65.48	65.73	65.46	65.72	198100.0
2005-07-18 17:00:00	IWM	ETF	65.73	65.73	65.65	65.65	600.0
2005-07-18 18:00:00	IWM	ETF	65.65	65.65	65.65	65.65	800.0
2005-07-18 08:00:00	DIA	ETF	106.09	106.1	106.09	106.1	2200.0
2005-07-18 09:00:00	DIA	ETF	106.06	106.12	105.86	105.96	1743300.0
2005-07-18 10:00:00	DIA	ETF	105.95	106.25	105.82	106.09	879900.0
2005-07-18 11:00:00	DIA	ETF	106.06	106.25	106.04	106.15	362900.0
2005-07-18 12:00:00	DIA	ETF	106.13	106.19	106.03	106.13	670000.0
2005-07-18 13:00:00	DIA	ETF	106.14	106.14	105.92	106.0	538900.0
2005-07-18 14:00:00	DIA	ETF	106.0	106.03	105.8	105.89	480000.0
2005-07-18 15:00:00	DIA	ETF	105.88	105.92	105.66	105.73	1105500.0
2005-07-18 16:00:00	DIA	ETF	105.72	106.15	105.65	106.15	217400.0
2005-07-18 17:00:00	DIA	ETF	106.11	106.13	106.11	106.13	1000.0
2005-07-18 19:00:00	DIA	ETF	106.1	106.1	106.1	106.1	100.0
2005-07-18 08:00:00	GLD	ETF	42.03	42.03	41.98	41.98	1000.0
2005-07-18 09:00:00	GLD	ETF	41.95	42.03	41.94	42.0	304900.0
2005-07-18 10:00:00	GLD	ETF	41.97	42.05	41.95	42.04	284200.0
2005-07-18 11:00:00	GLD	ETF	42.04	42.17	42.02	42.14	136400.0
2005-07-18 12:00:00	GLD	ETF	42.14	42.16	42.11	42.13	79800.0
2005-07-18 13:00:00	GLD	ETF	42.13	42.13	41.98	42.01	65900.0
2005-07-18 14:00:00	GLD	ETF	42.02	42.03	41.96	41.98	50500.0
2005-07-18 15:00:00	GLD	ETF	41.98	42.01	41.97	41.98	33200.0

> showing 50 of 921 rows — these rows as CSV

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