PREVIEW / etf_1hour / 2010-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-19.parquet
  size:    161 KB
  rows:    4,934

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-08-19 04:00:00	SPY	ETF	109.13	109.31	109.11	109.3	6889.0
2010-08-19 05:00:00	SPY	ETF	109.36	109.44	109.36	109.44	5470.0
2010-08-19 06:00:00	SPY	ETF	109.43	109.85	109.43	109.77	47313.0
2010-08-19 07:00:00	SPY	ETF	109.76	109.8	109.61	109.76	772616.0
2010-08-19 08:00:00	SPY	ETF	109.73	110.0	108.87	109.23	14334790.0
2010-08-19 09:00:00	SPY	ETF	109.22	109.49	108.87	108.98	27449401.0
2010-08-19 10:00:00	SPY	ETF	108.98	109.01	107.92	108.21	49494601.0
2010-08-19 11:00:00	SPY	ETF	108.22	108.23	107.43	107.62	37862615.0
2010-08-19 12:00:00	SPY	ETF	107.61	107.91	107.52	107.84	25029078.0
2010-08-19 13:00:00	SPY	ETF	107.84	107.95	107.6	107.6299	13888647.0
2010-08-19 14:00:00	SPY	ETF	107.63	108.03	107.48	107.85	30144296.0
2010-08-19 15:00:00	SPY	ETF	107.85	108.35	107.74	107.92	46429164.0
2010-08-19 16:00:00	SPY	ETF	107.92	109.7897	107.495	107.79	13757957.0
2010-08-19 17:00:00	SPY	ETF	107.79	107.86	107.72	107.76	152580.0
2010-08-19 18:00:00	SPY	ETF	107.77	107.88	107.71	107.75	62067.0
2010-08-19 19:00:00	SPY	ETF	107.76	107.86	107.75	107.86	26095.0
2010-08-19 04:00:00	QQQ	ETF	45.2	45.2	45.2	45.2	200.0
2010-08-19 05:00:00	QQQ	ETF	45.25	45.25	45.25	45.25	111.0
2010-08-19 06:00:00	QQQ	ETF	45.35	45.45	45.35	45.42	2000.0
2010-08-19 07:00:00	QQQ	ETF	45.46	45.46	45.37	45.45	485995.0
2010-08-19 08:00:00	QQQ	ETF	45.43	45.54	45.13	45.29	5797874.0
2010-08-19 09:00:00	QQQ	ETF	45.29	45.46	45.19	45.24	8637671.0
2010-08-19 10:00:00	QQQ	ETF	45.23	45.235	44.83	44.92	17290075.0
2010-08-19 11:00:00	QQQ	ETF	44.92	44.94	44.56	44.66	10242836.0
2010-08-19 12:00:00	QQQ	ETF	44.65	44.81	44.59	44.79	6432215.0
2010-08-19 13:00:00	QQQ	ETF	44.785	44.85	44.71	44.72	3218805.0
2010-08-19 14:00:00	QQQ	ETF	44.72	44.9	44.67	44.84	4127663.0
2010-08-19 15:00:00	QQQ	ETF	44.83	45.05	44.78	44.86	9705874.0
2010-08-19 16:00:00	QQQ	ETF	44.86	45.5296	44.7273	44.83	7555451.0
2010-08-19 17:00:00	QQQ	ETF	44.83	44.89	44.82	44.85	228742.0
2010-08-19 18:00:00	QQQ	ETF	44.87	44.87	44.85	44.85	44152.0
2010-08-19 19:00:00	QQQ	ETF	44.85	44.88	44.85	44.88	9350.0
2010-08-19 04:00:00	IWM	ETF	62.26	62.26	62.26	62.26	644.0
2010-08-19 05:00:00	IWM	ETF	62.44	62.44	62.41	62.41	844.0
2010-08-19 06:00:00	IWM	ETF	62.47	62.63	62.47	62.63	1843.0
2010-08-19 07:00:00	IWM	ETF	62.68	62.72	62.62	62.71	44300.0
2010-08-19 08:00:00	IWM	ETF	62.69	62.97	62.23	62.52	4493033.0
2010-08-19 09:00:00	IWM	ETF	62.54	62.78	62.26	62.36	7015349.0
2010-08-19 10:00:00	IWM	ETF	62.36	62.4	61.54	61.6	14479584.0
2010-08-19 11:00:00	IWM	ETF	61.6	61.7	60.94	61.13	9200897.0
2010-08-19 12:00:00	IWM	ETF	61.13	61.35	61.0422	61.21	7316003.0
2010-08-19 13:00:00	IWM	ETF	61.22	61.36	61.1	61.12	3970137.0
2010-08-19 14:00:00	IWM	ETF	61.12	61.45	60.97	61.19	7550031.0
2010-08-19 15:00:00	IWM	ETF	61.18	61.63	61.11	61.13	10834936.0
2010-08-19 16:00:00	IWM	ETF	61.12	62.8548	61.05	61.17	14457604.0
2010-08-19 17:00:00	IWM	ETF	61.17	62.852	61.13	61.17	3010817.0
2010-08-19 18:00:00	IWM	ETF	61.16	61.18	61.14	61.16	4669.0
2010-08-19 19:00:00	IWM	ETF	61.2	61.21	61.17	61.21	600.0
2010-08-19 07:00:00	DIA	ETF	104.55	104.55	104.52	104.52	1900.0
2010-08-19 08:00:00	DIA	ETF	104.54	104.72	103.83	104.07	104760.0

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

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