PREVIEW / etf_1hour / 2008-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-20.parquet
  size:    109 KB
  rows:    3,490

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
2008-05-20 04:00:00	SPY	ETF	142.67	142.75	142.61	142.61	3300.0
2008-05-20 05:00:00	SPY	ETF	142.59	142.59	142.5	142.5	4000.0
2008-05-20 06:00:00	SPY	ETF	142.54	142.56	142.44	142.44	165700.0
2008-05-20 07:00:00	SPY	ETF	142.51	142.57	142.41	142.52	448575.0
2008-05-20 08:00:00	SPY	ETF	142.5	142.64	142.04	142.16	5216277.0
2008-05-20 09:00:00	SPY	ETF	142.15	142.34	141.85	141.87	18163087.0
2008-05-20 10:00:00	SPY	ETF	141.87	142.05	141.63	141.97	29330892.0
2008-05-20 11:00:00	SPY	ETF	141.97	142.01	141.37	141.501	21458938.0
2008-05-20 12:00:00	SPY	ETF	141.51	141.92	141.42	141.58	14899781.0
2008-05-20 13:00:00	SPY	ETF	141.58	141.82	141.0	141.27	20016066.0
2008-05-20 14:00:00	SPY	ETF	141.27	141.43	141.06	141.23	17614680.0
2008-05-20 15:00:00	SPY	ETF	141.225	142.0	141.06	141.64	33959929.0
2008-05-20 16:00:00	SPY	ETF	141.66	142.8489	141.45	141.8	6247484.0
2008-05-20 17:00:00	SPY	ETF	141.76	142.849	141.73	141.74	3093715.0
2008-05-20 18:00:00	SPY	ETF	141.74	141.83	141.73	141.8	18945.0
2008-05-20 19:00:00	SPY	ETF	141.77	141.87	141.72	141.72	11625.0
2008-05-20 06:00:00	QQQ	ETF	49.59	49.59	49.55	49.55	46500.0
2008-05-20 07:00:00	QQQ	ETF	49.55	49.58	49.53	49.56	103566.0
2008-05-20 08:00:00	QQQ	ETF	49.57	49.61	49.38	49.42	1843995.0
2008-05-20 09:00:00	QQQ	ETF	49.42	49.47	49.18	49.2018	23207012.0
2008-05-20 10:00:00	QQQ	ETF	49.2	49.25	49.0	49.2	23692952.0
2008-05-20 11:00:00	QQQ	ETF	49.21	49.21	48.92	49.01	16791042.0
2008-05-20 12:00:00	QQQ	ETF	49.02	49.29	48.99	49.1482	9907632.0
2008-05-20 13:00:00	QQQ	ETF	49.15	49.28	48.97	48.99	12922281.0
2008-05-20 14:00:00	QQQ	ETF	48.98	49.15	48.89	49.02	15012719.0
2008-05-20 15:00:00	QQQ	ETF	49.0299	49.27	48.99	49.26	20452432.0
2008-05-20 16:00:00	QQQ	ETF	49.26	49.6222	48.97	49.3	5334838.0
2008-05-20 17:00:00	QQQ	ETF	49.31	49.33	49.2	49.27	457896.0
2008-05-20 18:00:00	QQQ	ETF	49.28	49.31	49.28	49.31	37280.0
2008-05-20 19:00:00	QQQ	ETF	49.3	49.33	49.28	49.33	9704.0
2008-05-20 07:00:00	IWM	ETF	73.62	73.71	73.62	73.63	44419.0
2008-05-20 08:00:00	IWM	ETF	73.71	73.72	73.4	73.42	458097.0
2008-05-20 09:00:00	IWM	ETF	73.44	73.58	73.13	73.22	8225956.0
2008-05-20 10:00:00	IWM	ETF	73.22	73.57	73.0	73.45	12177599.0
2008-05-20 11:00:00	IWM	ETF	73.45	73.48	73.02	73.11	9354345.0
2008-05-20 12:00:00	IWM	ETF	73.1	73.67	73.07	73.35	8756135.0
2008-05-20 13:00:00	IWM	ETF	73.35	73.6	73.19	73.24	4336610.0
2008-05-20 14:00:00	IWM	ETF	73.24	73.41	72.8	73.02	11014102.0
2008-05-20 15:00:00	IWM	ETF	73.02	73.58	72.97	73.56	12636428.0
2008-05-20 16:00:00	IWM	ETF	73.57	73.76	73.28	73.61	6730975.0
2008-05-20 17:00:00	IWM	ETF	73.59	73.63	73.52	73.52	27658.0
2008-05-20 18:00:00	IWM	ETF	73.58	73.58	73.58	73.58	400.0
2008-05-20 19:00:00	IWM	ETF	73.62	73.62	73.62	73.62	1000.0
2008-05-20 07:00:00	DIA	ETF	129.86	129.86	129.82	129.84	2000.0
2008-05-20 08:00:00	DIA	ETF	129.85	129.93	129.33	129.41	84232.0
2008-05-20 09:00:00	DIA	ETF	129.42	129.56	128.85	128.86	1535912.0
2008-05-20 10:00:00	DIA	ETF	128.85	128.85	128.35	128.65	2066695.0
2008-05-20 11:00:00	DIA	ETF	128.65	128.67	128.03	128.16	1342417.0
2008-05-20 12:00:00	DIA	ETF	128.16	128.49	128.07	128.16	989003.0
2008-05-20 13:00:00	DIA	ETF	128.15	128.38	127.74	127.8	1605527.0

> showing 50 of 3,490 rows — these rows as CSV

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