PREVIEW / etf_1hour / 2010-11-01

all etf 1-hour files

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

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-11-01 04:00:00	SPY	ETF	118.8	119.41	118.8	119.41	28388.0
2010-11-01 05:00:00	SPY	ETF	119.41	119.41	119.15	119.15	1530.0
2010-11-01 06:00:00	SPY	ETF	119.05	119.15	118.94	119.15	131450.0
2010-11-01 07:00:00	SPY	ETF	119.11	119.17	118.96	118.98	398834.0
2010-11-01 08:00:00	SPY	ETF	118.96	119.37	118.49	119.02	1177139.0
2010-11-01 09:00:00	SPY	ETF	119.03	119.42	118.49	119.28	18056964.0
2010-11-01 10:00:00	SPY	ETF	119.29	119.75	119.2875	119.37	31554972.0
2010-11-01 11:00:00	SPY	ETF	119.37	119.38	118.76	119.05	23920509.0
2010-11-01 12:00:00	SPY	ETF	119.04	119.11	118.7497	118.83	14084769.0
2010-11-01 13:00:00	SPY	ETF	118.82	119.06	118.69	118.91	11227433.0
2010-11-01 14:00:00	SPY	ETF	118.91	118.95	118.36	118.46	19795401.0
2010-11-01 15:00:00	SPY	ETF	118.47	118.58	117.85	118.55	37991930.0
2010-11-01 16:00:00	SPY	ETF	118.55	119.705	118.46	118.7	10758436.0
2010-11-01 17:00:00	SPY	ETF	118.71	118.75	118.4601	118.7	2376723.0
2010-11-01 18:00:00	SPY	ETF	118.67	118.68	118.53	118.6	168178.0
2010-11-01 19:00:00	SPY	ETF	118.63	118.77	118.6	118.74	64695.0
2010-11-01 04:00:00	QQQ	ETF	52.46	52.49	52.44	52.47	22200.0
2010-11-01 05:00:00	QQQ	ETF	52.46	52.5	52.46	52.5	400.0
2010-11-01 06:00:00	QQQ	ETF	52.36	52.4	52.34	52.4	15200.0
2010-11-01 07:00:00	QQQ	ETF	52.4	52.41	52.34	52.34	21280.0
2010-11-01 08:00:00	QQQ	ETF	52.32	52.38	52.25	52.34	580350.0
2010-11-01 09:00:00	QQQ	ETF	52.35	52.68	52.32	52.5999	7458854.0
2010-11-01 10:00:00	QQQ	ETF	52.6	52.75	52.44	52.47	9444544.0
2010-11-01 11:00:00	QQQ	ETF	52.46	52.4625	52.1	52.3	9481024.0
2010-11-01 12:00:00	QQQ	ETF	52.31	52.37	52.24	52.29	3682739.0
2010-11-01 13:00:00	QQQ	ETF	52.29	52.41	52.21	52.35	6375664.0
2010-11-01 14:00:00	QQQ	ETF	52.35	52.38	52.19	52.245	5279726.0
2010-11-01 15:00:00	QQQ	ETF	52.24	52.25	51.98	52.23	14312344.0
2010-11-01 16:00:00	QQQ	ETF	52.23	52.35	52.2	52.28	1551767.0
2010-11-01 17:00:00	QQQ	ETF	52.3	52.3	52.29	52.29	7700.0
2010-11-01 18:00:00	QQQ	ETF	52.28	52.3	52.26	52.26	19290.0
2010-11-01 19:00:00	QQQ	ETF	52.28	52.33	52.28	52.32	23596.0
2010-11-01 06:00:00	IWM	ETF	70.67	70.67	70.65	70.65	200.0
2010-11-01 07:00:00	IWM	ETF	70.69	70.8	70.69	70.7	32600.0
2010-11-01 08:00:00	IWM	ETF	70.72	70.73	70.62	70.63	341818.0
2010-11-01 09:00:00	IWM	ETF	70.63	70.89	70.3	70.71	3474647.0
2010-11-01 10:00:00	IWM	ETF	70.72	71.17	70.71	70.8	7572807.0
2010-11-01 11:00:00	IWM	ETF	70.8	70.8	70.04	70.19	6401202.0
2010-11-01 12:00:00	IWM	ETF	70.2	70.28	69.98	70.06	3958092.0
2010-11-01 13:00:00	IWM	ETF	70.06	70.23	69.88	70.18	3393394.0
2010-11-01 14:00:00	IWM	ETF	70.18	70.21	69.77	69.84	4381621.0
2010-11-01 15:00:00	IWM	ETF	69.84	69.93	69.31	69.82	11607315.0
2010-11-01 16:00:00	IWM	ETF	69.82	70.3631	69.81	70.08	3274743.0
2010-11-01 17:00:00	IWM	ETF	70.08	70.11	70.02	70.11	2790.0
2010-11-01 18:00:00	IWM	ETF	70.09	70.09	69.89	70.01	11213.0
2010-11-01 07:00:00	DIA	ETF	111.73	111.74	111.73	111.74	20000.0
2010-11-01 08:00:00	DIA	ETF	111.66	111.7	111.55	111.61	27403.0
2010-11-01 09:00:00	DIA	ETF	111.73	112.2	111.65	112.06	1543724.0
2010-11-01 10:00:00	DIA	ETF	112.08	112.51	112.08	112.21	1577990.0
2010-11-01 11:00:00	DIA	ETF	112.2	112.2	111.49	111.78	1034252.0

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

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