PREVIEW / etf_1hour / 2004-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-09.parquet
  size:    28 KB
  rows:    776

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-12-09 08:00:00	SPY	ETF	118.31	118.31	118.07	118.08	299600.0
2004-12-09 09:00:00	SPY	ETF	118.13	118.26	118.01	118.16	5669900.0
2004-12-09 10:00:00	SPY	ETF	118.17	118.25	117.73	117.93	13250400.0
2004-12-09 11:00:00	SPY	ETF	117.93	118.07	117.82	118.0	5092900.0
2004-12-09 12:00:00	SPY	ETF	118.0	118.58	117.99	118.48	8296600.0
2004-12-09 13:00:00	SPY	ETF	118.48	119.04	118.44	118.89	9135200.0
2004-12-09 14:00:00	SPY	ETF	118.89	119.1	118.57	119.08	5066900.0
2004-12-09 15:00:00	SPY	ETF	119.08	119.46	119.0	119.3	9490900.0
2004-12-09 16:00:00	SPY	ETF	119.32	119.33	119.17	119.29	2574500.0
2004-12-09 17:00:00	SPY	ETF	119.26	119.3	119.23	119.28	36600.0
2004-12-09 18:00:00	SPY	ETF	119.27	119.29	119.25	119.26	2600.0
2004-12-09 19:00:00	SPY	ETF	119.22	119.23	119.21	119.21	4900.0
2004-12-09 08:00:00	QQQ	ETF	39.5	39.541	39.44	39.45	1565453.0
2004-12-09 09:00:00	QQQ	ETF	39.458	39.58	39.399	39.5299	13497250.0
2004-12-09 10:00:00	QQQ	ETF	39.527	39.534	39.24	39.34	26813415.0
2004-12-09 11:00:00	QQQ	ETF	39.339	39.43	39.274	39.38	9734650.0
2004-12-09 12:00:00	QQQ	ETF	39.387	39.64	39.34	39.61	14916217.0
2004-12-09 13:00:00	QQQ	ETF	39.61	40.05	39.6	39.97	24195637.0
2004-12-09 14:00:00	QQQ	ETF	39.969	40.15	39.77	40.138	13648892.0
2004-12-09 15:00:00	QQQ	ETF	40.13	40.19	39.98	40.05	19643497.0
2004-12-09 16:00:00	QQQ	ETF	40.05	40.07	39.8365	39.99	7652539.0
2004-12-09 17:00:00	QQQ	ETF	39.99	40.03	39.98	40.03	134132.0
2004-12-09 18:00:00	QQQ	ETF	40.02	40.02	39.97	39.98	38082.0
2004-12-09 08:00:00	IWM	ETF	62.685	62.75	62.625	62.625	106000.0
2004-12-09 09:00:00	IWM	ETF	62.605	62.745	62.15	62.235	2062400.0
2004-12-09 10:00:00	IWM	ETF	62.23	62.255	61.95	62.175	3411400.0
2004-12-09 11:00:00	IWM	ETF	62.175	62.255	62.105	62.225	2166200.0
2004-12-09 12:00:00	IWM	ETF	62.225	62.615	62.155	62.49	1715600.0
2004-12-09 13:00:00	IWM	ETF	62.495	62.935	62.475	62.81	2389800.0
2004-12-09 14:00:00	IWM	ETF	62.82	62.83	62.475	62.735	1645400.0
2004-12-09 15:00:00	IWM	ETF	62.74	62.895	62.7	62.77	3300600.0
2004-12-09 16:00:00	IWM	ETF	62.79	62.795	62.315	62.665	183400.0
2004-12-09 17:00:00	IWM	ETF	62.72	62.785	62.72	62.785	15200.0
2004-12-09 08:00:00	DIA	ETF	104.66	104.66	104.46	104.47	32200.0
2004-12-09 09:00:00	DIA	ETF	104.55	104.67	104.41	104.6	664300.0
2004-12-09 10:00:00	DIA	ETF	104.6	104.66	104.16	104.35	2175700.0
2004-12-09 11:00:00	DIA	ETF	104.35	104.47	104.27	104.41	652100.0
2004-12-09 12:00:00	DIA	ETF	104.42	104.88	104.42	104.77	1209000.0
2004-12-09 13:00:00	DIA	ETF	104.77	105.31	104.73	105.14	1166300.0
2004-12-09 14:00:00	DIA	ETF	105.14	105.21	104.84	105.18	1191400.0
2004-12-09 15:00:00	DIA	ETF	105.2	105.6	105.19	105.51	1654700.0
2004-12-09 16:00:00	DIA	ETF	105.51	105.57	105.38	105.41	107700.0
2004-12-09 17:00:00	DIA	ETF	105.4	105.4	105.4	105.4	500.0
2004-12-09 09:00:00	GLD	ETF	43.75	43.75	43.62	43.73	985100.0
2004-12-09 10:00:00	GLD	ETF	43.73	43.79	43.47	43.5	954100.0
2004-12-09 11:00:00	GLD	ETF	43.48	43.62	43.37	43.59	376500.0
2004-12-09 12:00:00	GLD	ETF	43.59	43.7	43.41	43.41	205400.0
2004-12-09 13:00:00	GLD	ETF	43.41	43.81	43.2	43.75	480800.0
2004-12-09 14:00:00	GLD	ETF	43.75	43.79	43.65	43.75	210100.0
2004-12-09 15:00:00	GLD	ETF	43.76	43.83	43.72	43.78	299200.0

> showing 50 of 776 rows — these rows as CSV

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