PREVIEW / etf_1hour / 2010-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-17.parquet
  size:    167 KB
  rows:    5,120

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-05-17 04:00:00	SPY	ETF	113.63	113.84	113.53	113.76	1800.0
2010-05-17 05:00:00	SPY	ETF	114.01	114.27	114.01	114.03	17986.0
2010-05-17 06:00:00	SPY	ETF	113.99	114.38	113.99	114.14	167430.0
2010-05-17 07:00:00	SPY	ETF	114.11	114.46	114.09	114.3	546837.0
2010-05-17 08:00:00	SPY	ETF	114.28	114.33	112.6	113.9	5238046.0
2010-05-17 09:00:00	SPY	ETF	113.9	114.52	113.57	113.71	29911641.0
2010-05-17 10:00:00	SPY	ETF	113.7	114.12	113.52	113.53	37808543.0
2010-05-17 11:00:00	SPY	ETF	113.53	113.75	112.61	112.6475	38620728.0
2010-05-17 12:00:00	SPY	ETF	112.65	112.65	111.77	112.23	51313051.0
2010-05-17 13:00:00	SPY	ETF	112.23	112.95	112.19	112.76	35136730.0
2010-05-17 14:00:00	SPY	ETF	112.76	113.45	112.69	113.4	39967200.0
2010-05-17 15:00:00	SPY	ETF	113.4	114.15	112.86	113.95	70708950.0
2010-05-17 16:00:00	SPY	ETF	113.95	114.27	111.91	114.17	7325101.0
2010-05-17 17:00:00	SPY	ETF	114.15	114.17	114.07	114.14	111361.0
2010-05-17 18:00:00	SPY	ETF	114.11	114.25	114.08	114.19	170745.0
2010-05-17 19:00:00	SPY	ETF	114.16	114.17	114.01	114.13	74543.0
2010-05-17 04:00:00	QQQ	ETF	46.89	46.92	46.89	46.92	600.0
2010-05-17 05:00:00	QQQ	ETF	47.0	47.09	47.0	47.01	8900.0
2010-05-17 06:00:00	QQQ	ETF	47.09	47.1	47.05	47.08	5452.0
2010-05-17 07:00:00	QQQ	ETF	47.05	47.19	47.04	47.14	88785.0
2010-05-17 08:00:00	QQQ	ETF	47.15	47.17	46.35	46.93	1414818.0
2010-05-17 09:00:00	QQQ	ETF	46.94	47.27	46.84	46.92	12934162.0
2010-05-17 10:00:00	QQQ	ETF	46.92	47.23	46.86	46.96	13848047.0
2010-05-17 11:00:00	QQQ	ETF	46.96	47.0	46.5	46.51	12678494.0
2010-05-17 12:00:00	QQQ	ETF	46.5	46.5	46.07	46.3	22811422.0
2010-05-17 13:00:00	QQQ	ETF	46.3	46.62	46.28	46.6	13331296.0
2010-05-17 14:00:00	QQQ	ETF	46.6	46.88	46.55	46.85	12579352.0
2010-05-17 15:00:00	QQQ	ETF	46.85	47.17	46.61	47.11	22788756.0
2010-05-17 16:00:00	QQQ	ETF	47.1	47.19	46.33	47.16	1433453.0
2010-05-17 17:00:00	QQQ	ETF	47.16	47.18	47.08	47.16	114049.0
2010-05-17 18:00:00	QQQ	ETF	47.16	47.25	47.15	47.18	39950.0
2010-05-17 19:00:00	QQQ	ETF	47.19	47.19	47.11	47.17	21875.0
2010-05-17 04:00:00	IWM	ETF	69.48	69.48	69.48	69.48	200.0
2010-05-17 05:00:00	IWM	ETF	69.99	69.99	69.88	69.88	300.0
2010-05-17 07:00:00	IWM	ETF	69.89	70.15	69.89	69.98	107178.0
2010-05-17 08:00:00	IWM	ETF	69.97	70.04	68.6	69.75	975518.0
2010-05-17 09:00:00	IWM	ETF	69.74	70.57	69.55	69.68	10694383.0
2010-05-17 10:00:00	IWM	ETF	69.67	70.135	69.49	69.55	8588215.0
2010-05-17 11:00:00	IWM	ETF	69.54	69.61	68.62	68.65	8036994.0
2010-05-17 12:00:00	IWM	ETF	68.65	68.65	67.75	68.24	14184231.0
2010-05-17 13:00:00	IWM	ETF	68.24	68.805	68.16	68.6	6085378.0
2010-05-17 14:00:00	IWM	ETF	68.595	69.23	68.45	69.19	7417020.0
2010-05-17 15:00:00	IWM	ETF	69.21	69.76	68.35	69.66	17867847.0
2010-05-17 16:00:00	IWM	ETF	69.67	69.8	68.5	69.79	4267736.0
2010-05-17 17:00:00	IWM	ETF	69.71	69.72	69.69	69.72	1101.0
2010-05-17 18:00:00	IWM	ETF	69.84	69.94	69.72	69.75	1796.0
2010-05-17 19:00:00	IWM	ETF	69.85	69.92	69.78	69.79	9311.0
2010-05-17 05:00:00	DIA	ETF	106.58	106.58	106.58	106.58	247.0
2010-05-17 06:00:00	DIA	ETF	106.63	106.63	106.63	106.63	300.0
2010-05-17 07:00:00	DIA	ETF	106.72	106.88	106.72	106.75	1125.0

> showing 50 of 5,120 rows — these rows as CSV

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