PREVIEW / etf_1hour / 2009-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-24.parquet
  size:    136 KB
  rows:    4,164

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-24 04:00:00	SPY	ETF	89.62	89.74	89.62	89.62	21650.0
2009-06-24 05:00:00	SPY	ETF	89.78	89.94	89.75	89.94	21300.0
2009-06-24 06:00:00	SPY	ETF	89.83	89.9	89.74	89.84	25425.0
2009-06-24 07:00:00	SPY	ETF	89.84	90.09	89.76	89.91	490045.0
2009-06-24 08:00:00	SPY	ETF	89.9	90.44	89.36	90.26	6443296.0
2009-06-24 09:00:00	SPY	ETF	90.26	90.45	90.04	90.44	15274782.0
2009-06-24 10:00:00	SPY	ETF	90.44	91.07	90.25	90.95	33319851.0
2009-06-24 11:00:00	SPY	ETF	90.95	91.08	90.73	90.81	14654993.0
2009-06-24 12:00:00	SPY	ETF	90.81	90.86	90.57	90.66	9946004.0
2009-06-24 13:00:00	SPY	ETF	90.67	90.87	90.59	90.668	10027006.0
2009-06-24 14:00:00	SPY	ETF	90.66	90.88	89.82	90.14	50322701.0
2009-06-24 15:00:00	SPY	ETF	90.14	90.26	89.6	90.11	59568803.0
2009-06-24 16:00:00	SPY	ETF	90.1	90.37	89.65	90.22	7632643.0
2009-06-24 17:00:00	SPY	ETF	90.21	90.24	89.5001	90.16	1127671.0
2009-06-24 18:00:00	SPY	ETF	90.16	90.23	90.15	90.2	31062.0
2009-06-24 19:00:00	SPY	ETF	90.21	90.22	90.18	90.2	43215.0
2009-06-24 05:00:00	QQQ	ETF	35.2	35.2	35.19	35.19	300.0
2009-06-24 06:00:00	QQQ	ETF	35.15	35.17	35.15	35.17	40700.0
2009-06-24 07:00:00	QQQ	ETF	35.19	35.27	35.17	35.2	110150.0
2009-06-24 08:00:00	QQQ	ETF	35.18	35.38	35.16	35.35	948244.0
2009-06-24 09:00:00	QQQ	ETF	35.34	35.5	35.28	35.49	9414583.0
2009-06-24 10:00:00	QQQ	ETF	35.48	35.87	35.42	35.78	19906144.0
2009-06-24 11:00:00	QQQ	ETF	35.78	35.84	35.74	35.78	7858968.0
2009-06-24 12:00:00	QQQ	ETF	35.79	35.81	35.69	35.75	6420022.0
2009-06-24 13:00:00	QQQ	ETF	35.7501	35.81	35.67	35.692	4378808.0
2009-06-24 14:00:00	QQQ	ETF	35.69	35.8099	35.44	35.6	24150204.0
2009-06-24 15:00:00	QQQ	ETF	35.6	35.669	35.38	35.58	23302304.0
2009-06-24 16:00:00	QQQ	ETF	35.59	35.731	35.0364	35.62	4464504.0
2009-06-24 17:00:00	QQQ	ETF	35.62	35.63	35.61	35.62	63736.0
2009-06-24 18:00:00	QQQ	ETF	35.61	35.65	35.59	35.64	42959.0
2009-06-24 19:00:00	QQQ	ETF	35.63	35.63	35.61	35.62	19914.0
2009-06-24 06:00:00	IWM	ETF	49.28	49.34	49.28	49.34	5100.0
2009-06-24 07:00:00	IWM	ETF	49.34	49.48	49.29	49.4	49803.0
2009-06-24 08:00:00	IWM	ETF	49.4	49.77	49.32	49.64	936925.0
2009-06-24 09:00:00	IWM	ETF	49.63	49.95	49.5	49.92	2983520.0
2009-06-24 10:00:00	IWM	ETF	49.92	50.25	49.77	50.14	6716469.0
2009-06-24 11:00:00	IWM	ETF	50.14	50.23	50.01	50.0799	1752868.0
2009-06-24 12:00:00	IWM	ETF	50.08	50.1	49.94	50.01	1765973.0
2009-06-24 13:00:00	IWM	ETF	50.0	50.12	49.96	49.9797	1421662.0
2009-06-24 14:00:00	IWM	ETF	49.98	50.14	49.54	49.66	6927680.0
2009-06-24 15:00:00	IWM	ETF	49.66	49.75	49.33	49.6	12812168.0
2009-06-24 16:00:00	IWM	ETF	49.61	49.7871	49.58	49.7	922887.0
2009-06-24 17:00:00	IWM	ETF	49.7	49.74	49.64	49.73	115274.0
2009-06-24 18:00:00	IWM	ETF	49.74	49.84	49.74	49.79	270249.0
2009-06-24 19:00:00	IWM	ETF	49.74	49.83	49.74	49.78	1500.0
2009-06-24 06:00:00	DIA	ETF	83.45	83.45	83.45	83.45	700.0
2009-06-24 07:00:00	DIA	ETF	83.56	83.72	83.47	83.5	26250.0
2009-06-24 08:00:00	DIA	ETF	83.53	84.04	83.45	83.8	75522.0
2009-06-24 09:00:00	DIA	ETF	83.78	83.91	83.6	83.87	649506.0
2009-06-24 10:00:00	DIA	ETF	83.87	84.28	83.71	84.15	1895322.0

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

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