PREVIEW / etf_1hour / 2007-01-19

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-19.parquet
  size:    61 KB
  rows:    1,917

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
2007-01-19 04:00:00	SPY	ETF	142.5	142.5	142.5	142.5	1900.0
2007-01-19 07:00:00	SPY	ETF	142.44	142.5	142.35	142.46	65300.0
2007-01-19 08:00:00	SPY	ETF	142.45	142.5	142.35	142.48	945200.0
2007-01-19 09:00:00	SPY	ETF	142.48	142.84	142.46	142.54	7982800.0
2007-01-19 10:00:00	SPY	ETF	142.55	143.1	142.49	142.97	13440300.0
2007-01-19 11:00:00	SPY	ETF	142.96	143.04	142.74	142.83	6887200.0
2007-01-19 12:00:00	SPY	ETF	142.83	142.91	142.52	142.65	6669100.0
2007-01-19 13:00:00	SPY	ETF	142.66	142.87	142.65	142.78	3250800.0
2007-01-19 14:00:00	SPY	ETF	142.79	143.0	142.77	142.95	6086100.0
2007-01-19 15:00:00	SPY	ETF	142.95	142.98	142.83	142.93	5896700.0
2007-01-19 16:00:00	SPY	ETF	142.94	143.03	142.82	142.9	3710900.0
2007-01-19 17:00:00	SPY	ETF	142.9	142.96	142.9	142.95	54900.0
2007-01-19 18:00:00	SPY	ETF	142.95	142.95	142.95	142.95	5800.0
2007-01-19 06:00:00	QQQ	ETF	44.02	44.02	44.02	44.02	20000.0
2007-01-19 07:00:00	QQQ	ETF	43.96	43.96	43.91	43.96	228900.0
2007-01-19 08:00:00	QQQ	ETF	43.96	44.05	43.92	44.05	940618.0
2007-01-19 09:00:00	QQQ	ETF	44.05	44.13	43.91	43.99	21743289.0
2007-01-19 10:00:00	QQQ	ETF	43.99	44.27	43.94	44.18	31387500.0
2007-01-19 11:00:00	QQQ	ETF	44.18	44.28	44.03	44.1	18314700.0
2007-01-19 12:00:00	QQQ	ETF	44.11	44.17	43.96	44.0	11223400.0
2007-01-19 13:00:00	QQQ	ETF	44.04	44.17	44.04	44.12	9173300.0
2007-01-19 14:00:00	QQQ	ETF	44.12	44.26	44.12	44.23	12676800.0
2007-01-19 15:00:00	QQQ	ETF	44.23	44.25	44.11	44.16	13032600.0
2007-01-19 16:00:00	QQQ	ETF	44.16	44.17	43.75	44.15	6763430.0
2007-01-19 17:00:00	QQQ	ETF	44.15	44.18	44.13	44.15	266335.0
2007-01-19 18:00:00	QQQ	ETF	44.15	44.19	44.15	44.19	19835.0
2007-01-19 19:00:00	QQQ	ETF	44.2	44.21	44.18	44.18	15990.0
2007-01-19 07:00:00	IWM	ETF	77.2	77.2	77.2	77.2	4000.0
2007-01-19 08:00:00	IWM	ETF	76.95	77.09	76.95	77.09	95500.0
2007-01-19 09:00:00	IWM	ETF	77.09	77.16	76.87	76.94	6759300.0
2007-01-19 10:00:00	IWM	ETF	76.94	77.64	76.93	77.6	11892700.0
2007-01-19 11:00:00	IWM	ETF	77.6	77.72	77.42	77.5175	11479400.0
2007-01-19 12:00:00	IWM	ETF	77.51	77.61	77.28	77.44	4102200.0
2007-01-19 13:00:00	IWM	ETF	77.44	77.8	77.44	77.74	3195500.0
2007-01-19 14:00:00	IWM	ETF	77.74	77.94	77.73	77.89	5189100.0
2007-01-19 15:00:00	IWM	ETF	77.89	77.96	77.74	77.85	5893200.0
2007-01-19 16:00:00	IWM	ETF	77.84	78.01	77.73	77.76	427500.0
2007-01-19 17:00:00	IWM	ETF	77.76	77.76	77.76	77.76	2000.0
2007-01-19 07:00:00	DIA	ETF	125.2	125.29	125.2	125.22	9200.0
2007-01-19 08:00:00	DIA	ETF	125.22	125.29	125.13	125.17	132000.0
2007-01-19 09:00:00	DIA	ETF	125.2	125.5	125.19	125.35	1229600.0
2007-01-19 10:00:00	DIA	ETF	125.35	125.71	125.27	125.63	2717800.0
2007-01-19 11:00:00	DIA	ETF	125.62	125.69	125.39	125.44	1146800.0
2007-01-19 12:00:00	DIA	ETF	125.44	125.47	125.18	125.33	963300.0
2007-01-19 13:00:00	DIA	ETF	125.33	125.54	125.33	125.45	807500.0
2007-01-19 14:00:00	DIA	ETF	125.44	125.6	125.42	125.54	1367700.0
2007-01-19 15:00:00	DIA	ETF	125.54	125.58	125.46	125.55	2173600.0
2007-01-19 16:00:00	DIA	ETF	125.58	125.58	125.49	125.53	200400.0
2007-01-19 17:00:00	DIA	ETF	125.5	125.5	125.48	125.48	2500.0
2007-01-19 18:00:00	DIA	ETF	125.55	125.55	125.55	125.55	200.0

> showing 50 of 1,917 rows — these rows as CSV

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