PREVIEW / etf_1hour / 2007-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-13.parquet
  size:    82 KB
  rows:    2,775

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-09-13 04:00:00	SPY	ETF	147.6	147.6	147.6	147.6	10000.0
2007-09-13 05:00:00	SPY	ETF	147.57	147.57	147.55	147.55	10000.0
2007-09-13 06:00:00	SPY	ETF	147.45	147.6	147.44	147.47	17300.0
2007-09-13 07:00:00	SPY	ETF	147.47	148.18	147.47	148.16	1072100.0
2007-09-13 08:00:00	SPY	ETF	148.12	148.65	147.88	148.48	3619300.0
2007-09-13 09:00:00	SPY	ETF	148.49	148.7	148.2	148.47	16534142.0
2007-09-13 10:00:00	SPY	ETF	148.47	148.94	148.31	148.88	19603900.0
2007-09-13 11:00:00	SPY	ETF	148.87	149.14	148.73	149.05	15622500.0
2007-09-13 12:00:00	SPY	ETF	149.05	149.15	148.81	149.01	11764500.0
2007-09-13 13:00:00	SPY	ETF	149.0	149.45	149.0	149.11	19767900.0
2007-09-13 14:00:00	SPY	ETF	149.1	149.23	148.83	149.09	14864100.0
2007-09-13 15:00:00	SPY	ETF	149.1	149.29	148.49	148.81	29375700.0
2007-09-13 16:00:00	SPY	ETF	148.78	148.91	148.7	148.72	18144400.0
2007-09-13 17:00:00	SPY	ETF	148.72	149.09	148.37	148.51	692400.0
2007-09-13 18:00:00	SPY	ETF	148.47	148.5	148.32	148.36	91100.0
2007-09-13 19:00:00	SPY	ETF	148.32	148.33	148.23	148.24	141500.0
2007-09-13 05:00:00	QQQ	ETF	49.01	49.01	48.99	48.99	15000.0
2007-09-13 06:00:00	QQQ	ETF	48.99	49.02	48.99	49.01	50200.0
2007-09-13 07:00:00	QQQ	ETF	48.99	49.18	48.96	49.18	386255.0
2007-09-13 08:00:00	QQQ	ETF	49.17	49.31	49.14	49.29	2287403.0
2007-09-13 09:00:00	QQQ	ETF	49.29	49.35	49.03	49.11	10293311.0
2007-09-13 10:00:00	QQQ	ETF	49.1101	49.2	48.94	49.18	12161502.0
2007-09-13 11:00:00	QQQ	ETF	49.17	49.28	49.11	49.25	7687943.0
2007-09-13 12:00:00	QQQ	ETF	49.26	49.26	49.15	49.21	4639283.0
2007-09-13 13:00:00	QQQ	ETF	49.21	49.35	49.19	49.239	7316650.0
2007-09-13 14:00:00	QQQ	ETF	49.24	49.27	49.15	49.24	5047532.0
2007-09-13 15:00:00	QQQ	ETF	49.24	49.28	49.07	49.17	17168059.0
2007-09-13 16:00:00	QQQ	ETF	49.16	49.21	49.13	49.14	1522728.0
2007-09-13 17:00:00	QQQ	ETF	49.14	49.14	49.1	49.13	89258.0
2007-09-13 18:00:00	QQQ	ETF	49.1	49.1	49.04	49.06	96268.0
2007-09-13 19:00:00	QQQ	ETF	49.06	49.06	48.99	48.99	71244.0
2007-09-13 06:00:00	IWM	ETF	77.41	77.43	77.41	77.43	19800.0
2007-09-13 07:00:00	IWM	ETF	77.32	77.71	77.32	77.65	63000.0
2007-09-13 08:00:00	IWM	ETF	77.71	77.99	77.65	77.89	623400.0
2007-09-13 09:00:00	IWM	ETF	77.87	78.02	77.24	77.39	9393900.0
2007-09-13 10:00:00	IWM	ETF	77.39	77.82	77.17	77.74	14860900.0
2007-09-13 11:00:00	IWM	ETF	77.74	77.9	77.38	77.83	4801600.0
2007-09-13 12:00:00	IWM	ETF	77.84	77.98	77.72	77.97	4885600.0
2007-09-13 13:00:00	IWM	ETF	77.97	78.53	77.97	78.29	8268500.0
2007-09-13 14:00:00	IWM	ETF	78.29	78.42	78.13	78.34	4653200.0
2007-09-13 15:00:00	IWM	ETF	78.33	78.45	77.71	77.76	9943500.0
2007-09-13 16:00:00	IWM	ETF	77.76	78.18	77.58	77.6	667100.0
2007-09-13 17:00:00	IWM	ETF	77.57	77.58	77.4	77.4	105700.0
2007-09-13 18:00:00	IWM	ETF	77.42	77.42	77.32	77.32	16600.0
2007-09-13 19:00:00	IWM	ETF	77.35	77.35	77.22	77.22	2700.0
2007-09-13 07:00:00	DIA	ETF	133.12	133.44	133.12	133.44	500.0
2007-09-13 08:00:00	DIA	ETF	133.58	133.92	133.54	133.84	42800.0
2007-09-13 09:00:00	DIA	ETF	133.82	134.1	133.67	134.0	695500.0
2007-09-13 10:00:00	DIA	ETF	134.01	134.33	133.8	134.25	1578300.0
2007-09-13 11:00:00	DIA	ETF	134.26	134.51	134.21	134.47	883600.0

> showing 50 of 2,775 rows — these rows as CSV

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