PREVIEW / etf_1hour / 2010-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-25.parquet
  size:    172 KB
  rows:    5,287

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-10-25 04:00:00	SPY	ETF	118.89	119.39	118.89	119.3	3068.0
2010-10-25 05:00:00	SPY	ETF	119.25	119.25	119.17	119.17	5400.0
2010-10-25 06:00:00	SPY	ETF	119.3	119.4	119.3	119.37	222851.0
2010-10-25 07:00:00	SPY	ETF	119.35	119.36	119.17	119.27	362642.0
2010-10-25 08:00:00	SPY	ETF	119.15	119.3	118.95	119.13	1514767.0
2010-10-25 09:00:00	SPY	ETF	119.12	119.64	119.07	119.56	18760621.0
2010-10-25 10:00:00	SPY	ETF	119.56	119.76	118.95	119.08	30208336.0
2010-10-25 11:00:00	SPY	ETF	119.1	119.26	118.88	119.05	16361406.0
2010-10-25 12:00:00	SPY	ETF	119.04	119.08	118.72	118.84	12966282.0
2010-10-25 13:00:00	SPY	ETF	118.83	119.13	118.76	119.0	12173062.0
2010-10-25 14:00:00	SPY	ETF	119.0	119.13	118.77	118.95	11763739.0
2010-10-25 15:00:00	SPY	ETF	118.94	119.28	118.61	118.68	32317129.0
2010-10-25 16:00:00	SPY	ETF	118.68	119.475	118.62	118.71	9866217.0
2010-10-25 17:00:00	SPY	ETF	118.71	118.82	118.7	118.74	148317.0
2010-10-25 18:00:00	SPY	ETF	118.73	119.254	118.63	118.7	180394.0
2010-10-25 19:00:00	SPY	ETF	118.7	118.7	118.6	118.68	68607.0
2010-10-25 04:00:00	QQQ	ETF	51.75	52.02	51.75	52.0	23130.0
2010-10-25 05:00:00	QQQ	ETF	52.0	52.0	51.99	51.99	1300.0
2010-10-25 06:00:00	QQQ	ETF	51.98	52.0	51.98	52.0	2750.0
2010-10-25 07:00:00	QQQ	ETF	51.97	52.0	51.95	51.97	54365.0
2010-10-25 08:00:00	QQQ	ETF	51.96	52.0	51.9	51.92	364161.0
2010-10-25 09:00:00	QQQ	ETF	51.93	52.18	51.85	52.18	9048100.0
2010-10-25 10:00:00	QQQ	ETF	52.16	52.23	51.9	51.96	9460198.0
2010-10-25 11:00:00	QQQ	ETF	51.95	52.06	51.86	52.01	5671656.0
2010-10-25 12:00:00	QQQ	ETF	52.0042	52.02	51.87	51.9105	3482855.0
2010-10-25 13:00:00	QQQ	ETF	51.91	52.07	51.88	52.03	5284833.0
2010-10-25 14:00:00	QQQ	ETF	52.03	52.1	51.94	52.005	4175368.0
2010-10-25 15:00:00	QQQ	ETF	52.005	52.12	51.87	51.89	10652884.0
2010-10-25 16:00:00	QQQ	ETF	51.89	51.9	51.78	51.83	1497225.0
2010-10-25 17:00:00	QQQ	ETF	51.84	51.85	51.83	51.83	30865.0
2010-10-25 18:00:00	QQQ	ETF	51.83	51.84	51.8	51.84	85273.0
2010-10-25 19:00:00	QQQ	ETF	51.8	51.82	51.78	51.8	24321.0
2010-10-25 04:00:00	IWM	ETF	70.79	70.99	70.79	70.99	1647.0
2010-10-25 05:00:00	IWM	ETF	70.84	70.84	70.84	70.84	580.0
2010-10-25 07:00:00	IWM	ETF	70.98	70.98	70.83	70.9	14000.0
2010-10-25 08:00:00	IWM	ETF	70.89	70.9	70.8	70.86	1221505.0
2010-10-25 09:00:00	IWM	ETF	70.85	71.45	70.77	71.43	6465917.0
2010-10-25 10:00:00	IWM	ETF	71.45	71.56	70.73	70.8801	7245185.0
2010-10-25 11:00:00	IWM	ETF	70.89	71.09	70.76	70.9801	2536081.0
2010-10-25 12:00:00	IWM	ETF	70.99	71.02	70.76	70.82	1926973.0
2010-10-25 13:00:00	IWM	ETF	70.83	71.06	70.7898	70.93	2587686.0
2010-10-25 14:00:00	IWM	ETF	70.93	71.11	70.82	70.92	2455656.0
2010-10-25 15:00:00	IWM	ETF	70.92	71.13	70.63	70.73	7571489.0
2010-10-25 16:00:00	IWM	ETF	70.74	71.0902	70.65	70.74	2339194.0
2010-10-25 17:00:00	IWM	ETF	70.79	70.81	70.77	70.79	9400.0
2010-10-25 18:00:00	IWM	ETF	70.8	70.8	70.8	70.8	13488.0
2010-10-25 19:00:00	IWM	ETF	70.74	70.74	70.7	70.7	2600.0
2010-10-25 06:00:00	DIA	ETF	112.02	112.02	112.02	112.02	200.0
2010-10-25 07:00:00	DIA	ETF	112.06	112.12	112.0	112.06	30700.0
2010-10-25 08:00:00	DIA	ETF	112.06	112.11	111.88	111.88	76399.0

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

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