PREVIEW / etf_1hour / 2004-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-15.parquet
  size:    25 KB
  rows:    694

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-06-15 08:00:00	SPY	ETF	113.51	114.08	113.45	113.91	424100.0
2004-06-15 09:00:00	SPY	ETF	113.91	114.16	113.88	113.92	5167400.0
2004-06-15 10:00:00	SPY	ETF	113.92	114.27	113.9	114.03	3924800.0
2004-06-15 11:00:00	SPY	ETF	114.04	114.28	113.98	114.18	2871700.0
2004-06-15 12:00:00	SPY	ETF	114.19	114.445	114.14	114.36	4145000.0
2004-06-15 13:00:00	SPY	ETF	114.36	114.43	114.19	114.28	3960400.0
2004-06-15 14:00:00	SPY	ETF	114.28	114.32	113.98	114.01	3677700.0
2004-06-15 15:00:00	SPY	ETF	114.01	114.1	113.51	113.95	9666700.0
2004-06-15 16:00:00	SPY	ETF	113.95	114.06	113.87	113.92	1833100.0
2004-06-15 17:00:00	SPY	ETF	113.92	113.95	113.92	113.95	2400.0
2004-06-15 18:00:00	SPY	ETF	113.95	113.95	113.95	113.95	500.0
2004-06-15 19:00:00	SPY	ETF	113.92	113.92	113.92	113.92	100.0
2004-06-15 08:00:00	QQQ	ETF	36.43	36.65	36.36	36.6	1139500.0
2004-06-15 09:00:00	QQQ	ETF	36.6	36.75	36.54	36.63	12437000.0
2004-06-15 10:00:00	QQQ	ETF	36.63	36.77	36.61	36.71	8856200.0
2004-06-15 11:00:00	QQQ	ETF	36.71	36.83	36.69	36.78	10042900.0
2004-06-15 12:00:00	QQQ	ETF	36.79	36.974	36.77	36.94	10208200.0
2004-06-15 13:00:00	QQQ	ETF	36.949	36.98	36.89	36.96	9124700.0
2004-06-15 14:00:00	QQQ	ETF	36.96	36.99	36.8	36.83	10456400.0
2004-06-15 15:00:00	QQQ	ETF	36.823	36.86	36.64	36.84	23372800.0
2004-06-15 16:00:00	QQQ	ETF	36.84	36.86	36.74	36.742	4112900.0
2004-06-15 17:00:00	QQQ	ETF	36.75	36.79	36.73	36.79	147800.0
2004-06-15 18:00:00	QQQ	ETF	36.78	36.79	36.77	36.79	17700.0
2004-06-15 19:00:00	QQQ	ETF	36.79	36.8	36.78	36.8	12100.0
2004-06-15 08:00:00	IWM	ETF	55.82	56.18	55.82	56.135	30200.0
2004-06-15 09:00:00	IWM	ETF	56.155	56.465	56.065	56.295	2134400.0
2004-06-15 10:00:00	IWM	ETF	56.295	56.675	56.295	56.525	2695400.0
2004-06-15 11:00:00	IWM	ETF	56.53	56.65	56.45	56.635	955400.0
2004-06-15 12:00:00	IWM	ETF	56.65	56.915	56.65	56.845	1004200.0
2004-06-15 13:00:00	IWM	ETF	56.875	56.875	56.75	56.86	921200.0
2004-06-15 14:00:00	IWM	ETF	56.86	56.88	56.545	56.58	1098200.0
2004-06-15 15:00:00	IWM	ETF	56.57	56.71	56.265	56.69	1975800.0
2004-06-15 16:00:00	IWM	ETF	56.685	56.75	56.655	56.7	8792000.0
2004-06-15 08:00:00	DIA	ETF	103.8	104.32	103.8	104.21	31100.0
2004-06-15 09:00:00	DIA	ETF	104.22	104.33	104.07	104.13	619500.0
2004-06-15 10:00:00	DIA	ETF	104.12	104.44	104.1	104.17	929600.0
2004-06-15 11:00:00	DIA	ETF	104.17	104.37	104.16	104.35	781400.0
2004-06-15 12:00:00	DIA	ETF	104.35	104.5	104.26	104.43	348800.0
2004-06-15 13:00:00	DIA	ETF	104.45	104.51	104.25	104.3	600600.0
2004-06-15 14:00:00	DIA	ETF	104.3	104.32	104.07	104.11	312900.0
2004-06-15 15:00:00	DIA	ETF	104.09	104.18	103.65	104.06	2702200.0
2004-06-15 16:00:00	DIA	ETF	104.09	104.13	103.99	104.01	431200.0
2004-06-15 08:00:00	TLT	ETF	81.73	81.73	81.73	81.73	200.0
2004-06-15 09:00:00	TLT	ETF	81.71	81.96	81.71	81.95	233600.0
2004-06-15 10:00:00	TLT	ETF	81.91	82.15	81.9	82.15	163700.0
2004-06-15 11:00:00	TLT	ETF	82.11	82.42	82.1	82.34	494000.0
2004-06-15 12:00:00	TLT	ETF	82.4	82.51	82.26	82.49	108000.0
2004-06-15 13:00:00	TLT	ETF	82.45	82.5	82.33	82.33	65400.0
2004-06-15 14:00:00	TLT	ETF	82.41	82.47	82.32	82.47	152800.0
2004-06-15 15:00:00	TLT	ETF	82.5	82.62	82.49	82.55	335500.0

> showing 50 of 694 rows — these rows as CSV

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