PREVIEW / etf_1hour / 2010-02-18

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-18.parquet
  size:    158 KB
  rows:    4,874

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-18 04:00:00	SPY	ETF	110.01	110.04	109.93	110.04	800.0
2010-02-18 05:00:00	SPY	ETF	110.21	110.35	110.18	110.35	2300.0
2010-02-18 06:00:00	SPY	ETF	110.28	110.33	110.18	110.25	6050.0
2010-02-18 07:00:00	SPY	ETF	110.21	110.3	110.11	110.21	457796.0
2010-02-18 08:00:00	SPY	ETF	110.21	110.34	109.78	109.9	5215542.0
2010-02-18 09:00:00	SPY	ETF	109.89	110.57	109.88	110.44	25179618.0
2010-02-18 10:00:00	SPY	ETF	110.44	110.66	110.1	110.44	26959817.0
2010-02-18 11:00:00	SPY	ETF	110.44	110.52	110.25	110.39	17033205.0
2010-02-18 12:00:00	SPY	ETF	110.39	110.45	110.27	110.34	10312773.0
2010-02-18 13:00:00	SPY	ETF	110.34	110.61	110.31	110.54	13510174.0
2010-02-18 14:00:00	SPY	ETF	110.54	111.03	110.4	110.99	27768713.0
2010-02-18 15:00:00	SPY	ETF	110.99	111.14	110.87	110.96	37622956.0
2010-02-18 16:00:00	SPY	ETF	110.96	111.05	109.91	110.09	22117318.0
2010-02-18 17:00:00	SPY	ETF	110.13	110.3	110.05	110.24	1846503.0
2010-02-18 18:00:00	SPY	ETF	110.23	110.26	109.91	109.99	611209.0
2010-02-18 19:00:00	SPY	ETF	109.99	110.25	109.9	110.12	248105.0
2010-02-18 04:00:00	QQQ	ETF	44.5	44.58	44.5	44.58	20000.0
2010-02-18 05:00:00	QQQ	ETF	44.6	44.66	44.6	44.66	16100.0
2010-02-18 06:00:00	QQQ	ETF	44.65	44.65	44.65	44.65	1000.0
2010-02-18 07:00:00	QQQ	ETF	44.65	44.67	44.6	44.67	537722.0
2010-02-18 08:00:00	QQQ	ETF	44.61	44.67	44.44	44.48	2018586.0
2010-02-18 09:00:00	QQQ	ETF	44.49	44.6	44.45	44.565	9226269.0
2010-02-18 10:00:00	QQQ	ETF	44.58	44.73	44.5	44.7	12441299.0
2010-02-18 11:00:00	QQQ	ETF	44.69	44.76	44.62	44.68	6700865.0
2010-02-18 12:00:00	QQQ	ETF	44.68	44.71	44.5974	44.63	3644892.0
2010-02-18 13:00:00	QQQ	ETF	44.63	44.72	44.61	44.7	4120337.0
2010-02-18 14:00:00	QQQ	ETF	44.7	44.92	44.66	44.9	9370359.0
2010-02-18 15:00:00	QQQ	ETF	44.91	44.93	44.84	44.86	10796556.0
2010-02-18 16:00:00	QQQ	ETF	44.85	44.8952	44.47	44.54	4796724.0
2010-02-18 17:00:00	QQQ	ETF	44.54	44.57	44.49	44.56	498142.0
2010-02-18 18:00:00	QQQ	ETF	44.54	44.54	44.46	44.48	171375.0
2010-02-18 19:00:00	QQQ	ETF	44.46	44.54	44.45	44.53	79408.0
2010-02-18 07:00:00	IWM	ETF	62.56	62.58	62.43	62.53	132428.0
2010-02-18 08:00:00	IWM	ETF	62.52	62.59	62.31	62.37	715445.0
2010-02-18 09:00:00	IWM	ETF	62.38	62.58	62.25	62.51	6368472.0
2010-02-18 10:00:00	IWM	ETF	62.51	62.6	62.28	62.56	6471494.0
2010-02-18 11:00:00	IWM	ETF	62.56	62.61	62.46	62.5	4134332.0
2010-02-18 12:00:00	IWM	ETF	62.5	62.535	62.41	62.48	2195671.0
2010-02-18 13:00:00	IWM	ETF	62.48	62.64	62.42	62.605	2690305.0
2010-02-18 14:00:00	IWM	ETF	62.61	62.8093	62.52	62.8	4129292.0
2010-02-18 15:00:00	IWM	ETF	62.79	63.0	62.45	63.0	10958067.0
2010-02-18 16:00:00	IWM	ETF	63.0	63.0	62.42	62.48	4232480.0
2010-02-18 17:00:00	IWM	ETF	62.48	62.61	62.48	62.53	137529.0
2010-02-18 18:00:00	IWM	ETF	62.53	62.54	62.36	62.36	37336.0
2010-02-18 19:00:00	IWM	ETF	62.37	62.42	62.33	62.4	10434.0
2010-02-18 07:00:00	DIA	ETF	103.29	103.29	103.29	103.29	200.0
2010-02-18 08:00:00	DIA	ETF	103.28	103.39	102.93	103.03	175191.0
2010-02-18 09:00:00	DIA	ETF	103.07	103.75	103.02	103.64	1207262.0
2010-02-18 10:00:00	DIA	ETF	103.64	103.83	103.34	103.56	1795210.0
2010-02-18 11:00:00	DIA	ETF	103.56	103.64	103.41	103.55	905020.0

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

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