PREVIEW / etf_1hour / 2004-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-10.parquet
  size:    25 KB
  rows:    717

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
2004-03-10 08:00:00	SPY	ETF	114.65	114.67	114.49	114.63	72900.0
2004-03-10 09:00:00	SPY	ETF	114.66	114.75	114.4	114.56	3197400.0
2004-03-10 10:00:00	SPY	ETF	114.54	114.75	114.23	114.57	4656000.0
2004-03-10 11:00:00	SPY	ETF	114.56	114.7	114.3	114.38	3171500.0
2004-03-10 12:00:00	SPY	ETF	114.4	114.45	114.21	114.41	2040900.0
2004-03-10 13:00:00	SPY	ETF	114.42	114.42	113.68	113.81	14520100.0
2004-03-10 14:00:00	SPY	ETF	113.8	113.98	113.67	113.74	7681400.0
2004-03-10 15:00:00	SPY	ETF	113.79	113.85	112.79	113.0	14085300.0
2004-03-10 16:00:00	SPY	ETF	112.97	113.02	112.54	112.67	2348500.0
2004-03-10 17:00:00	SPY	ETF	112.67	114.72	112.6	112.6	271700.0
2004-03-10 18:00:00	SPY	ETF	112.6	112.68	112.6	112.66	44200.0
2004-03-10 19:00:00	SPY	ETF	112.65	112.78	112.62	112.72	9000.0
2004-03-10 08:00:00	QQQ	ETF	35.7	35.73	35.66	35.73	195700.0
2004-03-10 09:00:00	QQQ	ETF	35.73	35.84	35.72	35.8	8319400.0
2004-03-10 10:00:00	QQQ	ETF	35.8	35.99	35.66	35.92	12923800.0
2004-03-10 11:00:00	QQQ	ETF	35.92	35.96	35.67	35.74	12121400.0
2004-03-10 12:00:00	QQQ	ETF	35.753	35.79	35.66	35.75	8801500.0
2004-03-10 13:00:00	QQQ	ETF	35.77	35.77	35.4	35.51	21794900.0
2004-03-10 14:00:00	QQQ	ETF	35.5	35.62	35.45	35.51	9033400.0
2004-03-10 15:00:00	QQQ	ETF	35.5	35.55	35.24	35.29	22376500.0
2004-03-10 16:00:00	QQQ	ETF	35.29	35.33	35.13	35.21	6269300.0
2004-03-10 17:00:00	QQQ	ETF	35.2	35.21	35.16	35.19	75000.0
2004-03-10 18:00:00	QQQ	ETF	35.19	35.21	35.17	35.21	46900.0
2004-03-10 19:00:00	QQQ	ETF	35.2	35.21	35.19	35.19	12000.0
2004-03-10 08:00:00	IWM	ETF	58.4	58.475	58.395	58.475	1400.0
2004-03-10 09:00:00	IWM	ETF	58.495	58.59	58.385	58.59	489200.0
2004-03-10 10:00:00	IWM	ETF	58.555	58.88	58.33	58.79	1826000.0
2004-03-10 11:00:00	IWM	ETF	58.785	58.85	58.475	58.505	863000.0
2004-03-10 12:00:00	IWM	ETF	58.575	58.595	58.405	58.55	574400.0
2004-03-10 13:00:00	IWM	ETF	58.575	58.575	57.885	57.935	2801600.0
2004-03-10 14:00:00	IWM	ETF	57.955	58.09	57.85	57.875	1451600.0
2004-03-10 15:00:00	IWM	ETF	57.9	57.955	57.17	57.28	4833600.0
2004-03-10 16:00:00	IWM	ETF	57.275	57.35	57.05	57.16	1073600.0
2004-03-10 17:00:00	IWM	ETF	57.145	57.2	57.125	57.2	7600.0
2004-03-10 08:00:00	DIA	ETF	104.83	104.83	104.71	104.77	5300.0
2004-03-10 09:00:00	DIA	ETF	104.8	104.87	104.54	104.62	645000.0
2004-03-10 10:00:00	DIA	ETF	104.6	104.78	104.33	104.66	559000.0
2004-03-10 11:00:00	DIA	ETF	104.68	104.79	104.46	104.5	686600.0
2004-03-10 12:00:00	DIA	ETF	104.55	104.6	104.4	104.46	354100.0
2004-03-10 13:00:00	DIA	ETF	104.43	104.46	103.84	103.94	1863300.0
2004-03-10 14:00:00	DIA	ETF	103.93	104.11	103.81	103.89	917700.0
2004-03-10 15:00:00	DIA	ETF	103.85	103.91	102.95	103.12	2298900.0
2004-03-10 16:00:00	DIA	ETF	103.12	103.13	102.76	102.84	187900.0
2004-03-10 17:00:00	DIA	ETF	102.86	102.86	102.8	102.8	3300.0
2004-03-10 18:00:00	DIA	ETF	102.86	103.0	102.86	103.0	1300.0
2004-03-10 19:00:00	DIA	ETF	102.96	102.96	102.95	102.95	500.0
2004-03-10 08:00:00	TLT	ETF	90.66	90.66	90.56	90.56	23700.0
2004-03-10 09:00:00	TLT	ETF	90.55	90.6	90.5	90.53	38600.0
2004-03-10 10:00:00	TLT	ETF	90.56	90.66	90.52	90.54	48500.0
2004-03-10 11:00:00	TLT	ETF	90.57	90.83	90.57	90.81	37000.0

> showing 50 of 717 rows — these rows as CSV

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