PREVIEW / etf_1hour / 2011-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-24.parquet
  size:    187 KB
  rows:    5,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
2011-10-24 04:00:00	SPY	ETF	124.23	124.64	124.05	124.1	72300.0
2011-10-24 05:00:00	SPY	ETF	124.05	124.43	123.99	124.4	40570.0
2011-10-24 06:00:00	SPY	ETF	124.4	124.48	123.85	123.9	162341.0
2011-10-24 07:00:00	SPY	ETF	123.85	124.15	123.79	124.09	832372.0
2011-10-24 08:00:00	SPY	ETF	124.13	124.5	123.9	124.42	2060870.0
2011-10-24 09:00:00	SPY	ETF	124.43	124.86	124.06	124.63	23241188.0
2011-10-24 10:00:00	SPY	ETF	124.63	125.17	124.46	124.9099	29780141.0
2011-10-24 11:00:00	SPY	ETF	124.91	125.59	124.909	125.36	29482110.0
2011-10-24 12:00:00	SPY	ETF	125.36	125.44	125.05	125.3	18728532.0
2011-10-24 13:00:00	SPY	ETF	125.3	125.8	125.205	125.67	13713527.0
2011-10-24 14:00:00	SPY	ETF	125.67	125.73	125.24	125.61	17310241.0
2011-10-24 15:00:00	SPY	ETF	125.595	125.78	125.09	125.5114	47597408.0
2011-10-24 16:00:00	SPY	ETF	125.48	125.75	123.938	125.27	14695666.0
2011-10-24 17:00:00	SPY	ETF	125.26	125.39	125.22	125.35	1451666.0
2011-10-24 18:00:00	SPY	ETF	125.35	125.49	125.08	125.08	699581.0
2011-10-24 19:00:00	SPY	ETF	125.1	125.2	125.09	125.2	297647.0
2011-10-24 04:00:00	QQQ	ETF	57.48	57.62	57.48	57.59	750.0
2011-10-24 05:00:00	QQQ	ETF	57.66	57.66	57.66	57.66	500.0
2011-10-24 06:00:00	QQQ	ETF	57.55	57.6	57.4	57.4	6800.0
2011-10-24 07:00:00	QQQ	ETF	57.43	57.51	57.41	57.46	9295.0
2011-10-24 08:00:00	QQQ	ETF	57.5	57.7	57.42	57.63	261139.0
2011-10-24 09:00:00	QQQ	ETF	57.61	57.93	57.45	57.81	7602961.0
2011-10-24 10:00:00	QQQ	ETF	57.81	58.24	57.6999	58.1925	11893876.0
2011-10-24 11:00:00	QQQ	ETF	58.2	58.5	58.2	58.439	6365505.0
2011-10-24 12:00:00	QQQ	ETF	58.43	58.53	58.37	58.48	4096970.0
2011-10-24 13:00:00	QQQ	ETF	58.48	58.64	58.41	58.6	3305493.0
2011-10-24 14:00:00	QQQ	ETF	58.5905	58.65	58.44	58.55	4976609.0
2011-10-24 15:00:00	QQQ	ETF	58.55	58.6	58.32	58.49	7708701.0
2011-10-24 16:00:00	QQQ	ETF	58.49	58.53	58.3	58.32	3545765.0
2011-10-24 17:00:00	QQQ	ETF	58.31	58.35	58.26	58.35	215411.0
2011-10-24 18:00:00	QQQ	ETF	58.33	58.35	58.26	58.26	64813.0
2011-10-24 19:00:00	QQQ	ETF	58.27	58.35	58.23	58.35	24377.0
2011-10-24 04:00:00	IWM	ETF	71.6	71.6	71.6	71.6	944.0
2011-10-24 06:00:00	IWM	ETF	71.6	71.6	71.19	71.19	2500.0
2011-10-24 07:00:00	IWM	ETF	71.14	71.39	71.14	71.35	33400.0
2011-10-24 08:00:00	IWM	ETF	71.41	71.64	71.3	71.61	490063.0
2011-10-24 09:00:00	IWM	ETF	71.62	72.22	71.3	72.03	5797111.0
2011-10-24 10:00:00	IWM	ETF	72.02	72.54	71.85	72.41	10585216.0
2011-10-24 11:00:00	IWM	ETF	72.42	73.39	72.42	73.2001	13196855.0
2011-10-24 12:00:00	IWM	ETF	73.2	73.28	72.92	73.12	4467556.0
2011-10-24 13:00:00	IWM	ETF	73.12	73.57	73.04	73.51	4335384.0
2011-10-24 14:00:00	IWM	ETF	73.51	73.53	73.11	73.48	5520836.0
2011-10-24 15:00:00	IWM	ETF	73.48	73.58	73.05	73.4	14910229.0
2011-10-24 16:00:00	IWM	ETF	73.39	73.45	71.1604	73.08	7153830.0
2011-10-24 17:00:00	IWM	ETF	73.06	73.2	73.0	73.2	21097.0
2011-10-24 18:00:00	IWM	ETF	73.2	73.24	73.08	73.08	16059.0
2011-10-24 19:00:00	IWM	ETF	73.2	73.2	73.08	73.09	1550.0
2011-10-24 06:00:00	DIA	ETF	118.0	118.0	118.0	118.0	2500.0
2011-10-24 07:00:00	DIA	ETF	118.1	118.22	118.1	118.22	900.0
2011-10-24 08:00:00	DIA	ETF	118.2	118.4	118.06	118.37	28411.0

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

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