PREVIEW / etf_1hour / 2001-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-12-14.parquet
  size:    13 KB
  rows:    273

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
2001-12-14 09:00:00	SPY	ETF	112.33	112.62	112.16	112.29	2501000.0
2001-12-14 10:00:00	SPY	ETF	112.34	112.7	112.0	112.7	2936200.0
2001-12-14 11:00:00	SPY	ETF	112.7	112.74	112.15	112.49	1344800.0
2001-12-14 12:00:00	SPY	ETF	112.49	112.61	112.13	112.23	1131300.0
2001-12-14 13:00:00	SPY	ETF	112.29	112.49	112.05	112.31	967300.0
2001-12-14 14:00:00	SPY	ETF	112.25	112.97	112.25	112.93	2427600.0
2001-12-14 15:00:00	SPY	ETF	112.95	113.49	112.71	112.9	3874700.0
2001-12-14 16:00:00	SPY	ETF	112.9	113.24	112.9	113.18	1451000.0
2001-12-14 17:00:00	SPY	ETF	113.03	113.35	113.0	113.15	5400.0
2001-12-14 18:00:00	SPY	ETF	113.2	113.24	113.2	113.24	400.0
2001-12-14 09:00:00	QQQ	ETF	39.87	40.15	39.76	39.97	9984300.0
2001-12-14 10:00:00	QQQ	ETF	39.95	40.07	39.58	40.06	12468700.0
2001-12-14 11:00:00	QQQ	ETF	40.06	40.13	39.69	40.08	7853100.0
2001-12-14 12:00:00	QQQ	ETF	40.01	40.14	39.61	39.72	4987300.0
2001-12-14 13:00:00	QQQ	ETF	39.71	39.87	39.57	39.62	5774100.0
2001-12-14 14:00:00	QQQ	ETF	39.62	40.19	39.6	40.16	9856300.0
2001-12-14 15:00:00	QQQ	ETF	40.16	40.46	39.89	40.03	15468800.0
2001-12-14 16:00:00	QQQ	ETF	40.03	40.4	40.01	40.18	2009700.0
2001-12-14 17:00:00	QQQ	ETF	40.2	40.25	40.17	40.19	13700.0
2001-12-14 18:00:00	QQQ	ETF	40.21	40.25	40.15	40.24	9900.0
2001-12-14 09:00:00	IWM	ETF	46.65	46.8	46.505	46.69	66000.0
2001-12-14 10:00:00	IWM	ETF	46.595	46.595	46.385	46.475	24600.0
2001-12-14 11:00:00	IWM	ETF	46.49	46.54	46.4	46.535	86200.0
2001-12-14 12:00:00	IWM	ETF	46.535	46.54	46.375	46.41	405800.0
2001-12-14 13:00:00	IWM	ETF	46.48	46.495	46.365	46.485	42600.0
2001-12-14 14:00:00	IWM	ETF	46.47	46.675	46.435	46.645	121400.0
2001-12-14 15:00:00	IWM	ETF	46.65	46.875	46.65	46.775	399600.0
2001-12-14 16:00:00	IWM	ETF	46.95	46.95	46.95	46.95	1200.0
2001-12-14 09:00:00	DIA	ETF	97.81	98.13	97.68	97.8	235400.0
2001-12-14 10:00:00	DIA	ETF	97.78	98.2	97.6	98.2	561700.0
2001-12-14 11:00:00	DIA	ETF	98.13	98.22	97.7	97.98	997600.0
2001-12-14 12:00:00	DIA	ETF	97.98	98.05	97.68	97.79	208900.0
2001-12-14 13:00:00	DIA	ETF	97.79	97.9	97.6	97.75	120500.0
2001-12-14 14:00:00	DIA	ETF	97.77	98.26	97.74	98.26	454700.0
2001-12-14 15:00:00	DIA	ETF	98.27	98.79	98.15	98.42	816600.0
2001-12-14 16:00:00	DIA	ETF	98.4	98.6	98.36	98.6	165000.0
2001-12-14 17:00:00	DIA	ETF	99.69	99.69	99.69	99.69	200.0

> showing 37 of 273 rows — these rows as CSV

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