PREVIEW / etf_1hour / 2010-02-19

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-19.parquet
  size:    155 KB
  rows:    4,821

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-19 04:00:00	SPY	ETF	110.33	110.33	110.17	110.17	1000.0
2010-02-19 05:00:00	SPY	ETF	110.15	110.19	110.06	110.11	5000.0
2010-02-19 06:00:00	SPY	ETF	110.2	110.25	110.15	110.2	80007.0
2010-02-19 07:00:00	SPY	ETF	110.16	110.44	110.16	110.41	1628298.0
2010-02-19 08:00:00	SPY	ETF	110.42	110.83	110.23	110.76	6916186.0
2010-02-19 09:00:00	SPY	ETF	110.76	110.92	110.41	110.44	26871981.0
2010-02-19 10:00:00	SPY	ETF	110.43	111.0	110.36	110.86	30091252.0
2010-02-19 11:00:00	SPY	ETF	110.86	111.44	110.5	111.41	30014599.0
2010-02-19 12:00:00	SPY	ETF	111.41	111.57	111.355	111.51	18594687.0
2010-02-19 13:00:00	SPY	ETF	111.5	111.52	111.18	111.2499	14981641.0
2010-02-19 14:00:00	SPY	ETF	111.24	111.35	111.11	111.24	14957318.0
2010-02-19 15:00:00	SPY	ETF	111.24	111.42	110.97	111.19	40105286.0
2010-02-19 16:00:00	SPY	ETF	111.19	111.56	109.9889	111.09	20968052.0
2010-02-19 17:00:00	SPY	ETF	111.08	111.31	110.9889	111.2	10216574.0
2010-02-19 18:00:00	SPY	ETF	111.18	111.2	111.13	111.17	53391.0
2010-02-19 19:00:00	SPY	ETF	111.18	111.3	110.9889	111.3	7064221.0
2010-02-19 05:00:00	QQQ	ETF	44.57	44.57	44.54	44.54	8000.0
2010-02-19 06:00:00	QQQ	ETF	44.6	44.62	44.58	44.6	16000.0
2010-02-19 07:00:00	QQQ	ETF	44.6	44.72	44.6	44.68	655156.0
2010-02-19 08:00:00	QQQ	ETF	44.68	44.81	44.64	44.77	1437032.0
2010-02-19 09:00:00	QQQ	ETF	44.78	44.82	44.64	44.645	8472722.0
2010-02-19 10:00:00	QQQ	ETF	44.65	44.83	44.62	44.77	10642776.0
2010-02-19 11:00:00	QQQ	ETF	44.78	45.02	44.75	44.9995	14049651.0
2010-02-19 12:00:00	QQQ	ETF	44.99	45.05	44.935	45.02	8124428.0
2010-02-19 13:00:00	QQQ	ETF	45.02	45.05	44.88	44.92	6397686.0
2010-02-19 14:00:00	QQQ	ETF	44.9201	44.94	44.7	44.87	4577350.0
2010-02-19 15:00:00	QQQ	ETF	44.87	44.9	44.76	44.84	17097062.0
2010-02-19 16:00:00	QQQ	ETF	44.84	44.98	44.77	44.81	5498747.0
2010-02-19 17:00:00	QQQ	ETF	44.81	44.83	44.78	44.83	138048.0
2010-02-19 18:00:00	QQQ	ETF	44.81	44.83	44.81	44.82	19500.0
2010-02-19 19:00:00	QQQ	ETF	44.83	44.87	44.81	44.87	15200.0
2010-02-19 06:00:00	IWM	ETF	62.59	62.59	62.59	62.59	120.0
2010-02-19 07:00:00	IWM	ETF	62.6	62.73	62.56	62.67	229961.0
2010-02-19 08:00:00	IWM	ETF	62.67	62.94	62.38	62.84	329871.0
2010-02-19 09:00:00	IWM	ETF	62.84	63.02	62.68	62.69	7325797.0
2010-02-19 10:00:00	IWM	ETF	62.68	62.99	62.61	62.9	7245441.0
2010-02-19 11:00:00	IWM	ETF	62.8905	63.27	62.86	63.24	6961309.0
2010-02-19 12:00:00	IWM	ETF	63.24	63.38	63.2	63.29	4387001.0
2010-02-19 13:00:00	IWM	ETF	63.29	63.31	63.12	63.19	3212618.0
2010-02-19 14:00:00	IWM	ETF	63.188	63.27	63.13	63.21	4002385.0
2010-02-19 15:00:00	IWM	ETF	63.22	63.26	63.08	63.08	10641542.0
2010-02-19 16:00:00	IWM	ETF	63.085	63.2461	62.7529	63.16	9612288.0
2010-02-19 17:00:00	IWM	ETF	63.17	63.22	63.13	63.16	56103.0
2010-02-19 18:00:00	IWM	ETF	63.14	63.14	63.11	63.11	3885.0
2010-02-19 19:00:00	IWM	ETF	63.11	63.13	63.11	63.13	5100.0
2010-02-19 07:00:00	DIA	ETF	103.56	103.74	103.5	103.53	25714.0
2010-02-19 08:00:00	DIA	ETF	103.54	103.89	103.49	103.81	46202.0
2010-02-19 09:00:00	DIA	ETF	103.83	103.92	103.48	103.48	1371178.0
2010-02-19 10:00:00	DIA	ETF	103.49	103.95	103.415	103.84	1500243.0
2010-02-19 11:00:00	DIA	ETF	103.84	104.27	103.81	104.25	1456897.0

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

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