PREVIEW / etf_1hour / 2004-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-30.parquet
  size:    24 KB
  rows:    678

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-30 08:00:00	SPY	ETF	112.25	112.39	112.17	112.28	101700.0
2004-03-30 09:00:00	SPY	ETF	112.27	112.7	112.22	112.67	5631900.0
2004-03-30 10:00:00	SPY	ETF	112.67	112.72	112.35	112.65	6430400.0
2004-03-30 11:00:00	SPY	ETF	112.65	112.75	112.45	112.45	2648100.0
2004-03-30 12:00:00	SPY	ETF	112.44	112.58	112.24	112.36	3663000.0
2004-03-30 13:00:00	SPY	ETF	112.36	112.7	112.31	112.64	4346700.0
2004-03-30 14:00:00	SPY	ETF	112.64	112.84	112.47	112.74	3550800.0
2004-03-30 15:00:00	SPY	ETF	112.74	113.07	112.69	112.97	7255800.0
2004-03-30 16:00:00	SPY	ETF	112.98	113.02	112.6139	112.97	2024300.0
2004-03-30 17:00:00	SPY	ETF	112.92	112.98	112.92	112.98	600.0
2004-03-30 18:00:00	SPY	ETF	112.97	112.97	112.89	112.89	2000.0
2004-03-30 08:00:00	QQQ	ETF	35.65	35.69	35.63	35.66	240600.0
2004-03-30 09:00:00	QQQ	ETF	35.66	35.86	35.6	35.82	12642200.0
2004-03-30 10:00:00	QQQ	ETF	35.82	35.85	35.63	35.769	15191700.0
2004-03-30 11:00:00	QQQ	ETF	35.77	35.85	35.68	35.69	11913700.0
2004-03-30 12:00:00	QQQ	ETF	35.68	35.73	35.517	35.59	13811000.0
2004-03-30 13:00:00	QQQ	ETF	35.58	35.74	35.56	35.71	7077300.0
2004-03-30 14:00:00	QQQ	ETF	35.72	35.84	35.66	35.8	8819200.0
2004-03-30 15:00:00	QQQ	ETF	35.78	35.94	35.77	35.9	17687700.0
2004-03-30 16:00:00	QQQ	ETF	35.89	35.96	35.87	35.92	5179300.0
2004-03-30 17:00:00	QQQ	ETF	35.925	35.94	35.91	35.93	88600.0
2004-03-30 18:00:00	QQQ	ETF	35.94	35.94	35.63	35.91	148100.0
2004-03-30 19:00:00	QQQ	ETF	35.9	35.9	35.87	35.88	26900.0
2004-03-30 08:00:00	IWM	ETF	58.045	58.045	58.045	58.045	600.0
2004-03-30 09:00:00	IWM	ETF	57.995	58.37	57.96	58.35	1162200.0
2004-03-30 10:00:00	IWM	ETF	58.35	58.465	58.17	58.445	1287800.0
2004-03-30 11:00:00	IWM	ETF	58.435	58.52	58.29	58.395	1142800.0
2004-03-30 12:00:00	IWM	ETF	58.375	58.445	58.145	58.17	1101600.0
2004-03-30 13:00:00	IWM	ETF	58.165	58.485	58.165	58.455	654600.0
2004-03-30 14:00:00	IWM	ETF	58.46	58.525	58.375	58.485	1033400.0
2004-03-30 15:00:00	IWM	ETF	58.475	58.685	58.465	58.65	2340800.0
2004-03-30 16:00:00	IWM	ETF	58.65	58.71	58.615	58.625	909600.0
2004-03-30 19:00:00	IWM	ETF	58.61	58.61	58.61	58.61	200.0
2004-03-30 08:00:00	DIA	ETF	103.25	103.27	103.18	103.27	17700.0
2004-03-30 09:00:00	DIA	ETF	103.26	103.6	103.2	103.59	851300.0
2004-03-30 10:00:00	DIA	ETF	103.62	103.64	103.33	103.45	570700.0
2004-03-30 11:00:00	DIA	ETF	103.48	103.62	103.36	103.36	437800.0
2004-03-30 12:00:00	DIA	ETF	103.36	103.46	103.2	103.33	211600.0
2004-03-30 13:00:00	DIA	ETF	103.3	103.62	103.28	103.59	199100.0
2004-03-30 14:00:00	DIA	ETF	103.58	103.78	103.49	103.74	602000.0
2004-03-30 15:00:00	DIA	ETF	103.75	104.06	103.69	103.94	1492400.0
2004-03-30 16:00:00	DIA	ETF	103.94	104.03	103.92	103.95	73500.0
2004-03-30 17:00:00	DIA	ETF	104.0	104.0	104.0	104.0	1000.0
2004-03-30 19:00:00	DIA	ETF	103.99	104.0	103.99	104.0	300.0
2004-03-30 09:00:00	TLT	ETF	89.3	89.4	89.22	89.22	247900.0
2004-03-30 10:00:00	TLT	ETF	89.21	89.43	89.18	89.38	465400.0
2004-03-30 11:00:00	TLT	ETF	89.35	89.43	89.34	89.41	50000.0
2004-03-30 12:00:00	TLT	ETF	89.43	89.43	89.35	89.35	99500.0
2004-03-30 13:00:00	TLT	ETF	89.35	89.38	89.11	89.11	68100.0
2004-03-30 14:00:00	TLT	ETF	89.16	89.2	89.07	89.07	44300.0

> showing 50 of 678 rows — these rows as CSV

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