PREVIEW / etf_1hour / 2007-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-25.parquet
  size:    91 KB
  rows:    3,035

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
2007-10-25 04:00:00	SPY	ETF	151.39	151.39	151.39	151.39	2000.0
2007-10-25 05:00:00	SPY	ETF	151.43	151.53	151.43	151.53	61100.0
2007-10-25 06:00:00	SPY	ETF	151.51	151.75	151.48	151.75	64900.0
2007-10-25 07:00:00	SPY	ETF	151.79	152.22	151.79	152.0	1458400.0
2007-10-25 08:00:00	SPY	ETF	152.0	152.17	151.48	151.87	5691200.0
2007-10-25 09:00:00	SPY	ETF	151.88	151.91	150.83	150.9	21438329.0
2007-10-25 10:00:00	SPY	ETF	150.91	152.29	150.9	151.88	42515807.0
2007-10-25 11:00:00	SPY	ETF	151.88	151.99	151.01	151.05	20889301.0
2007-10-25 12:00:00	SPY	ETF	151.05	151.51	150.8	151.04	19343400.0
2007-10-25 13:00:00	SPY	ETF	151.04	151.17	150.0	150.34	34154400.0
2007-10-25 14:00:00	SPY	ETF	150.34	151.46	149.88	151.37	39834850.0
2007-10-25 15:00:00	SPY	ETF	151.37	151.75	150.95	151.31	34398800.0
2007-10-25 16:00:00	SPY	ETF	151.35	152.24	150.68	152.18	8431100.0
2007-10-25 17:00:00	SPY	ETF	152.18	152.18	151.96	152.1	3871000.0
2007-10-25 18:00:00	SPY	ETF	152.1	152.15	151.83	151.83	102400.0
2007-10-25 19:00:00	SPY	ETF	151.85	152.0	151.83	152.0	21700.0
2007-10-25 05:00:00	QQQ	ETF	53.86	53.9	53.86	53.9	52500.0
2007-10-25 06:00:00	QQQ	ETF	53.99	54.04	53.99	54.04	5800.0
2007-10-25 07:00:00	QQQ	ETF	54.04	54.22	54.04	54.15	1256597.0
2007-10-25 08:00:00	QQQ	ETF	54.14	54.19	53.93	54.08	5278789.0
2007-10-25 09:00:00	QQQ	ETF	54.07	54.09	53.3	53.32	27986895.0
2007-10-25 10:00:00	QQQ	ETF	53.31	53.98	53.31	53.6785	51582637.0
2007-10-25 11:00:00	QQQ	ETF	53.6795	53.72	53.0	53.0	23156651.0
2007-10-25 12:00:00	QQQ	ETF	53.0	53.31	52.96	53.15	27738538.0
2007-10-25 13:00:00	QQQ	ETF	53.14	53.7978	52.82	52.95	24711335.0
2007-10-25 14:00:00	QQQ	ETF	52.948	53.3	52.75	53.27	30538623.0
2007-10-25 15:00:00	QQQ	ETF	53.27	53.38	53.04	53.1	32950613.0
2007-10-25 16:00:00	QQQ	ETF	53.1	53.9	53.03	53.84	13419260.0
2007-10-25 17:00:00	QQQ	ETF	53.84	53.85	53.72	53.75	3853570.0
2007-10-25 18:00:00	QQQ	ETF	53.75	53.8	53.63	53.63	444549.0
2007-10-25 19:00:00	QQQ	ETF	53.63	53.7	53.6	53.7	75488.0
2007-10-25 05:00:00	IWM	ETF	80.92	80.92	80.92	80.92	200.0
2007-10-25 06:00:00	IWM	ETF	81.02	81.2	81.02	81.2	400.0
2007-10-25 07:00:00	IWM	ETF	81.22	81.45	81.18	81.19	197700.0
2007-10-25 08:00:00	IWM	ETF	81.19	81.28	80.93	81.18	1332800.0
2007-10-25 09:00:00	IWM	ETF	81.13	81.13	80.19	80.21	9285167.0
2007-10-25 10:00:00	IWM	ETF	80.21	81.5	80.21	81.11	29764400.0
2007-10-25 11:00:00	IWM	ETF	81.1	81.19	79.99	80.0	11823300.0
2007-10-25 12:00:00	IWM	ETF	79.99	80.34	79.9	80.16	10663300.0
2007-10-25 13:00:00	IWM	ETF	80.16	80.24	79.75	79.85	16542700.0
2007-10-25 14:00:00	IWM	ETF	79.84	80.5	79.59	80.42	15569900.0
2007-10-25 15:00:00	IWM	ETF	80.42	80.51	79.86	80.26	15470200.0
2007-10-25 16:00:00	IWM	ETF	80.26	81.1	80.22	81.1	6427900.0
2007-10-25 17:00:00	IWM	ETF	81.02	81.05	80.99	81.05	99700.0
2007-10-25 18:00:00	IWM	ETF	80.99	80.99	80.88	80.9	9700.0
2007-10-25 19:00:00	IWM	ETF	80.89	80.98	80.89	80.97	3500.0
2007-10-25 07:00:00	DIA	ETF	136.87	137.12	136.87	137.01	3500.0
2007-10-25 08:00:00	DIA	ETF	136.95	137.02	136.64	136.92	179300.0
2007-10-25 09:00:00	DIA	ETF	136.85	136.88	136.11	136.15	1103607.0
2007-10-25 10:00:00	DIA	ETF	136.14	137.29	136.14	136.89	3221400.0

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

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