PREVIEW / etf_1hour / 2010-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-09.parquet
  size:    156 KB
  rows:    4,863

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-09 04:00:00	SPY	ETF	106.89	107.14	106.89	106.94	23704.0
2010-02-09 05:00:00	SPY	ETF	106.87	106.96	106.75	106.8	31200.0
2010-02-09 06:00:00	SPY	ETF	106.77	106.79	106.57	106.79	127139.0
2010-02-09 07:00:00	SPY	ETF	106.7	107.16	106.7	106.98	883378.0
2010-02-09 08:00:00	SPY	ETF	107.04	107.21	106.89	107.05	4390015.0
2010-02-09 09:00:00	SPY	ETF	107.04	107.35	106.82	106.955	30197586.0
2010-02-09 10:00:00	SPY	ETF	106.95	107.44	106.73	106.79	37291478.0
2010-02-09 11:00:00	SPY	ETF	106.78	107.63	106.27	107.33	79829815.0
2010-02-09 12:00:00	SPY	ETF	107.322	108.15	107.11	107.521	71107429.0
2010-02-09 13:00:00	SPY	ETF	107.53	107.76	107.33	107.54	21620284.0
2010-02-09 14:00:00	SPY	ETF	107.53	107.62	107.1	107.2	29086496.0
2010-02-09 15:00:00	SPY	ETF	107.205	107.89	107.02	107.24	45203630.0
2010-02-09 16:00:00	SPY	ETF	107.23	107.86	105.8653	107.19	15046537.0
2010-02-09 17:00:00	SPY	ETF	107.19	107.23	107.14	107.21	53488.0
2010-02-09 18:00:00	SPY	ETF	107.18	107.29	107.18	107.23	62160.0
2010-02-09 19:00:00	SPY	ETF	107.24	107.31	107.1	107.29	59489.0
2010-02-09 04:00:00	QQQ	ETF	43.05	43.13	43.05	43.1	3400.0
2010-02-09 05:00:00	QQQ	ETF	43.04	43.04	43.03	43.03	4600.0
2010-02-09 06:00:00	QQQ	ETF	43.0	43.88	42.96	43.0	160939.0
2010-02-09 07:00:00	QQQ	ETF	42.97	43.15	42.96	43.09	102187.0
2010-02-09 08:00:00	QQQ	ETF	43.07	43.17	43.05	43.13	813441.0
2010-02-09 09:00:00	QQQ	ETF	43.12	43.24	42.67	43.08	11546129.0
2010-02-09 10:00:00	QQQ	ETF	43.07	43.27	42.98	42.99	15325351.0
2010-02-09 11:00:00	QQQ	ETF	42.99	43.26	42.76	43.18	26817378.0
2010-02-09 12:00:00	QQQ	ETF	43.18	43.51	43.1	43.23	24764607.0
2010-02-09 13:00:00	QQQ	ETF	43.22	43.32	43.16	43.24	6791296.0
2010-02-09 14:00:00	QQQ	ETF	43.25	43.31	43.09	43.1207	8325350.0
2010-02-09 15:00:00	QQQ	ETF	43.13	43.3	43.06	43.12	15651514.0
2010-02-09 16:00:00	QQQ	ETF	43.12	43.27	42.6654	43.18	7169373.0
2010-02-09 17:00:00	QQQ	ETF	43.18	43.22	43.16	43.16	61714.0
2010-02-09 18:00:00	QQQ	ETF	43.19	43.23	43.19	43.2	91082.0
2010-02-09 19:00:00	QQQ	ETF	43.19	43.23	43.16	43.22	19810.0
2010-02-09 06:00:00	IWM	ETF	59.31	59.31	59.31	59.31	4000.0
2010-02-09 07:00:00	IWM	ETF	59.29	59.5	59.29	59.42	97390.0
2010-02-09 08:00:00	IWM	ETF	59.37	59.48	59.34	59.41	245244.0
2010-02-09 09:00:00	IWM	ETF	59.4	59.59	59.04	59.11	8158938.0
2010-02-09 10:00:00	IWM	ETF	59.12	59.54	59.02	59.1	9357902.0
2010-02-09 11:00:00	IWM	ETF	59.11	59.43	58.75	59.27	17996072.0
2010-02-09 12:00:00	IWM	ETF	59.28	59.9286	59.23	59.47	19283945.0
2010-02-09 13:00:00	IWM	ETF	59.48	59.9286	59.3	59.435	7613832.0
2010-02-09 14:00:00	IWM	ETF	59.44	59.57	59.27	59.34	6661356.0
2010-02-09 15:00:00	IWM	ETF	59.34	59.63	59.32	59.46	11906248.0
2010-02-09 16:00:00	IWM	ETF	59.47	59.5723	58.6608	59.46	4963175.0
2010-02-09 17:00:00	IWM	ETF	58.6609	59.45	58.6609	59.45	1001262.0
2010-02-09 18:00:00	IWM	ETF	59.5	59.51	59.47	59.49	2100.0
2010-02-09 19:00:00	IWM	ETF	59.46	59.51	59.46	59.46	7000.0
2010-02-09 07:00:00	DIA	ETF	99.81	100.07	99.81	100.0	4867.0
2010-02-09 08:00:00	DIA	ETF	100.0	100.22	100.0	100.09	48600.0
2010-02-09 09:00:00	DIA	ETF	100.08	100.52	100.02	100.37	1903520.0
2010-02-09 10:00:00	DIA	ETF	100.37	100.82	100.23	100.31	1991548.0

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

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