PREVIEW / etf_1hour / 2001-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-04-20.parquet
  size:    12 KB
  rows:    238

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-04-20 09:00:00	SPY	ETF	124.9	125.21	124.55	125.0	1244300.0
2001-04-20 10:00:00	SPY	ETF	125.01	125.4	124.3	124.66	1576900.0
2001-04-20 11:00:00	SPY	ETF	124.66	124.68	123.66	123.85	941000.0
2001-04-20 12:00:00	SPY	ETF	123.85	124.4	123.83	123.9	669300.0
2001-04-20 13:00:00	SPY	ETF	123.9	124.69	123.81	124.62	493100.0
2001-04-20 14:00:00	SPY	ETF	124.57	124.87	123.97	124.32	814300.0
2001-04-20 15:00:00	SPY	ETF	124.28	124.75	124.21	124.5	1015700.0
2001-04-20 16:00:00	SPY	ETF	124.36	124.75	124.3	124.32	598900.0
2001-04-20 17:00:00	SPY	ETF	124.06	124.06	124.06	124.06	200.0
2001-04-20 09:00:00	QQQ	ETF	48.18	48.56	47.63	48.37	13074900.0
2001-04-20 10:00:00	QQQ	ETF	48.42	49.44	47.92	48.27	22439100.0
2001-04-20 11:00:00	QQQ	ETF	48.25	48.4	47.31	47.6	14010100.0
2001-04-20 12:00:00	QQQ	ETF	47.59	48.12	47.55	47.72	5794200.0
2001-04-20 13:00:00	QQQ	ETF	47.72	48.42	47.67	48.39	5612000.0
2001-04-20 14:00:00	QQQ	ETF	48.4	48.55	47.65	47.88	7147800.0
2001-04-20 15:00:00	QQQ	ETF	47.9	48.34	47.8	48.15	7062300.0
2001-04-20 16:00:00	QQQ	ETF	48.18	48.5	48.05	48.3	2571400.0
2001-04-20 17:00:00	QQQ	ETF	48.3	48.4	48.25	48.27	39700.0
2001-04-20 18:00:00	QQQ	ETF	48.3	48.3	48.03	48.23	27200.0
2001-04-20 09:00:00	IWM	ETF	47.0	47.0	46.635	46.92	64400.0
2001-04-20 10:00:00	IWM	ETF	46.975	46.975	46.3	46.475	72200.0
2001-04-20 11:00:00	IWM	ETF	46.495	46.495	46.0	46.05	162200.0
2001-04-20 12:00:00	IWM	ETF	46.15	46.295	46.03	46.155	47600.0
2001-04-20 13:00:00	IWM	ETF	46.295	46.525	46.21	46.525	28800.0
2001-04-20 14:00:00	IWM	ETF	46.61	46.61	46.21	46.39	37400.0
2001-04-20 15:00:00	IWM	ETF	46.425	46.675	46.335	46.595	88000.0
2001-04-20 16:00:00	IWM	ETF	46.675	46.675	46.645	46.645	800.0
2001-04-20 09:00:00	DIA	ETF	106.0	106.6	105.91	106.45	511600.0
2001-04-20 10:00:00	DIA	ETF	106.36	106.65	105.86	106.16	479400.0
2001-04-20 11:00:00	DIA	ETF	106.15	106.2	105.26	105.39	630800.0
2001-04-20 12:00:00	DIA	ETF	105.39	105.77	105.35	105.45	310300.0
2001-04-20 13:00:00	DIA	ETF	105.46	106.14	105.41	106.14	220400.0
2001-04-20 14:00:00	DIA	ETF	106.1	106.2	105.56	105.73	136500.0
2001-04-20 15:00:00	DIA	ETF	105.78	106.2	105.71	105.92	234600.0
2001-04-20 16:00:00	DIA	ETF	105.76	105.99	105.7	105.95	93800.0

> showing 35 of 238 rows — these rows as CSV

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