PREVIEW / etf_1hour / 2010-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-01.parquet
  size:    169 KB
  rows:    5,129

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
2010-07-01 04:00:00	SPY	ETF	102.91	103.0	102.85	102.95	4900.0
2010-07-01 05:00:00	SPY	ETF	102.95	102.95	102.73	102.75	8200.0
2010-07-01 06:00:00	SPY	ETF	102.8	103.26	102.8	103.25	207200.0
2010-07-01 07:00:00	SPY	ETF	103.26	103.26	102.82	102.86	1812486.0
2010-07-01 08:00:00	SPY	ETF	102.86	103.22	102.42	103.12	9074855.0
2010-07-01 09:00:00	SPY	ETF	103.11	103.49	102.48	102.81	36195678.0
2010-07-01 10:00:00	SPY	ETF	102.85	102.87	101.26	101.5	82648850.0
2010-07-01 11:00:00	SPY	ETF	101.5	102.25	101.13	102.03	53577101.0
2010-07-01 12:00:00	SPY	ETF	102.04	102.93	101.68	102.52	41551188.0
2010-07-01 13:00:00	SPY	ETF	102.52	102.98	102.27	102.7901	29467695.0
2010-07-01 14:00:00	SPY	ETF	102.79	103.13	102.08	102.47	42004346.0
2010-07-01 15:00:00	SPY	ETF	102.47	103.04	102.32	102.79	60082541.0
2010-07-01 16:00:00	SPY	ETF	102.8	103.1432	102.1	102.69	23820203.0
2010-07-01 17:00:00	SPY	ETF	102.69	102.78	102.68	102.75	327873.0
2010-07-01 18:00:00	SPY	ETF	102.78	102.88	102.77	102.85	212170.0
2010-07-01 19:00:00	SPY	ETF	102.87	102.93	102.77	102.93	61369.0
2010-07-01 04:00:00	QQQ	ETF	42.58	42.65	42.58	42.65	3100.0
2010-07-01 06:00:00	QQQ	ETF	42.65	42.73	42.65	42.73	29600.0
2010-07-01 07:00:00	QQQ	ETF	42.72	42.72	42.57	42.58	810280.0
2010-07-01 08:00:00	QQQ	ETF	42.57	42.75	42.45	42.72	4278776.0
2010-07-01 09:00:00	QQQ	ETF	42.73	42.96	42.6	42.67	19410806.0
2010-07-01 10:00:00	QQQ	ETF	42.67	42.67	41.77	42.01	35782655.0
2010-07-01 11:00:00	QQQ	ETF	42.0	42.51	41.9	42.41	22038054.0
2010-07-01 12:00:00	QQQ	ETF	42.41	42.73	42.21	42.54	17012433.0
2010-07-01 13:00:00	QQQ	ETF	42.53	42.8256	42.42	42.63	10435225.0
2010-07-01 14:00:00	QQQ	ETF	42.62	42.79	42.28	42.47	15192525.0
2010-07-01 15:00:00	QQQ	ETF	42.47	42.74	42.38	42.58	21497085.0
2010-07-01 16:00:00	QQQ	ETF	42.58	42.71	42.51	42.53	2277846.0
2010-07-01 17:00:00	QQQ	ETF	42.52	42.6	42.52	42.58	164723.0
2010-07-01 18:00:00	QQQ	ETF	42.58	42.61	42.58	42.61	6554.0
2010-07-01 19:00:00	QQQ	ETF	42.61	42.63	42.57	42.62	41475.0
2010-07-01 04:00:00	IWM	ETF	60.9	60.9	60.9	60.9	100.0
2010-07-01 05:00:00	IWM	ETF	60.82	60.82	60.81	60.81	600.0
2010-07-01 06:00:00	IWM	ETF	60.89	61.09	60.86	61.09	1700.0
2010-07-01 07:00:00	IWM	ETF	61.09	61.09	60.9	60.91	239300.0
2010-07-01 08:00:00	IWM	ETF	60.89	61.19	60.69	61.17	2190249.0
2010-07-01 09:00:00	IWM	ETF	61.18	61.4	60.6	60.7	13127172.0
2010-07-01 10:00:00	IWM	ETF	60.69	60.71	59.27	59.392	21127220.0
2010-07-01 11:00:00	IWM	ETF	59.4	60.25	59.12	59.95	15068477.0
2010-07-01 12:00:00	IWM	ETF	59.95	60.66	59.715	60.18	10973522.0
2010-07-01 13:00:00	IWM	ETF	60.19	60.57	60.09	60.42	8285812.0
2010-07-01 14:00:00	IWM	ETF	60.42	60.76	60.05	60.41	14143468.0
2010-07-01 15:00:00	IWM	ETF	60.41	60.88	60.29	60.68	20013006.0
2010-07-01 16:00:00	IWM	ETF	60.68	60.7319	60.56	60.7319	1273594.0
2010-07-01 17:00:00	IWM	ETF	60.6	60.67	60.6	60.67	4945.0
2010-07-01 18:00:00	IWM	ETF	60.68	60.71	60.67	60.67	3700.0
2010-07-01 19:00:00	IWM	ETF	60.62	60.71	60.62	60.7	3700.0
2010-07-01 07:00:00	DIA	ETF	97.75	97.79	97.63	97.67	27050.0
2010-07-01 08:00:00	DIA	ETF	97.54	97.75	97.27	97.75	363748.0
2010-07-01 09:00:00	DIA	ETF	97.77	98.0	97.43	97.51	1798022.0

> showing 50 of 5,129 rows — these rows as CSV

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