PREVIEW / etf_1hour / 2010-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-03.parquet
  size:    168 KB
  rows:    5,126

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
2010-11-03 04:00:00	SPY	ETF	119.76	119.76	119.59	119.64	18750.0
2010-11-03 05:00:00	SPY	ETF	119.7	119.85	119.7	119.85	300.0
2010-11-03 06:00:00	SPY	ETF	119.84	119.89	119.83	119.87	23400.0
2010-11-03 07:00:00	SPY	ETF	119.8	119.91	119.76	119.91	290915.0
2010-11-03 08:00:00	SPY	ETF	119.89	119.95	119.79	119.88	1246167.0
2010-11-03 09:00:00	SPY	ETF	119.88	119.89	119.5	119.5701	14450868.0
2010-11-03 10:00:00	SPY	ETF	119.58	119.74	119.38	119.4101	20783316.0
2010-11-03 11:00:00	SPY	ETF	119.42	119.6774	119.07	119.21	19050479.0
2010-11-03 12:00:00	SPY	ETF	119.2095	119.25	118.94	119.135	13053600.0
2010-11-03 13:00:00	SPY	ETF	119.14	119.33	119.06	119.18	13677299.0
2010-11-03 14:00:00	SPY	ETF	119.19	119.86	118.45	119.65	80846120.0
2010-11-03 15:00:00	SPY	ETF	119.659	120.02	119.51	119.97	47398496.0
2010-11-03 16:00:00	SPY	ETF	119.96	120.26	119.095	120.15	15033285.0
2010-11-03 17:00:00	SPY	ETF	120.15	120.19	120.12	120.13	152394.0
2010-11-03 18:00:00	SPY	ETF	120.14	120.19	120.01	120.13	190682.0
2010-11-03 19:00:00	SPY	ETF	120.15	120.23	120.1	120.19	67245.0
2010-11-03 04:00:00	QQQ	ETF	52.81	52.81	52.8	52.8	244.0
2010-11-03 07:00:00	QQQ	ETF	52.86	52.92	52.86	52.92	60800.0
2010-11-03 08:00:00	QQQ	ETF	52.91	52.94	52.84	52.9	145713.0
2010-11-03 09:00:00	QQQ	ETF	52.91	52.91	52.75	52.77	6390805.0
2010-11-03 10:00:00	QQQ	ETF	52.77	52.85	52.64	52.675	8297293.0
2010-11-03 11:00:00	QQQ	ETF	52.67	52.72	52.51	52.61	7130903.0
2010-11-03 12:00:00	QQQ	ETF	52.62	52.63	52.5	52.6	3687987.0
2010-11-03 13:00:00	QQQ	ETF	52.6	52.7	52.58	52.64	3993496.0
2010-11-03 14:00:00	QQQ	ETF	52.63	52.98	52.36	52.9299	34577219.0
2010-11-03 15:00:00	QQQ	ETF	52.93	53.04	52.81	53.0	13787419.0
2010-11-03 16:00:00	QQQ	ETF	53.0	53.26	52.8848	53.25	3649087.0
2010-11-03 17:00:00	QQQ	ETF	53.23	53.26	53.17	53.2	133213.0
2010-11-03 18:00:00	QQQ	ETF	53.22	53.23	53.17	53.2	64524.0
2010-11-03 19:00:00	QQQ	ETF	53.2	53.24	53.19	53.23	82700.0
2010-11-03 04:00:00	IWM	ETF	71.5	71.5	71.35	71.35	2600.0
2010-11-03 06:00:00	IWM	ETF	71.51	71.53	71.51	71.53	200.0
2010-11-03 07:00:00	IWM	ETF	71.54	71.59	71.53	71.57	25750.0
2010-11-03 08:00:00	IWM	ETF	71.56	71.61	71.48	71.51	132093.0
2010-11-03 09:00:00	IWM	ETF	71.48	71.51	71.21	71.4	3526244.0
2010-11-03 10:00:00	IWM	ETF	71.41	71.56	71.19	71.29	4717939.0
2010-11-03 11:00:00	IWM	ETF	71.29	71.34	71.0	71.12	4463479.0
2010-11-03 12:00:00	IWM	ETF	71.11	71.11	70.859	70.92	2808468.0
2010-11-03 13:00:00	IWM	ETF	70.92	71.1381	70.91	71.07	3063591.0
2010-11-03 14:00:00	IWM	ETF	71.06	71.57	70.5	71.35	19627341.0
2010-11-03 15:00:00	IWM	ETF	71.36	71.62	71.21	71.56	11759988.0
2010-11-03 16:00:00	IWM	ETF	71.57	71.81	71.05	71.79	2023279.0
2010-11-03 17:00:00	IWM	ETF	71.76	71.8	71.75	71.75	11775.0
2010-11-03 18:00:00	IWM	ETF	71.75	71.75	71.54	71.72	20606.0
2010-11-03 19:00:00	IWM	ETF	71.8	71.8	71.8	71.8	500.0
2010-11-03 07:00:00	DIA	ETF	112.17	112.23	112.17	112.23	400.0
2010-11-03 08:00:00	DIA	ETF	112.24	112.24	112.14	112.2	14500.0
2010-11-03 09:00:00	DIA	ETF	112.22	112.23	111.98	112.12	740685.0
2010-11-03 10:00:00	DIA	ETF	112.13	112.27	111.97	112.01	908846.0
2010-11-03 11:00:00	DIA	ETF	112.018	112.04	111.68	111.83	688766.0

> showing 50 of 5,126 rows — these rows as CSV

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