PREVIEW / etf_1hour / 2009-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-26.parquet
  size:    138 KB
  rows:    4,314

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-08-26 04:00:00	SPY	ETF	103.27	103.27	103.15	103.19	2600.0
2009-08-26 05:00:00	SPY	ETF	103.16	103.16	103.01	103.11	2400.0
2009-08-26 06:00:00	SPY	ETF	103.19	103.19	102.85	102.9	4301.0
2009-08-26 07:00:00	SPY	ETF	102.97	102.97	102.7	102.92	294658.0
2009-08-26 08:00:00	SPY	ETF	102.92	103.49	102.73	102.96	6171405.0
2009-08-26 09:00:00	SPY	ETF	102.96	102.99	102.49	102.81	22645007.0
2009-08-26 10:00:00	SPY	ETF	102.82	103.64	102.75	103.35	50313563.0
2009-08-26 11:00:00	SPY	ETF	103.34	103.38	102.75	102.97	21458291.0
2009-08-26 12:00:00	SPY	ETF	102.97	103.5052	102.89	102.98	14252662.0
2009-08-26 13:00:00	SPY	ETF	102.99	103.25	102.7	103.25	15827753.0
2009-08-26 14:00:00	SPY	ETF	103.25	103.32	102.9	102.93	16207675.0
2009-08-26 15:00:00	SPY	ETF	102.94	103.27	102.86	103.18	28529330.0
2009-08-26 16:00:00	SPY	ETF	103.19	103.4	102.94	103.07	6525140.0
2009-08-26 17:00:00	SPY	ETF	103.08	103.18	103.08	103.13	5465551.0
2009-08-26 18:00:00	SPY	ETF	103.13	103.18	103.07	103.12	228228.0
2009-08-26 19:00:00	SPY	ETF	103.13	103.16	103.05	103.05	30237.0
2009-08-26 06:00:00	QQQ	ETF	40.37	40.37	40.26	40.3	1248.0
2009-08-26 07:00:00	QQQ	ETF	40.34	40.34	40.22	40.29	22836.0
2009-08-26 08:00:00	QQQ	ETF	40.28	40.46	40.25	40.32	2152848.0
2009-08-26 09:00:00	QQQ	ETF	40.3	40.38	40.2	40.36	11510113.0
2009-08-26 10:00:00	QQQ	ETF	40.37	40.601	40.33	40.41	20936310.0
2009-08-26 11:00:00	QQQ	ETF	40.41	40.43	40.09	40.15	10868964.0
2009-08-26 12:00:00	QQQ	ETF	40.15	40.27	40.1	40.1696	8592477.0
2009-08-26 13:00:00	QQQ	ETF	40.17	40.36	40.08	40.36	10876443.0
2009-08-26 14:00:00	QQQ	ETF	40.36	40.4	40.15	40.26	9207591.0
2009-08-26 15:00:00	QQQ	ETF	40.25	40.35	40.22	40.32	12013610.0
2009-08-26 16:00:00	QQQ	ETF	40.31	40.47	40.23	40.3742	4824872.0
2009-08-26 17:00:00	QQQ	ETF	40.3	40.3742	40.27	40.3742	1031505.0
2009-08-26 18:00:00	QQQ	ETF	40.3	40.32	40.28	40.29	44068.0
2009-08-26 19:00:00	QQQ	ETF	40.3	40.31	40.27	40.27	11200.0
2009-08-26 07:00:00	IWM	ETF	58.22	58.31	58.11	58.31	55287.0
2009-08-26 08:00:00	IWM	ETF	58.23	58.58	58.16	58.31	1457192.0
2009-08-26 09:00:00	IWM	ETF	58.31	58.42	58.03	58.25	4314464.0
2009-08-26 10:00:00	IWM	ETF	58.28	58.77	58.26	58.53	7607228.0
2009-08-26 11:00:00	IWM	ETF	58.53	58.55	58.1	58.2097	3045892.0
2009-08-26 12:00:00	IWM	ETF	58.2076	58.3709	58.17	58.29	1735633.0
2009-08-26 13:00:00	IWM	ETF	58.29	58.48	58.06	58.48	3392675.0
2009-08-26 14:00:00	IWM	ETF	58.48	58.5	58.2	58.235	3223614.0
2009-08-26 15:00:00	IWM	ETF	58.23	58.47	58.2	58.45	5117329.0
2009-08-26 16:00:00	IWM	ETF	58.46	58.65	58.374	58.45	1688422.0
2009-08-26 17:00:00	IWM	ETF	58.45	58.46	58.41	58.44	5662.0
2009-08-26 18:00:00	IWM	ETF	58.38	58.38	58.37	58.37	800.0
2009-08-26 19:00:00	IWM	ETF	58.4	58.43	58.39	58.43	1950.0
2009-08-26 07:00:00	DIA	ETF	95.11	95.3	95.11	95.3	3800.0
2009-08-26 08:00:00	DIA	ETF	95.26	95.75	95.18	95.33	54921.0
2009-08-26 09:00:00	DIA	ETF	95.28	95.31	94.87	95.11	1626917.0
2009-08-26 10:00:00	DIA	ETF	95.11	95.85	95.09	95.619	3373428.0
2009-08-26 11:00:00	DIA	ETF	95.61	95.65	95.16	95.342	1298705.0
2009-08-26 12:00:00	DIA	ETF	95.36	95.4999	95.28	95.38	639561.0
2009-08-26 13:00:00	DIA	ETF	95.38	95.6	95.13	95.6	860354.0

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

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