PREVIEW / etf_1hour / 2004-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-27.parquet
  size:    25 KB
  rows:    696

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-05-27 08:00:00	SPY	ETF	112.43	112.52	112.34	112.51	65300.0
2004-05-27 09:00:00	SPY	ETF	112.51	112.75	112.46	112.72	9366600.0
2004-05-27 10:00:00	SPY	ETF	112.72	113.03	112.68	112.91	5638300.0
2004-05-27 11:00:00	SPY	ETF	112.92	112.95	112.31	112.55	7028500.0
2004-05-27 12:00:00	SPY	ETF	112.55	112.6	112.1	112.14	4512400.0
2004-05-27 13:00:00	SPY	ETF	112.14	112.38	112.06	112.23	2959500.0
2004-05-27 14:00:00	SPY	ETF	112.23	112.65	112.12	112.6	3644600.0
2004-05-27 15:00:00	SPY	ETF	112.58	112.9	112.37	112.72	6278500.0
2004-05-27 16:00:00	SPY	ETF	112.72	112.98	112.54	112.9	2477500.0
2004-05-27 17:00:00	SPY	ETF	112.88	112.91	112.85	112.91	12600.0
2004-05-27 18:00:00	SPY	ETF	112.88	112.88	112.82	112.88	5500.0
2004-05-27 19:00:00	SPY	ETF	112.88	112.92	112.8	112.8	5600.0
2004-05-27 08:00:00	QQQ	ETF	36.28	36.28	36.15	36.28	404400.0
2004-05-27 09:00:00	QQQ	ETF	36.28	36.37	36.22	36.32	15446700.0
2004-05-27 10:00:00	QQQ	ETF	36.32	36.5	36.316	36.41	24452100.0
2004-05-27 11:00:00	QQQ	ETF	36.4	36.44	36.18	36.31	13657900.0
2004-05-27 12:00:00	QQQ	ETF	36.3	36.32	36.09	36.11	13198500.0
2004-05-27 13:00:00	QQQ	ETF	36.1	36.2	36.06	36.11	10677200.0
2004-05-27 14:00:00	QQQ	ETF	36.09	36.34	36.09	36.324	12059200.0
2004-05-27 15:00:00	QQQ	ETF	36.33	36.42	36.22	36.359	13484000.0
2004-05-27 16:00:00	QQQ	ETF	36.36	36.52	36.29	36.52	3271900.0
2004-05-27 17:00:00	QQQ	ETF	36.501	36.52	36.44	36.44	312300.0
2004-05-27 18:00:00	QQQ	ETF	36.46	36.471	36.44	36.46	29400.0
2004-05-27 19:00:00	QQQ	ETF	36.45	36.5	36.45	36.5	11700.0
2004-05-27 08:00:00	IWM	ETF	56.785	56.8	56.725	56.8	4000.0
2004-05-27 09:00:00	IWM	ETF	56.825	56.925	56.605	56.87	2519000.0
2004-05-27 10:00:00	IWM	ETF	56.89	57.13	56.86	57.01	3256000.0
2004-05-27 11:00:00	IWM	ETF	57.01	57.035	56.375	56.565	3438400.0
2004-05-27 12:00:00	IWM	ETF	56.555	56.58	56.27	56.28	1929400.0
2004-05-27 13:00:00	IWM	ETF	56.28	56.435	56.185	56.33	1070600.0
2004-05-27 14:00:00	IWM	ETF	56.33	56.66	56.265	56.6	1061000.0
2004-05-27 15:00:00	IWM	ETF	56.59	56.78	56.475	56.635	2409200.0
2004-05-27 16:00:00	IWM	ETF	56.625	56.715	56.62	56.69	536000.0
2004-05-27 18:00:00	IWM	ETF	56.65	56.65	56.65	56.65	400.0
2004-05-27 08:00:00	DIA	ETF	101.58	101.66	101.58	101.65	11400.0
2004-05-27 09:00:00	DIA	ETF	101.68	102.02	101.66	101.99	842100.0
2004-05-27 10:00:00	DIA	ETF	102.0	102.37	101.97	102.31	1325000.0
2004-05-27 11:00:00	DIA	ETF	102.31	102.34	101.82	102.08	921100.0
2004-05-27 12:00:00	DIA	ETF	102.07	102.14	101.71	101.71	464900.0
2004-05-27 13:00:00	DIA	ETF	101.75	101.92	101.7	101.81	443600.0
2004-05-27 14:00:00	DIA	ETF	101.85	102.1	101.71	102.02	633400.0
2004-05-27 15:00:00	DIA	ETF	102.03	102.37	101.84	102.14	945600.0
2004-05-27 16:00:00	DIA	ETF	102.15	102.36	102.11	102.35	225000.0
2004-05-27 17:00:00	DIA	ETF	102.36	102.36	102.33	102.33	2700.0
2004-05-27 18:00:00	DIA	ETF	102.35	102.35	102.33	102.33	500.0
2004-05-27 08:00:00	TLT	ETF	82.7	82.75	82.7	82.75	2000.0
2004-05-27 09:00:00	TLT	ETF	82.75	83.06	82.75	82.9	275700.0
2004-05-27 10:00:00	TLT	ETF	82.91	82.98	82.83	82.94	82000.0
2004-05-27 11:00:00	TLT	ETF	82.97	83.05	82.88	82.97	267000.0
2004-05-27 12:00:00	TLT	ETF	83.02	83.06	82.94	83.03	35300.0

> showing 50 of 696 rows — these rows as CSV

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