PREVIEW / etf_1hour / 2010-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-12.parquet
  size:    154 KB
  rows:    4,772

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-02-12 04:00:00	SPY	ETF	108.09	108.09	107.8	107.84	7766.0
2010-02-12 05:00:00	SPY	ETF	107.65	107.65	107.12	107.39	88775.0
2010-02-12 06:00:00	SPY	ETF	107.34	107.5	107.14	107.45	224784.0
2010-02-12 07:00:00	SPY	ETF	107.4	107.5	107.27	107.32	920632.0
2010-02-12 08:00:00	SPY	ETF	107.36	107.66	107.09	107.46	5343372.0
2010-02-12 09:00:00	SPY	ETF	107.47	107.55	106.51	106.9	46479810.0
2010-02-12 10:00:00	SPY	ETF	106.9	107.21	106.51	106.92	39204484.0
2010-02-12 11:00:00	SPY	ETF	106.92	107.27	106.74	107.13	22785030.0
2010-02-12 12:00:00	SPY	ETF	107.12	108.1012	107.12	107.71	38278629.0
2010-02-12 13:00:00	SPY	ETF	107.7099	107.7157	107.03	107.35	34917136.0
2010-02-12 14:00:00	SPY	ETF	107.34	108.07	107.27	107.622	33586383.0
2010-02-12 15:00:00	SPY	ETF	107.62	108.05	107.28	108.02	51671322.0
2010-02-12 16:00:00	SPY	ETF	108.01	108.4	106.85	108.35	28050314.0
2010-02-12 17:00:00	SPY	ETF	108.34	108.35	108.0616	108.29	1685662.0
2010-02-12 18:00:00	SPY	ETF	108.29	108.35	108.04	108.25	262495.0
2010-02-12 19:00:00	SPY	ETF	108.21	108.35	108.2	108.32	23992.0
2010-02-12 04:00:00	QQQ	ETF	43.63	43.63	43.52	43.52	5655.0
2010-02-12 05:00:00	QQQ	ETF	43.5	43.5	43.36	43.37	11987.0
2010-02-12 06:00:00	QQQ	ETF	43.33	43.38	43.31	43.37	171392.0
2010-02-12 07:00:00	QQQ	ETF	43.37	43.42	43.34	43.38	445636.0
2010-02-12 08:00:00	QQQ	ETF	43.39	43.5	43.27	43.44	504279.0
2010-02-12 09:00:00	QQQ	ETF	43.45	43.45	43.16	43.36	13850671.0
2010-02-12 10:00:00	QQQ	ETF	43.36	43.48	43.2	43.33	15694854.0
2010-02-12 11:00:00	QQQ	ETF	43.32	43.53	43.28	43.51	6248808.0
2010-02-12 12:00:00	QQQ	ETF	43.51	43.85	43.51	43.76	12540177.0
2010-02-12 13:00:00	QQQ	ETF	43.76	43.76	43.5	43.62	10862921.0
2010-02-12 14:00:00	QQQ	ETF	43.6201	43.88	43.6	43.74	12185379.0
2010-02-12 15:00:00	QQQ	ETF	43.75	43.81	43.62	43.78	14674209.0
2010-02-12 16:00:00	QQQ	ETF	43.77	43.9	43.16	43.86	4859424.0
2010-02-12 17:00:00	QQQ	ETF	43.87	43.88	43.83	43.86	37350.0
2010-02-12 18:00:00	QQQ	ETF	43.86	43.86	43.85	43.85	5200.0
2010-02-12 19:00:00	QQQ	ETF	43.86	43.86	43.86	43.86	1000.0
2010-02-12 07:00:00	IWM	ETF	60.22	60.27	60.16	60.19	88932.0
2010-02-12 08:00:00	IWM	ETF	60.2	60.33	60.03	60.24	375475.0
2010-02-12 09:00:00	IWM	ETF	60.25	60.29	59.81	60.05	8412221.0
2010-02-12 10:00:00	IWM	ETF	60.05	60.31	59.82	60.19	7755802.0
2010-02-12 11:00:00	IWM	ETF	60.18	60.36	60.08	60.29	3855301.0
2010-02-12 12:00:00	IWM	ETF	60.29	60.71	60.29	60.5938	7047995.0
2010-02-12 13:00:00	IWM	ETF	60.6	60.62	60.32	60.53	8397405.0
2010-02-12 14:00:00	IWM	ETF	60.52	60.89	60.49	60.67	7970165.0
2010-02-12 15:00:00	IWM	ETF	60.67	61.05	60.4219	61.04	15325946.0
2010-02-12 16:00:00	IWM	ETF	61.04	61.34	59.99	61.17	3383951.0
2010-02-12 17:00:00	IWM	ETF	61.2	61.29	61.19	61.2	31494.0
2010-02-12 18:00:00	IWM	ETF	61.2	61.22	61.16	61.17	4283.0
2010-02-12 19:00:00	IWM	ETF	61.18	61.18	61.17	61.17	212.0
2010-02-12 07:00:00	DIA	ETF	100.8	100.8	100.75	100.75	5950.0
2010-02-12 08:00:00	DIA	ETF	100.94	101.08	100.78	100.93	74503.0
2010-02-12 09:00:00	DIA	ETF	100.97	101.0	100.08	100.35	2290263.0
2010-02-12 10:00:00	DIA	ETF	100.3519	100.56	99.99	100.34	2511715.0
2010-02-12 11:00:00	DIA	ETF	100.33	100.6136	100.2	100.5401	1060461.0

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

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