PREVIEW / etf_1hour / 2009-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-13.parquet
  size:    123 KB
  rows:    3,782

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-01-13 04:00:00	SPY	ETF	86.55	86.72	86.49	86.72	6500.0
2009-01-13 05:00:00	SPY	ETF	86.5	86.66	86.08	86.25	20880.0
2009-01-13 06:00:00	SPY	ETF	86.24	86.5	86.15	86.34	24856.0
2009-01-13 07:00:00	SPY	ETF	86.39	86.85	86.39	86.65	496655.0
2009-01-13 08:00:00	SPY	ETF	86.65	87.059	86.38	86.91	2497530.0
2009-01-13 09:00:00	SPY	ETF	86.9	87.58	86.51	87.36	31996257.0
2009-01-13 10:00:00	SPY	ETF	87.36	87.88	86.85	87.41	50076256.0
2009-01-13 11:00:00	SPY	ETF	87.41	87.77	86.97	87.6175	46899398.0
2009-01-13 12:00:00	SPY	ETF	87.62	87.6992	87.09	87.09	26711129.0
2009-01-13 13:00:00	SPY	ETF	87.0992	87.21	86.29	86.37	30554999.0
2009-01-13 14:00:00	SPY	ETF	86.37	87.44	86.2	86.98	54437310.0
2009-01-13 15:00:00	SPY	ETF	86.98	87.48	86.37	87.1	89585641.0
2009-01-13 16:00:00	SPY	ETF	87.08	87.29	87.01	87.15	16153101.0
2009-01-13 17:00:00	SPY	ETF	87.13	87.3	87.0596	87.28	3403621.0
2009-01-13 18:00:00	SPY	ETF	87.29	87.36	87.19	87.34	227748.0
2009-01-13 19:00:00	SPY	ETF	87.33	87.69	87.33	87.6	179218.0
2009-01-13 04:00:00	QQQ	ETF	29.46	29.5	29.46	29.5	675.0
2009-01-13 05:00:00	QQQ	ETF	29.43	29.43	29.38	29.38	300.0
2009-01-13 06:00:00	QQQ	ETF	29.35	29.39	29.33	29.35	22382.0
2009-01-13 07:00:00	QQQ	ETF	29.4	29.51	29.4	29.46	171694.0
2009-01-13 08:00:00	QQQ	ETF	29.47	29.69	29.4	29.66	2101993.0
2009-01-13 09:00:00	QQQ	ETF	29.66	29.98	29.45	29.89	27892796.0
2009-01-13 10:00:00	QQQ	ETF	29.89	29.97	29.6	29.79	24054706.0
2009-01-13 11:00:00	QQQ	ETF	29.78	29.84	29.59	29.76	16603170.0
2009-01-13 12:00:00	QQQ	ETF	29.76	29.78	29.51	29.51	11731439.0
2009-01-13 13:00:00	QQQ	ETF	29.52	29.56	29.22	29.259	18296180.0
2009-01-13 14:00:00	QQQ	ETF	29.26	29.65	29.18	29.48	28312291.0
2009-01-13 15:00:00	QQQ	ETF	29.48	29.6802	29.27	29.54	49690662.0
2009-01-13 16:00:00	QQQ	ETF	29.53	29.66	29.53	29.6	2866953.0
2009-01-13 17:00:00	QQQ	ETF	29.6	29.64	29.53	29.56	393342.0
2009-01-13 18:00:00	QQQ	ETF	29.57	29.6	29.52	29.58	183948.0
2009-01-13 19:00:00	QQQ	ETF	29.6	29.71	29.6	29.68	54050.0
2009-01-13 06:00:00	IWM	ETF	46.36	46.36	46.36	46.36	100.0
2009-01-13 07:00:00	IWM	ETF	46.49	46.67	46.46	46.57	25800.0
2009-01-13 08:00:00	IWM	ETF	46.61	46.81	46.48	46.75	160426.0
2009-01-13 09:00:00	IWM	ETF	46.77	47.39	46.41	47.19	6778771.0
2009-01-13 10:00:00	IWM	ETF	47.19	47.59	46.86	47.46	7865420.0
2009-01-13 11:00:00	IWM	ETF	47.46	47.6097	47.17	47.52	6330009.0
2009-01-13 12:00:00	IWM	ETF	47.52	47.61	47.31	47.31	3723572.0
2009-01-13 13:00:00	IWM	ETF	47.31	47.37	46.72	46.73	6194819.0
2009-01-13 14:00:00	IWM	ETF	46.73	47.3	46.63	47.08	7939332.0
2009-01-13 15:00:00	IWM	ETF	47.08	47.37	46.73	47.31	15367918.0
2009-01-13 16:00:00	IWM	ETF	47.31	47.41	46.7	47.19	3424057.0
2009-01-13 17:00:00	IWM	ETF	47.22	47.24	46.7823	47.24	3002800.0
2009-01-13 19:00:00	IWM	ETF	47.38	47.4	47.32	47.37	2144.0
2009-01-13 06:00:00	DIA	ETF	84.16	84.34	84.16	84.34	600.0
2009-01-13 07:00:00	DIA	ETF	84.23	84.57	84.23	84.55	5167.0
2009-01-13 08:00:00	DIA	ETF	84.5	84.82	84.25	84.79	25091.0
2009-01-13 09:00:00	DIA	ETF	84.75	85.18	84.42	85.0	2783265.0
2009-01-13 10:00:00	DIA	ETF	85.01	85.29	84.49	84.83	4963542.0

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

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