PREVIEW / etf_1hour / 2007-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-16.parquet
  size:    94 KB
  rows:    3,093

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-16 04:00:00	SPY	ETF	140.31	140.31	140.09	140.09	2400.0
2007-08-16 05:00:00	SPY	ETF	139.99	139.99	139.47	139.76	4900.0
2007-08-16 06:00:00	SPY	ETF	139.74	139.98	139.15	139.39	351200.0
2007-08-16 07:00:00	SPY	ETF	139.39	139.6	139.05	139.35	3105700.0
2007-08-16 08:00:00	SPY	ETF	139.4	140.3	139.15	140.06	10375800.0
2007-08-16 09:00:00	SPY	ETF	140.06	140.77	139.5	139.71	52053142.0
2007-08-16 10:00:00	SPY	ETF	139.69	140.45	137.0	139.52	68107536.0
2007-08-16 11:00:00	SPY	ETF	139.52	140.46	138.74	139.12	52029272.0
2007-08-16 12:00:00	SPY	ETF	139.11	139.15	137.34	137.55	71354420.0
2007-08-16 13:00:00	SPY	ETF	137.55	139.64	137.25	139.28	70261153.0
2007-08-16 14:00:00	SPY	ETF	139.29	140.75	138.89	139.68	80112659.0
2007-08-16 15:00:00	SPY	ETF	139.68	141.93	137.93	141.73	110731587.0
2007-08-16 16:00:00	SPY	ETF	141.64	142.99	137.54	142.63	12338100.0
2007-08-16 17:00:00	SPY	ETF	142.6	142.75	140.6	142.47	2281000.0
2007-08-16 18:00:00	SPY	ETF	142.5	142.78	142.47	142.51	287100.0
2007-08-16 19:00:00	SPY	ETF	142.48	142.56	139.433	142.54	264000.0
2007-08-16 05:00:00	QQQ	ETF	45.6	45.6	45.52	45.55	10600.0
2007-08-16 06:00:00	QQQ	ETF	45.6	45.6	45.44	45.49	72800.0
2007-08-16 07:00:00	QQQ	ETF	45.46	45.54	45.33	45.5	1617134.0
2007-08-16 08:00:00	QQQ	ETF	45.49	45.69	45.43	45.65	2973156.0
2007-08-16 09:00:00	QQQ	ETF	45.65	45.91	45.47	45.47	30192821.0
2007-08-16 10:00:00	QQQ	ETF	45.48	45.52	45.12	45.3489	40416930.0
2007-08-16 11:00:00	QQQ	ETF	45.341	45.68	45.03	45.16	36768649.0
2007-08-16 12:00:00	QQQ	ETF	45.16	45.17	44.41	44.5	49391100.0
2007-08-16 13:00:00	QQQ	ETF	44.5	45.11	44.39	44.98	49242201.0
2007-08-16 14:00:00	QQQ	ETF	44.98	45.43	44.8	44.97	42727635.0
2007-08-16 15:00:00	QQQ	ETF	44.97	45.58	44.44	45.53	58515864.0
2007-08-16 16:00:00	QQQ	ETF	45.52	45.74	45.3	45.63	7168334.0
2007-08-16 17:00:00	QQQ	ETF	45.65	45.7	45.45	45.59	4244585.0
2007-08-16 18:00:00	QQQ	ETF	45.59	45.63	45.52	45.62	342154.0
2007-08-16 19:00:00	QQQ	ETF	45.6	45.62	45.56	45.57	41871.0
2007-08-16 06:00:00	IWM	ETF	74.28	74.46	74.28	74.46	9000.0
2007-08-16 07:00:00	IWM	ETF	74.32	74.35	74.08	74.21	1064700.0
2007-08-16 08:00:00	IWM	ETF	74.26	74.87	74.23	74.75	2376100.0
2007-08-16 09:00:00	IWM	ETF	74.73	75.57	74.37	74.89	21842124.0
2007-08-16 10:00:00	IWM	ETF	74.89	75.37	74.36	75.03	41092310.0
2007-08-16 11:00:00	IWM	ETF	75.03	76.32	74.31	74.77	43954042.0
2007-08-16 12:00:00	IWM	ETF	74.77	74.85	73.27	73.42	41143480.0
2007-08-16 13:00:00	IWM	ETF	73.42	75.12	73.24	74.94	49350885.0
2007-08-16 14:00:00	IWM	ETF	74.93	76.4	74.31	74.65	51181491.0
2007-08-16 15:00:00	IWM	ETF	74.65	76.73	73.94	76.66	58645230.0
2007-08-16 16:00:00	IWM	ETF	76.66	77.01	76.5	77.0	3627500.0
2007-08-16 17:00:00	IWM	ETF	77.04	77.1	75.2	76.86	862400.0
2007-08-16 18:00:00	IWM	ETF	76.99	77.15	76.98	77.09	21200.0
2007-08-16 19:00:00	IWM	ETF	73.9278	77.16	73.9278	77.16	156000.0
2007-08-16 07:00:00	DIA	ETF	127.54	127.59	126.59	127.36	254500.0
2007-08-16 08:00:00	DIA	ETF	126.6	128.21	126.6	128.15	432500.0
2007-08-16 09:00:00	DIA	ETF	128.1	128.42	127.58	127.66	4323800.0
2007-08-16 10:00:00	DIA	ETF	127.68	127.88	126.97	127.41	6629900.0
2007-08-16 11:00:00	DIA	ETF	127.42	128.08	126.8	127.09	5096900.0

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

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