PREVIEW / etf_1hour / 2011-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-25.parquet
  size:    186 KB
  rows:    5,708

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-25 04:00:00	SPY	ETF	125.38	125.38	125.16	125.34	1140.0
2011-10-25 05:00:00	SPY	ETF	125.39	125.49	125.39	125.43	500.0
2011-10-25 06:00:00	SPY	ETF	125.36	125.95	125.24	125.85	174220.0
2011-10-25 07:00:00	SPY	ETF	125.76	125.99	125.62	125.72	558932.0
2011-10-25 08:00:00	SPY	ETF	125.71	125.79	124.77	124.87	4769757.0
2011-10-25 09:00:00	SPY	ETF	124.87	125.11	123.33	124.01	61360500.0
2011-10-25 10:00:00	SPY	ETF	124.0	124.72	123.62	124.17	45440439.0
2011-10-25 11:00:00	SPY	ETF	124.17	124.32	123.7	124.04	25941935.0
2011-10-25 12:00:00	SPY	ETF	124.05	124.64	123.915	124.1	18966504.0
2011-10-25 13:00:00	SPY	ETF	124.1	124.5	123.97	124.2	18751385.0
2011-10-25 14:00:00	SPY	ETF	124.21	124.21	123.58	123.99	23881834.0
2011-10-25 15:00:00	SPY	ETF	124.0	124.22	122.78	123.06	50820005.0
2011-10-25 16:00:00	SPY	ETF	123.06	124.7	122.82	123.02	10601682.0
2011-10-25 17:00:00	SPY	ETF	123.04	123.17	123.0	123.06	511290.0
2011-10-25 18:00:00	SPY	ETF	123.09	125.5299	122.98	123.0	4539612.0
2011-10-25 19:00:00	SPY	ETF	122.98	123.07	122.86	122.99	131582.0
2011-10-25 06:00:00	QQQ	ETF	58.5	58.68	58.5	58.6	42588.0
2011-10-25 07:00:00	QQQ	ETF	58.58	58.65	58.54	58.57	161424.0
2011-10-25 08:00:00	QQQ	ETF	58.58	58.59	58.25	58.28	524733.0
2011-10-25 09:00:00	QQQ	ETF	58.28	58.36	57.77	58.06	12901378.0
2011-10-25 10:00:00	QQQ	ETF	57.98	58.22	57.8	57.99	9468579.0
2011-10-25 11:00:00	QQQ	ETF	57.99	58.06	57.7	57.76	6721064.0
2011-10-25 12:00:00	QQQ	ETF	57.76	58.03	57.71	57.8	5347031.0
2011-10-25 13:00:00	QQQ	ETF	57.8	57.97	57.71	57.7735	3816383.0
2011-10-25 14:00:00	QQQ	ETF	57.77	57.77	57.44	57.67	7372960.0
2011-10-25 15:00:00	QQQ	ETF	57.67	57.78	57.22	57.35	10728621.0
2011-10-25 16:00:00	QQQ	ETF	57.36	57.4634	56.93	57.08	3173938.0
2011-10-25 17:00:00	QQQ	ETF	57.06	57.17	57.06	57.15	116524.0
2011-10-25 18:00:00	QQQ	ETF	57.15	57.16	57.1	57.1	61241.0
2011-10-25 19:00:00	QQQ	ETF	57.1	57.11	57.04	57.1	32244.0
2011-10-25 04:00:00	IWM	ETF	73.37	73.46	73.37	73.46	10200.0
2011-10-25 05:00:00	IWM	ETF	73.59	73.59	73.59	73.59	200.0
2011-10-25 06:00:00	IWM	ETF	73.5	73.88	73.5	73.82	11600.0
2011-10-25 07:00:00	IWM	ETF	73.75	73.95	73.71	73.79	93631.0
2011-10-25 08:00:00	IWM	ETF	73.78	73.81	72.92	72.98	744463.0
2011-10-25 09:00:00	IWM	ETF	72.97	73.08	71.64	72.21	15576551.0
2011-10-25 10:00:00	IWM	ETF	72.27	72.77	71.93	72.33	12112043.0
2011-10-25 11:00:00	IWM	ETF	72.33	72.42	72.13	72.35	5226127.0
2011-10-25 12:00:00	IWM	ETF	72.34	72.69	72.22	72.23	3724202.0
2011-10-25 13:00:00	IWM	ETF	72.23	72.6	72.22	72.34	3643461.0
2011-10-25 14:00:00	IWM	ETF	72.33	72.33	71.72	72.05	7535918.0
2011-10-25 15:00:00	IWM	ETF	72.06	72.205	71.16	71.35	12999540.0
2011-10-25 16:00:00	IWM	ETF	71.36	71.65	71.29	71.46	1599200.0
2011-10-25 17:00:00	IWM	ETF	71.43	71.51	71.4	71.46	10478.0
2011-10-25 18:00:00	IWM	ETF	71.45	71.49	71.4	71.4	14345.0
2011-10-25 19:00:00	IWM	ETF	71.4	71.41	71.3	71.38	2950.0
2011-10-25 06:00:00	DIA	ETF	119.01	119.11	119.01	119.11	3500.0
2011-10-25 07:00:00	DIA	ETF	118.99	119.13	118.77	118.77	9600.0
2011-10-25 08:00:00	DIA	ETF	118.88	118.88	118.14	118.21	11856.0
2011-10-25 09:00:00	DIA	ETF	118.08	118.34	117.13	117.77	1604438.0

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

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