PREVIEW / etf_1hour / 2007-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-15.parquet
  size:    89 KB
  rows:    2,901

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-08-15 04:00:00	SPY	ETF	142.65	142.65	142.65	142.65	100.0
2007-08-15 05:00:00	SPY	ETF	142.85	142.85	142.85	142.85	3000.0
2007-08-15 06:00:00	SPY	ETF	142.71	142.71	142.32	142.32	138500.0
2007-08-15 07:00:00	SPY	ETF	142.25	142.57	142.15	142.24	1478400.0
2007-08-15 08:00:00	SPY	ETF	142.24	142.68	142.2	142.26	5927200.0
2007-08-15 09:00:00	SPY	ETF	142.25	143.9	142.13	143.31	44534866.0
2007-08-15 10:00:00	SPY	ETF	143.31	144.46	142.76	143.57	49004359.0
2007-08-15 11:00:00	SPY	ETF	143.58	143.9	142.75	142.91	25351732.0
2007-08-15 12:00:00	SPY	ETF	142.91	143.55	142.87	143.23	21156002.0
2007-08-15 13:00:00	SPY	ETF	143.22	144.38	143.0	143.91	25264795.0
2007-08-15 14:00:00	SPY	ETF	143.91	144.01	142.25	142.44	39290456.0
2007-08-15 15:00:00	SPY	ETF	142.46	142.82	140.62	140.9	71271115.0
2007-08-15 16:00:00	SPY	ETF	140.93	141.25	140.8408	140.93	13339800.0
2007-08-15 17:00:00	SPY	ETF	140.96	143.482	140.7	140.88	747500.0
2007-08-15 18:00:00	SPY	ETF	140.81	140.85	140.64	140.72	115500.0
2007-08-15 19:00:00	SPY	ETF	140.75	140.89	140.7	140.88	89800.0
2007-08-15 20:00:00	SPY	ETF	140.88	140.88	140.88	140.88	100.0
2007-08-15 04:00:00	QQQ	ETF	46.81	46.81	46.81	46.81	3001.0
2007-08-15 06:00:00	QQQ	ETF	46.6	46.6	46.56	46.56	30000.0
2007-08-15 07:00:00	QQQ	ETF	46.6	46.6	46.46	46.49	854215.0
2007-08-15 08:00:00	QQQ	ETF	46.49	46.65	46.48	46.54	5055311.0
2007-08-15 09:00:00	QQQ	ETF	46.55	47.04	46.54	46.86	29589527.0
2007-08-15 10:00:00	QQQ	ETF	46.86	47.08	46.66	46.81	38900979.0
2007-08-15 11:00:00	QQQ	ETF	46.81	46.95	46.53	46.55	21961838.0
2007-08-15 12:00:00	QQQ	ETF	46.55	46.78	46.54	46.68	12931900.0
2007-08-15 13:00:00	QQQ	ETF	46.69	47.09	46.61	46.942	18532137.0
2007-08-15 14:00:00	QQQ	ETF	46.95	47.0	46.43	46.45	18951552.0
2007-08-15 15:00:00	QQQ	ETF	46.47	46.58	45.813	45.8885	47999145.0
2007-08-15 16:00:00	QQQ	ETF	45.9	45.99	45.85	45.89	3221876.0
2007-08-15 17:00:00	QQQ	ETF	45.91	45.92	45.65	45.75	320522.0
2007-08-15 18:00:00	QQQ	ETF	45.76	45.8	45.69	45.7	1141035.0
2007-08-15 19:00:00	QQQ	ETF	45.72	45.78	45.72	45.73	39400.0
2007-08-15 06:00:00	IWM	ETF	76.0	76.0	76.0	76.0	5000.0
2007-08-15 07:00:00	IWM	ETF	75.87	75.87	75.71	75.79	48000.0
2007-08-15 08:00:00	IWM	ETF	75.82	76.02	75.7	75.76	642000.0
2007-08-15 09:00:00	IWM	ETF	75.78	77.01	75.62	76.64	15791184.0
2007-08-15 10:00:00	IWM	ETF	76.65	77.4	76.23	76.84	24365580.0
2007-08-15 11:00:00	IWM	ETF	76.85	77.12	76.1	76.29	15571146.0
2007-08-15 12:00:00	IWM	ETF	76.29	76.58	76.24	76.39	8439169.0
2007-08-15 13:00:00	IWM	ETF	76.38	77.19	76.24	76.85	17718595.0
2007-08-15 14:00:00	IWM	ETF	76.86	77.0	75.81	75.96	17483287.0
2007-08-15 15:00:00	IWM	ETF	75.96	76.14	74.74	74.9	28247333.0
2007-08-15 16:00:00	IWM	ETF	74.96	75.36	74.92	75.12	2218452.0
2007-08-15 17:00:00	IWM	ETF	75.14	76.2153	75.07	75.17	439200.0
2007-08-15 18:00:00	IWM	ETF	75.1	75.1	74.89	74.89	22400.0
2007-08-15 19:00:00	IWM	ETF	75.2	75.2	74.97	75.04	82700.0
2007-08-15 07:00:00	DIA	ETF	129.9	130.09	129.76	129.86	14700.0
2007-08-15 08:00:00	DIA	ETF	129.84	130.17	129.84	129.87	237300.0
2007-08-15 09:00:00	DIA	ETF	129.86	130.88	129.5	130.45	3026301.0
2007-08-15 10:00:00	DIA	ETF	130.47	131.28	130.1	130.66	5417000.0

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

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