PREVIEW / etf_1hour / 2010-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-17.parquet
  size:    150 KB
  rows:    4,751

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-17 04:00:00	SPY	ETF	110.19	110.29	110.15	110.23	6661.0
2010-02-17 05:00:00	SPY	ETF	110.15	110.2	110.1	110.12	29100.0
2010-02-17 06:00:00	SPY	ETF	110.11	110.2	110.0	110.2	72200.0
2010-02-17 07:00:00	SPY	ETF	110.13	110.44	110.08	110.38	926230.0
2010-02-17 08:00:00	SPY	ETF	110.38	110.45	110.11	110.36	3168785.0
2010-02-17 09:00:00	SPY	ETF	110.37	110.38	110.0	110.12	26830138.0
2010-02-17 10:00:00	SPY	ETF	110.12	110.41	109.93	110.11	32524179.0
2010-02-17 11:00:00	SPY	ETF	110.1	110.15	109.74	109.97	26745081.0
2010-02-17 12:00:00	SPY	ETF	109.98	110.22	109.975	110.18	12392244.0
2010-02-17 13:00:00	SPY	ETF	110.19	110.29	109.8	110.11	10718349.0
2010-02-17 14:00:00	SPY	ETF	110.11	110.24	109.85	110.21	20672388.0
2010-02-17 15:00:00	SPY	ETF	110.205	110.34	110.1	110.26	24075939.0
2010-02-17 16:00:00	SPY	ETF	110.26	110.46	109.0215	110.35	10223466.0
2010-02-17 17:00:00	SPY	ETF	110.36	110.46	110.26	110.4	155359.0
2010-02-17 18:00:00	SPY	ETF	110.4	110.4	110.34	110.34	64421.0
2010-02-17 19:00:00	SPY	ETF	110.35	110.36	110.18	110.2	170644.0
2010-02-17 04:00:00	QQQ	ETF	44.44	44.46	44.44	44.46	2150.0
2010-02-17 05:00:00	QQQ	ETF	44.43	44.43	44.41	44.41	1000.0
2010-02-17 06:00:00	QQQ	ETF	44.4	44.4	44.4	44.4	100.0
2010-02-17 07:00:00	QQQ	ETF	44.39	44.6	44.33	44.47	1033425.0
2010-02-17 08:00:00	QQQ	ETF	44.36	44.55	44.35	44.51	3598754.0
2010-02-17 09:00:00	QQQ	ETF	44.52	44.55	44.33	44.43	15129581.0
2010-02-17 10:00:00	QQQ	ETF	44.44	44.57	44.39	44.505	15040722.0
2010-02-17 11:00:00	QQQ	ETF	44.51	44.51	44.26	44.37	13300298.0
2010-02-17 12:00:00	QQQ	ETF	44.37	44.47	44.35	44.45	4969840.0
2010-02-17 13:00:00	QQQ	ETF	44.46	44.525	44.45	44.48	4125918.0
2010-02-17 14:00:00	QQQ	ETF	44.48	44.51	44.4	44.51	8377212.0
2010-02-17 15:00:00	QQQ	ETF	44.5099	44.57	44.48	44.57	8180840.0
2010-02-17 16:00:00	QQQ	ETF	44.57	44.65	44.3374	44.59	4664146.0
2010-02-17 17:00:00	QQQ	ETF	44.62	44.63	44.59	44.61	88538.0
2010-02-17 18:00:00	QQQ	ETF	44.61	44.61	44.59	44.59	49036.0
2010-02-17 19:00:00	QQQ	ETF	44.59	44.59	44.55	44.57	182310.0
2010-02-17 07:00:00	IWM	ETF	62.21	62.4	62.2	62.34	40000.0
2010-02-17 08:00:00	IWM	ETF	62.33	62.45	62.32	62.43	455764.0
2010-02-17 09:00:00	IWM	ETF	62.44	62.49	62.14	62.37	7756948.0
2010-02-17 10:00:00	IWM	ETF	62.37	62.61	62.29	62.36	7704649.0
2010-02-17 11:00:00	IWM	ETF	62.35	62.36	61.99	62.17	6066239.0
2010-02-17 12:00:00	IWM	ETF	62.17	62.32	62.1675	62.31	2345362.0
2010-02-17 13:00:00	IWM	ETF	62.32	62.45	62.27	62.335	3967487.0
2010-02-17 14:00:00	IWM	ETF	62.345	62.42	62.19	62.26	5003214.0
2010-02-17 15:00:00	IWM	ETF	62.26	62.49	62.22	62.47	8442044.0
2010-02-17 16:00:00	IWM	ETF	62.47	62.67	62.1111	62.58	6891826.0
2010-02-17 17:00:00	IWM	ETF	62.55	62.61	62.53	62.59	40100.0
2010-02-17 18:00:00	IWM	ETF	62.55	62.55	62.51	62.51	3300.0
2010-02-17 19:00:00	IWM	ETF	62.48	62.48	62.42	62.46	3285.0
2010-02-17 06:00:00	DIA	ETF	103.15	103.15	103.15	103.15	200.0
2010-02-17 07:00:00	DIA	ETF	103.17	103.22	103.17	103.22	300.0
2010-02-17 08:00:00	DIA	ETF	103.25	103.32	103.18	103.24	41179.0
2010-02-17 09:00:00	DIA	ETF	103.24	103.39	103.06	103.24	1290225.0
2010-02-17 10:00:00	DIA	ETF	103.24	103.44	103.07	103.19	1708975.0

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

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