PREVIEW / etf_1hour / 2007-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-11.parquet
  size:    81 KB
  rows:    2,764

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-07-11 04:00:00	SPY	ETF	151.22	151.22	151.19	151.22	7200.0
2007-07-11 05:00:00	SPY	ETF	151.36	151.37	151.32	151.35	33000.0
2007-07-11 06:00:00	SPY	ETF	151.43	151.43	151.24	151.24	66500.0
2007-07-11 07:00:00	SPY	ETF	151.15	151.15	150.4	150.79	3026000.0
2007-07-11 08:00:00	SPY	ETF	150.55	151.34	150.46	151.03	10229400.0
2007-07-11 09:00:00	SPY	ETF	150.97	151.19	150.52	150.76	27961494.0
2007-07-11 10:00:00	SPY	ETF	150.76	151.44	150.54	151.39	38388100.0
2007-07-11 11:00:00	SPY	ETF	151.38	151.8	151.38	151.58	18580260.0
2007-07-11 12:00:00	SPY	ETF	151.59	151.75	151.34	151.46	10731863.0
2007-07-11 13:00:00	SPY	ETF	151.45	151.89	151.39	151.4	12091500.0
2007-07-11 14:00:00	SPY	ETF	151.41	151.64	151.04	151.2	23533600.0
2007-07-11 15:00:00	SPY	ETF	151.2	151.87	151.12	151.83	20237900.0
2007-07-11 16:00:00	SPY	ETF	151.83	152.16	150.9463	152.13	6309400.0
2007-07-11 17:00:00	SPY	ETF	152.13	152.18	152.03	152.1	2143900.0
2007-07-11 18:00:00	SPY	ETF	152.12	152.35	152.08	152.19	41600.0
2007-07-11 19:00:00	SPY	ETF	152.2	152.26	152.2	152.24	48200.0
2007-07-11 07:00:00	QQQ	ETF	48.5	48.5	48.29	48.45	1257417.0
2007-07-11 08:00:00	QQQ	ETF	48.45	48.53	48.38	48.44	2686812.0
2007-07-11 09:00:00	QQQ	ETF	48.44	48.57	48.32	48.38	13581246.0
2007-07-11 10:00:00	QQQ	ETF	48.38	48.64	48.33	48.61	18771404.0
2007-07-11 11:00:00	QQQ	ETF	48.61	48.7	48.57	48.64	12769220.0
2007-07-11 12:00:00	QQQ	ETF	48.65	48.72	48.62	48.6494	7046665.0
2007-07-11 13:00:00	QQQ	ETF	48.65	48.78	48.62	48.66	11551507.0
2007-07-11 14:00:00	QQQ	ETF	48.66	48.73	48.54	48.595	12182457.0
2007-07-11 15:00:00	QQQ	ETF	48.59	48.81	48.58	48.8	13530336.0
2007-07-11 16:00:00	QQQ	ETF	48.8	48.97	48.8	48.97	3277049.0
2007-07-11 17:00:00	QQQ	ETF	48.97	48.98	48.81	48.81	641419.0
2007-07-11 18:00:00	QQQ	ETF	48.95	48.99	48.93	48.97	39702.0
2007-07-11 19:00:00	QQQ	ETF	48.98	48.98	48.96	48.98	30430.0
2007-07-11 05:00:00	IWM	ETF	83.5	83.5	83.47	83.47	10000.0
2007-07-11 06:00:00	IWM	ETF	83.53	83.53	83.53	83.53	5000.0
2007-07-11 07:00:00	IWM	ETF	83.27	83.33	82.8	83.15	787500.0
2007-07-11 08:00:00	IWM	ETF	83.03	83.56	83.02	83.43	3200700.0
2007-07-11 09:00:00	IWM	ETF	83.44	83.51	82.96	83.04	9666902.0
2007-07-11 10:00:00	IWM	ETF	83.04	83.49	82.9	83.35	13989900.0
2007-07-11 11:00:00	IWM	ETF	83.35	83.59	83.34	83.53	5419350.0
2007-07-11 12:00:00	IWM	ETF	83.52	83.66	83.31	83.41	4585500.0
2007-07-11 13:00:00	IWM	ETF	83.4	83.66	83.31	83.32	5115600.0
2007-07-11 14:00:00	IWM	ETF	83.31	83.47	83.11	83.25	11332200.0
2007-07-11 15:00:00	IWM	ETF	83.24	83.6	83.16	83.6	9045700.0
2007-07-11 16:00:00	IWM	ETF	83.6	83.87	83.25	83.49	7671300.0
2007-07-11 17:00:00	IWM	ETF	83.87	83.87	83.83	83.85	30500.0
2007-07-11 18:00:00	IWM	ETF	83.84	83.87	83.83	83.87	6200.0
2007-07-11 07:00:00	DIA	ETF	134.94	134.94	134.65	134.85	116100.0
2007-07-11 08:00:00	DIA	ETF	134.84	135.1	134.77	134.95	89000.0
2007-07-11 09:00:00	DIA	ETF	134.89	135.22	134.75	134.94	1296300.0
2007-07-11 10:00:00	DIA	ETF	134.94	135.48	134.83	135.38	6270400.0
2007-07-11 11:00:00	DIA	ETF	135.4	135.71	135.39	135.61	1590600.0
2007-07-11 12:00:00	DIA	ETF	135.62	135.72	135.4	135.52	1316000.0
2007-07-11 13:00:00	DIA	ETF	135.52	135.89	135.47	135.69	1189300.0

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

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