PREVIEW / etf_1hour / 2009-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-19.parquet
  size:    134 KB
  rows:    4,119

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
2009-06-19 04:00:00	SPY	ETF	91.98	92.04	91.98	92.0	2700.0
2009-06-19 05:00:00	SPY	ETF	91.98	92.34	91.98	92.34	12200.0
2009-06-19 06:00:00	SPY	ETF	92.31	92.42	92.31	92.37	44400.0
2009-06-19 07:00:00	SPY	ETF	92.4	92.46	92.16	92.37	1399069.0
2009-06-19 08:00:00	SPY	ETF	92.37	92.66	92.08	92.51	2395496.0
2009-06-19 09:00:00	SPY	ETF	92.5	92.7	92.42	92.55	29453615.0
2009-06-19 10:00:00	SPY	ETF	92.56	92.68	92.2	92.58	24348790.0
2009-06-19 11:00:00	SPY	ETF	92.5899	92.68	92.24	92.36	18966453.0
2009-06-19 12:00:00	SPY	ETF	92.35	92.38	91.81	91.84	20882562.0
2009-06-19 13:00:00	SPY	ETF	91.84	92.14	91.82	91.91	17212911.0
2009-06-19 14:00:00	SPY	ETF	91.91	91.97	91.52	91.84	29705770.0
2009-06-19 15:00:00	SPY	ETF	91.84	92.38	91.73	91.97	39771803.0
2009-06-19 16:00:00	SPY	ETF	91.98	92.4	91.82	91.96	12779617.0
2009-06-19 17:00:00	SPY	ETF	91.9	91.97	91.83	91.87	6037615.0
2009-06-19 18:00:00	SPY	ETF	91.88	92.04	91.85	91.88	85702.0
2009-06-19 19:00:00	SPY	ETF	91.9	91.93	91.87	91.89	14470.0
2009-06-19 06:00:00	QQQ	ETF	35.97	35.97	35.97	35.97	100.0
2009-06-19 07:00:00	QQQ	ETF	35.96	36.01	35.87	36.0	510488.0
2009-06-19 08:00:00	QQQ	ETF	36.0	36.1	35.97	36.04	1193109.0
2009-06-19 09:00:00	QQQ	ETF	36.03	36.32	36.02	36.28	21036660.0
2009-06-19 10:00:00	QQQ	ETF	36.28	36.36	36.17	36.34	14895232.0
2009-06-19 11:00:00	QQQ	ETF	36.34	36.36	35.9768	36.24	10337548.0
2009-06-19 12:00:00	QQQ	ETF	36.24	36.25	36.03	36.05	12591550.0
2009-06-19 13:00:00	QQQ	ETF	36.05	36.17	36.03	36.11	10869417.0
2009-06-19 14:00:00	QQQ	ETF	36.109	36.135	35.9101	36.04	12660415.0
2009-06-19 15:00:00	QQQ	ETF	36.04	36.25	36.0	36.14	23062459.0
2009-06-19 16:00:00	QQQ	ETF	36.14	36.2465	36.07	36.11	14009125.0
2009-06-19 17:00:00	QQQ	ETF	36.12	36.13	36.08	36.1	91490.0
2009-06-19 18:00:00	QQQ	ETF	36.1	36.11	36.08	36.11	3050.0
2009-06-19 19:00:00	QQQ	ETF	36.11	36.12	36.1	36.1	4904.0
2009-06-19 07:00:00	IWM	ETF	51.47	51.65	51.46	51.61	443209.0
2009-06-19 08:00:00	IWM	ETF	51.52	51.77	51.5	51.65	1325105.0
2009-06-19 09:00:00	IWM	ETF	51.6	51.92	51.6	51.78	6486082.0
2009-06-19 10:00:00	IWM	ETF	51.78	51.87	51.61	51.79	4509041.0
2009-06-19 11:00:00	IWM	ETF	51.7878	51.84	51.61	51.65	3338992.0
2009-06-19 12:00:00	IWM	ETF	51.6491	51.658	51.285	51.32	4950945.0
2009-06-19 13:00:00	IWM	ETF	51.31	51.46	51.22	51.34	4172661.0
2009-06-19 14:00:00	IWM	ETF	51.33	51.39	51.11	51.35	2965222.0
2009-06-19 15:00:00	IWM	ETF	51.34	51.6	51.24	51.33	6917227.0
2009-06-19 16:00:00	IWM	ETF	51.33	51.5305	51.26	51.39	762436.0
2009-06-19 17:00:00	IWM	ETF	51.37	51.39	51.37	51.39	1100.0
2009-06-19 18:00:00	IWM	ETF	51.29	51.35	51.29	51.35	699.0
2009-06-19 19:00:00	IWM	ETF	51.29	51.29	51.29	51.29	100.0
2009-06-19 07:00:00	DIA	ETF	85.93	85.97	85.87	85.97	1700.0
2009-06-19 08:00:00	DIA	ETF	85.96	86.16	85.92	86.05	76271.0
2009-06-19 09:00:00	DIA	ETF	86.06	86.13	85.87	86.01	2375603.0
2009-06-19 10:00:00	DIA	ETF	86.02	86.09	85.7	86.02	1485612.0
2009-06-19 11:00:00	DIA	ETF	86.02	86.09	85.71	85.76	863671.0
2009-06-19 12:00:00	DIA	ETF	85.76	85.79	85.23	85.24	1584945.0
2009-06-19 13:00:00	DIA	ETF	85.25	85.49	85.22	85.26	1082295.0

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

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