PREVIEW / etf_1hour / 2007-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-12.parquet
  size:    83 KB
  rows:    2,830

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-12 04:00:00	SPY	ETF	155.01	155.04	155.01	155.04	3100.0
2007-10-12 05:00:00	SPY	ETF	155.24	155.24	155.24	155.24	200.0
2007-10-12 06:00:00	SPY	ETF	155.22	155.27	155.2	155.27	150000.0
2007-10-12 07:00:00	SPY	ETF	155.29	155.31	154.99	155.1	333900.0
2007-10-12 08:00:00	SPY	ETF	155.09	155.59	155.05	155.52	4825200.0
2007-10-12 09:00:00	SPY	ETF	155.55	155.66	155.27	155.6	13244874.0
2007-10-12 10:00:00	SPY	ETF	155.61	155.97	155.33	155.75	19308310.0
2007-10-12 11:00:00	SPY	ETF	155.75	156.18	155.74	155.96	14768395.0
2007-10-12 12:00:00	SPY	ETF	155.96	156.23	155.83	156.13	10197185.0
2007-10-12 13:00:00	SPY	ETF	156.12	156.14	155.64	155.91	11056597.0
2007-10-12 14:00:00	SPY	ETF	155.92	156.2	155.9	155.95	10244919.0
2007-10-12 15:00:00	SPY	ETF	155.95	156.1	155.61	156.05	27455111.0
2007-10-12 16:00:00	SPY	ETF	156.07	156.6	155.15	156.56	9635300.0
2007-10-12 17:00:00	SPY	ETF	156.53	156.59	156.5	156.55	22700.0
2007-10-12 18:00:00	SPY	ETF	156.49	156.56	156.43	156.43	11000.0
2007-10-12 19:00:00	SPY	ETF	156.45	156.45	156.42	156.43	1800.0
2007-10-12 05:00:00	QQQ	ETF	52.69	52.69	52.69	52.69	100.0
2007-10-12 06:00:00	QQQ	ETF	52.73	52.73	52.73	52.73	10000.0
2007-10-12 07:00:00	QQQ	ETF	52.72	52.73	52.66	52.66	193784.0
2007-10-12 08:00:00	QQQ	ETF	52.65	52.95	52.65	52.94	2573909.0
2007-10-12 09:00:00	QQQ	ETF	52.94	53.12	52.8	53.08	18372644.0
2007-10-12 10:00:00	QQQ	ETF	53.08	53.29	52.96	53.191	31125966.0
2007-10-12 11:00:00	QQQ	ETF	53.2	53.41	53.2	53.32	17057509.0
2007-10-12 12:00:00	QQQ	ETF	53.32	53.47	53.2	53.45	12037115.0
2007-10-12 13:00:00	QQQ	ETF	53.449	53.45	53.17	53.32	13604009.0
2007-10-12 14:00:00	QQQ	ETF	53.312	53.52	53.312	53.42	11016384.0
2007-10-12 15:00:00	QQQ	ETF	53.41	53.54	53.22	53.53	17887949.0
2007-10-12 16:00:00	QQQ	ETF	53.53	53.74	52.55	53.67	7667647.0
2007-10-12 17:00:00	QQQ	ETF	53.67	53.75	53.66	53.69	86191.0
2007-10-12 18:00:00	QQQ	ETF	53.7	53.73	53.65	53.68	24824.0
2007-10-12 19:00:00	QQQ	ETF	53.69	53.75	53.67	53.75	17877.0
2007-10-12 05:00:00	IWM	ETF	83.1	83.1	83.1	83.1	200.0
2007-10-12 07:00:00	IWM	ETF	83.0	83.02	83.0	83.02	700.0
2007-10-12 08:00:00	IWM	ETF	83.0	83.35	83.0	83.3	570100.0
2007-10-12 09:00:00	IWM	ETF	83.31	83.69	83.21	83.56	8482747.0
2007-10-12 10:00:00	IWM	ETF	83.56	83.79	83.34	83.63	11674892.0
2007-10-12 11:00:00	IWM	ETF	83.63	84.08	83.62	83.89	10165233.0
2007-10-12 12:00:00	IWM	ETF	83.89	84.04	83.68	84.0	6588400.0
2007-10-12 13:00:00	IWM	ETF	84.01	84.02	83.43	83.7	6503757.0
2007-10-12 14:00:00	IWM	ETF	83.7	83.93	83.64	83.78	6149300.0
2007-10-12 15:00:00	IWM	ETF	83.78	83.81	83.5	83.66	9586401.0
2007-10-12 16:00:00	IWM	ETF	83.68	84.1	83.65	84.1	2173100.0
2007-10-12 17:00:00	IWM	ETF	84.08	84.08	84.08	84.08	2400.0
2007-10-12 19:00:00	IWM	ETF	84.05	84.05	84.05	84.05	300.0
2007-10-12 08:00:00	DIA	ETF	140.08	140.45	140.06	140.39	64000.0
2007-10-12 09:00:00	DIA	ETF	140.43	140.5	140.13	140.31	1308600.0
2007-10-12 10:00:00	DIA	ETF	140.31	140.61	140.09	140.49	1071803.0
2007-10-12 11:00:00	DIA	ETF	140.51	140.82	140.45	140.7	921300.0
2007-10-12 12:00:00	DIA	ETF	140.66	140.97	140.6	140.93	802400.0
2007-10-12 13:00:00	DIA	ETF	140.92	140.94	140.52	140.74	1361400.0

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

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