PREVIEW / etf_1hour / 2010-11-02

all etf 1-hour files

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

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-02 04:00:00	SPY	ETF	118.83	119.15	118.83	119.05	2020.0
2010-11-02 05:00:00	SPY	ETF	119.19	119.2	119.18	119.18	3100.0
2010-11-02 06:00:00	SPY	ETF	119.13	119.28	119.12	119.22	15600.0
2010-11-02 07:00:00	SPY	ETF	119.21	119.48	119.19	119.4	607700.0
2010-11-02 08:00:00	SPY	ETF	119.39	119.59	118.85	119.42	1569792.0
2010-11-02 09:00:00	SPY	ETF	119.45	119.64	119.31	119.43	27863151.0
2010-11-02 10:00:00	SPY	ETF	119.42	119.49	119.1	119.25	24539709.0
2010-11-02 11:00:00	SPY	ETF	119.25	119.43	119.2	119.34	15404275.0
2010-11-02 12:00:00	SPY	ETF	119.35	119.56	119.31	119.51	14437120.0
2010-11-02 13:00:00	SPY	ETF	119.51	119.75	119.49	119.699	13513178.0
2010-11-02 14:00:00	SPY	ETF	119.7	119.73	119.41	119.49	13815177.0
2010-11-02 15:00:00	SPY	ETF	119.49	119.62	119.38	119.47	28048662.0
2010-11-02 16:00:00	SPY	ETF	119.46	119.81	119.255	119.76	12938613.0
2010-11-02 17:00:00	SPY	ETF	119.76	119.8	119.7	119.74	1133015.0
2010-11-02 18:00:00	SPY	ETF	119.72	119.85	119.49	119.82	169427.0
2010-11-02 19:00:00	SPY	ETF	119.82	120.11	119.82	120.05	259513.0
2010-11-02 04:00:00	QQQ	ETF	52.5	52.5	52.43	52.43	600.0
2010-11-02 05:00:00	QQQ	ETF	52.46	52.48	52.46	52.48	300.0
2010-11-02 06:00:00	QQQ	ETF	52.46	52.47	52.46	52.47	5300.0
2010-11-02 07:00:00	QQQ	ETF	52.47	52.58	52.47	52.57	69016.0
2010-11-02 08:00:00	QQQ	ETF	52.56	52.66	52.56	52.58	392399.0
2010-11-02 09:00:00	QQQ	ETF	52.58	52.85	52.57	52.73	10312080.0
2010-11-02 10:00:00	QQQ	ETF	52.74	52.77	52.575	52.68	8457885.0
2010-11-02 11:00:00	QQQ	ETF	52.6725	52.75	52.65	52.7	2993258.0
2010-11-02 12:00:00	QQQ	ETF	52.705	52.79	52.67	52.76	2980629.0
2010-11-02 13:00:00	QQQ	ETF	52.765	52.93	52.765	52.8901	4627321.0
2010-11-02 14:00:00	QQQ	ETF	52.89	52.9	52.74	52.7891	4200674.0
2010-11-02 15:00:00	QQQ	ETF	52.7882	52.86	52.67	52.77	8177229.0
2010-11-02 16:00:00	QQQ	ETF	52.77	52.92	52.72	52.87	2254440.0
2010-11-02 17:00:00	QQQ	ETF	52.88	52.9	52.85	52.85	6700.0
2010-11-02 18:00:00	QQQ	ETF	52.85	52.9	52.85	52.89	7802.0
2010-11-02 19:00:00	QQQ	ETF	52.9	53.01	52.9	53.0	152106.0
2010-11-02 04:00:00	IWM	ETF	70.28	70.28	70.28	70.28	200.0
2010-11-02 06:00:00	IWM	ETF	70.41	70.5	70.41	70.45	2600.0
2010-11-02 07:00:00	IWM	ETF	70.46	70.68	70.46	70.67	38620.0
2010-11-02 08:00:00	IWM	ETF	70.63	70.73	70.55	70.55	231777.0
2010-11-02 09:00:00	IWM	ETF	70.56	71.05	70.53	70.77	8245471.0
2010-11-02 10:00:00	IWM	ETF	70.77	70.825	70.272	70.46	7761112.0
2010-11-02 11:00:00	IWM	ETF	70.46	70.81	70.43	70.8	2500197.0
2010-11-02 12:00:00	IWM	ETF	70.8	70.92	70.72	70.84	2615128.0
2010-11-02 13:00:00	IWM	ETF	70.85	71.22	70.85	71.2	3939793.0
2010-11-02 14:00:00	IWM	ETF	71.2	71.31	70.98	71.02	6574611.0
2010-11-02 15:00:00	IWM	ETF	71.03	71.3	71.03	71.26	8896188.0
2010-11-02 16:00:00	IWM	ETF	71.27	71.51	69.8865	71.48	4528011.0
2010-11-02 17:00:00	IWM	ETF	71.5	71.55	71.42	71.44	89629.0
2010-11-02 18:00:00	IWM	ETF	71.45	71.58	71.31	71.52	62581.0
2010-11-02 19:00:00	IWM	ETF	71.56	71.77	71.51	71.77	20192.0
2010-11-02 07:00:00	DIA	ETF	111.9	111.9	111.9	111.9	300.0
2010-11-02 08:00:00	DIA	ETF	111.88	112.05	111.83	112.0	7415.0
2010-11-02 09:00:00	DIA	ETF	111.99	112.28	111.96	112.12	902832.0

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

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