PREVIEW / etf_1hour / 2004-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-14.parquet
  size:    25 KB
  rows:    698

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-04-14 08:00:00	SPY	ETF	113.18	113.2	112.56	112.68	157400.0
2004-04-14 09:00:00	SPY	ETF	112.65	113.13	112.5	113.03	4556800.0
2004-04-14 10:00:00	SPY	ETF	113.02	113.45	112.96	113.27	7533400.0
2004-04-14 11:00:00	SPY	ETF	113.27	113.63	113.23	113.54	5613400.0
2004-04-14 12:00:00	SPY	ETF	113.54	113.64	113.22	113.38	2793200.0
2004-04-14 13:00:00	SPY	ETF	113.36	113.39	113.11	113.24	5975700.0
2004-04-14 14:00:00	SPY	ETF	113.23	113.24	112.62	112.92	7335300.0
2004-04-14 15:00:00	SPY	ETF	112.92	113.17	112.56	113.15	5586000.0
2004-04-14 16:00:00	SPY	ETF	113.15	113.6	113.12	113.54	1992200.0
2004-04-14 17:00:00	SPY	ETF	113.58	113.65	113.54	113.56	1900.0
2004-04-14 18:00:00	SPY	ETF	113.59	113.59	113.47	113.5	12500.0
2004-04-14 19:00:00	SPY	ETF	113.54	113.55	113.5	113.5	4100.0
2004-04-14 08:00:00	QQQ	ETF	36.46	36.52	36.32	36.34	460000.0
2004-04-14 09:00:00	QQQ	ETF	36.34	36.72	36.3	36.67	11227100.0
2004-04-14 10:00:00	QQQ	ETF	36.673	36.845	36.62	36.73	15543900.0
2004-04-14 11:00:00	QQQ	ETF	36.74	36.95	36.71	36.813	9599500.0
2004-04-14 12:00:00	QQQ	ETF	36.812	36.89	36.72	36.77	5873900.0
2004-04-14 13:00:00	QQQ	ETF	36.777	36.79	36.64	36.723	8833500.0
2004-04-14 14:00:00	QQQ	ETF	36.722	36.73	36.55	36.6675	11253500.0
2004-04-14 15:00:00	QQQ	ETF	36.6611	36.69	36.44	36.68	12308300.0
2004-04-14 16:00:00	QQQ	ETF	36.66	36.93	36.66	36.882	5069700.0
2004-04-14 17:00:00	QQQ	ETF	36.882	36.92	36.86	36.88	458300.0
2004-04-14 18:00:00	QQQ	ETF	36.88	36.88	36.84	36.87	47800.0
2004-04-14 19:00:00	QQQ	ETF	36.85	36.88	36.85	36.86	29400.0
2004-04-14 08:00:00	IWM	ETF	58.2	58.2	57.9	57.9	5800.0
2004-04-14 09:00:00	IWM	ETF	57.825	58.15	57.75	58.105	2690400.0
2004-04-14 10:00:00	IWM	ETF	58.125	58.515	58.075	58.39	1769600.0
2004-04-14 11:00:00	IWM	ETF	58.375	58.67	58.375	58.515	510200.0
2004-04-14 12:00:00	IWM	ETF	58.485	58.6	58.41	58.49	343600.0
2004-04-14 13:00:00	IWM	ETF	58.485	58.495	58.225	58.25	391800.0
2004-04-14 14:00:00	IWM	ETF	58.245	58.25	57.575	57.785	2858600.0
2004-04-14 15:00:00	IWM	ETF	57.785	57.935	57.59	57.91	2239800.0
2004-04-14 16:00:00	IWM	ETF	57.92	58.21	57.905	58.21	330200.0
2004-04-14 08:00:00	DIA	ETF	103.9	103.91	103.43	103.51	71900.0
2004-04-14 09:00:00	DIA	ETF	103.36	103.99	103.35	103.84	1001500.0
2004-04-14 10:00:00	DIA	ETF	103.83	104.24	103.79	104.03	982700.0
2004-04-14 11:00:00	DIA	ETF	104.05	104.36	104.0	104.27	565300.0
2004-04-14 12:00:00	DIA	ETF	104.25	104.34	103.99	104.1	471300.0
2004-04-14 13:00:00	DIA	ETF	104.09	104.1	103.85	103.92	506700.0
2004-04-14 14:00:00	DIA	ETF	103.95	103.95	103.45	103.69	1180200.0
2004-04-14 15:00:00	DIA	ETF	103.7	104.01	103.41	104.01	1137500.0
2004-04-14 16:00:00	DIA	ETF	104.01	104.35	104.01	104.35	298300.0
2004-04-14 17:00:00	DIA	ETF	104.27	104.27	104.27	104.27	100.0
2004-04-14 18:00:00	DIA	ETF	104.3	104.34	104.25	104.25	1200.0
2004-04-14 19:00:00	DIA	ETF	104.25	104.25	104.25	104.25	500.0
2004-04-14 08:00:00	TLT	ETF	84.2	84.2	84.0	84.0	11800.0
2004-04-14 09:00:00	TLT	ETF	83.89	84.19	83.89	84.05	265500.0
2004-04-14 10:00:00	TLT	ETF	84.11	84.37	84.07	84.36	654400.0
2004-04-14 11:00:00	TLT	ETF	84.39	84.44	84.24	84.44	295000.0
2004-04-14 12:00:00	TLT	ETF	84.44	84.6	84.4	84.6	69400.0

> showing 50 of 698 rows — these rows as CSV

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