PREVIEW / etf_1hour / 2005-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-28.parquet
  size:    30 KB
  rows:    874

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-04-28 04:00:00	SPY	ETF	115.6	115.62	115.6	115.62	3800.0
2005-04-28 05:00:00	SPY	ETF	115.62	115.62	115.6	115.6	5400.0
2005-04-28 06:00:00	SPY	ETF	115.34	115.34	115.34	115.34	400.0
2005-04-28 07:00:00	SPY	ETF	115.34	115.52	115.33	115.45	126300.0
2005-04-28 08:00:00	SPY	ETF	115.44	115.68	115.19	115.26	1208500.0
2005-04-28 09:00:00	SPY	ETF	115.28	115.45	114.83	114.95	7532700.0
2005-04-28 10:00:00	SPY	ETF	114.95	115.68	114.89	115.27	12905600.0
2005-04-28 11:00:00	SPY	ETF	115.31	115.44	115.0	115.068	6090500.0
2005-04-28 12:00:00	SPY	ETF	115.05	115.43	114.85	115.09	5215900.0
2005-04-28 13:00:00	SPY	ETF	115.1	115.35	114.9	115.32	5379500.0
2005-04-28 14:00:00	SPY	ETF	115.32	115.35	114.47	114.79	15568300.0
2005-04-28 15:00:00	SPY	ETF	114.78	114.87	114.35	114.4	13803400.0
2005-04-28 16:00:00	SPY	ETF	114.35	114.878	114.06	114.29	2943500.0
2005-04-28 17:00:00	SPY	ETF	114.3	114.32	114.15	114.16	107300.0
2005-04-28 18:00:00	SPY	ETF	114.19	114.23	114.18	114.21	56500.0
2005-04-28 19:00:00	SPY	ETF	114.23	114.24	114.23	114.24	1300.0
2005-04-28 09:00:00	QQQ	ETF	34.92	35.07	34.87	34.93	14536200.0
2005-04-28 10:00:00	QQQ	ETF	34.93	35.15	34.85	34.97	15504800.0
2005-04-28 11:00:00	QQQ	ETF	34.97	35.05	34.83	34.87	11674300.0
2005-04-28 12:00:00	QQQ	ETF	34.87	34.97	34.8	34.91	6924600.0
2005-04-28 13:00:00	QQQ	ETF	34.91	35.91	34.83	35.01	6310900.0
2005-04-28 14:00:00	QQQ	ETF	35.02	35.05	34.72	34.82	17544400.0
2005-04-28 15:00:00	QQQ	ETF	34.82	34.85	34.72	34.75	15899700.0
2005-04-28 08:00:00	IWM	ETF	58.21	58.21	58.025	58.055	28200.0
2005-04-28 09:00:00	IWM	ETF	58.025	58.15	57.695	57.781	2595000.0
2005-04-28 10:00:00	IWM	ETF	57.78	58.15	57.68	57.83	4738400.0
2005-04-28 11:00:00	IWM	ETF	57.825	57.99	57.595	57.67	3630400.0
2005-04-28 12:00:00	IWM	ETF	57.67	57.735	57.555	57.705	1800800.0
2005-04-28 13:00:00	IWM	ETF	57.7	57.795	57.5	57.76	1675200.0
2005-04-28 14:00:00	IWM	ETF	57.785	57.795	57.31	57.435	6542600.0
2005-04-28 15:00:00	IWM	ETF	57.43	57.545	57.095	57.135	5966000.0
2005-04-28 16:00:00	IWM	ETF	57.11	57.16	56.87	57.05	952200.0
2005-04-28 17:00:00	IWM	ETF	57.01	57.01	57.01	57.01	200.0
2005-04-28 19:00:00	IWM	ETF	56.98	57.0	56.98	57.0	1200.0
2005-04-28 08:00:00	DIA	ETF	101.7	101.86	101.5	101.53	27000.0
2005-04-28 09:00:00	DIA	ETF	101.53	101.72	101.2	101.31	962200.0
2005-04-28 10:00:00	DIA	ETF	101.29	101.83	101.24	101.52	1028400.0
2005-04-28 11:00:00	DIA	ETF	101.49	101.62	101.3	101.33	372900.0
2005-04-28 12:00:00	DIA	ETF	101.33	101.76	101.2	101.35	897100.0
2005-04-28 13:00:00	DIA	ETF	101.36	101.59	101.2	101.59	663900.0
2005-04-28 14:00:00	DIA	ETF	101.6	101.63	100.71	100.97	1879800.0
2005-04-28 15:00:00	DIA	ETF	100.97	101.06	100.67	100.7	975300.0
2005-04-28 16:00:00	DIA	ETF	100.7	100.71	100.41	100.6	46700.0
2005-04-28 17:00:00	DIA	ETF	100.6	100.7	100.54	100.7	1500.0
2005-04-28 18:00:00	DIA	ETF	100.6	100.6	100.6	100.6	100.0
2005-04-28 19:00:00	DIA	ETF	100.6	100.64	100.6	100.64	300.0
2005-04-28 08:00:00	GLD	ETF	43.12	43.33	43.12	43.24	48800.0
2005-04-28 09:00:00	GLD	ETF	43.19	43.26	43.07	43.23	194200.0
2005-04-28 10:00:00	GLD	ETF	43.21	43.27	43.15	43.2	234400.0
2005-04-28 11:00:00	GLD	ETF	43.24	43.24	43.02	43.1	952100.0

> showing 50 of 874 rows — these rows as CSV

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