PREVIEW / etf_1hour / 2010-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-03.parquet
  size:    154 KB
  rows:    4,778

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-03-03 04:00:00	SPY	ETF	112.01	112.01	112.01	112.01	1000.0
2010-03-03 05:00:00	SPY	ETF	112.24	112.24	112.24	112.24	500.0
2010-03-03 06:00:00	SPY	ETF	112.25	112.39	112.17	112.25	60100.0
2010-03-03 07:00:00	SPY	ETF	112.26	112.27	112.02	112.11	1002941.0
2010-03-03 08:00:00	SPY	ETF	112.12	112.53	112.03	112.42	3339847.0
2010-03-03 09:00:00	SPY	ETF	112.43	112.74	112.3	112.63	14731804.0
2010-03-03 10:00:00	SPY	ETF	112.64	112.92	112.4	112.85	27297037.0
2010-03-03 11:00:00	SPY	ETF	112.85	112.97	112.79	112.84	17375685.0
2010-03-03 12:00:00	SPY	ETF	112.84	112.84	112.53	112.585	11213329.0
2010-03-03 13:00:00	SPY	ETF	112.59	112.74	112.53	112.68	8611638.0
2010-03-03 14:00:00	SPY	ETF	112.68	112.73	112.02	112.19	27535880.0
2010-03-03 15:00:00	SPY	ETF	112.19	112.47	112.15	112.28	28002149.0
2010-03-03 16:00:00	SPY	ETF	112.29	112.7	112.1307	112.3	9003195.0
2010-03-03 17:00:00	SPY	ETF	112.29	112.31	112.24	112.3	70513.0
2010-03-03 18:00:00	SPY	ETF	112.3	112.4499	112.22	112.22	143021.0
2010-03-03 19:00:00	SPY	ETF	112.23	112.29	112.21	112.23	89456.0
2010-03-03 05:00:00	QQQ	ETF	45.59	45.59	45.59	45.59	400.0
2010-03-03 06:00:00	QQQ	ETF	45.61	45.65	45.58	45.65	1000.0
2010-03-03 07:00:00	QQQ	ETF	45.59	45.6	45.48	45.51	545223.0
2010-03-03 08:00:00	QQQ	ETF	45.53	45.68	45.51	45.65	1238732.0
2010-03-03 09:00:00	QQQ	ETF	45.64	45.76	45.57	45.705	6114473.0
2010-03-03 10:00:00	QQQ	ETF	45.71	45.81	45.62	45.775	12260672.0
2010-03-03 11:00:00	QQQ	ETF	45.78	45.82	45.73	45.78	6649891.0
2010-03-03 12:00:00	QQQ	ETF	45.77	45.775	45.6	45.64	5701199.0
2010-03-03 13:00:00	QQQ	ETF	45.64	45.71	45.62	45.69	5500481.0
2010-03-03 14:00:00	QQQ	ETF	45.69	45.71	45.43	45.48	10070880.0
2010-03-03 15:00:00	QQQ	ETF	45.48	45.64	45.43	45.59	11962051.0
2010-03-03 16:00:00	QQQ	ETF	45.59	45.7867	45.54	45.55	2852778.0
2010-03-03 17:00:00	QQQ	ETF	45.54	45.57	45.52	45.55	43275.0
2010-03-03 18:00:00	QQQ	ETF	45.55	45.56	45.53	45.53	4050.0
2010-03-03 19:00:00	QQQ	ETF	45.53	45.54	45.52	45.53	7794.0
2010-03-03 07:00:00	IWM	ETF	64.89	64.89	64.76	64.85	73399.0
2010-03-03 08:00:00	IWM	ETF	64.84	65.06	64.75	65.02	637684.0
2010-03-03 09:00:00	IWM	ETF	65.01	65.18	64.899	65.08	5520466.0
2010-03-03 10:00:00	IWM	ETF	65.1	65.37	64.97	65.32	10493926.0
2010-03-03 11:00:00	IWM	ETF	65.33	65.49	65.1	65.42	6847549.0
2010-03-03 12:00:00	IWM	ETF	65.42	65.42	65.1	65.17	3437561.0
2010-03-03 13:00:00	IWM	ETF	65.175	65.32	65.1499	65.31	3146483.0
2010-03-03 14:00:00	IWM	ETF	65.31	65.32	64.78	64.81	9005157.0
2010-03-03 15:00:00	IWM	ETF	64.81	65.14	64.8	65.06	9273799.0
2010-03-03 16:00:00	IWM	ETF	65.06	65.4494	64.8291	65.07	6093984.0
2010-03-03 17:00:00	IWM	ETF	65.06	65.1	65.06	65.1	24798.0
2010-03-03 18:00:00	IWM	ETF	65.09	65.1	65.07	65.07	1400.0
2010-03-03 19:00:00	IWM	ETF	65.06	65.07	65.03	65.03	4595.0
2010-03-03 06:00:00	DIA	ETF	104.16	104.16	104.16	104.16	500.0
2010-03-03 07:00:00	DIA	ETF	104.02	104.02	104.02	104.02	100.0
2010-03-03 08:00:00	DIA	ETF	104.06	104.35	103.93	104.29	18000.0
2010-03-03 09:00:00	DIA	ETF	104.34	104.53	104.2	104.45	600465.0
2010-03-03 10:00:00	DIA	ETF	104.48	104.73	104.36	104.63	1225841.0
2010-03-03 11:00:00	DIA	ETF	104.65	104.77	104.55	104.56	714068.0

> showing 50 of 4,778 rows — these rows as CSV

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