PREVIEW / etf_1hour / 2010-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-30.parquet
  size:    173 KB
  rows:    5,336

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-30 04:00:00	SPY	ETF	118.78	118.88	118.6	118.88	49739.0
2010-11-30 05:00:00	SPY	ETF	118.8	119.24	118.79	119.15	15790.0
2010-11-30 06:00:00	SPY	ETF	119.07	119.11	118.77	118.92	271300.0
2010-11-30 07:00:00	SPY	ETF	118.92	118.98	118.35	118.35	2418521.0
2010-11-30 08:00:00	SPY	ETF	118.37	118.9	117.86	118.06	6512372.0
2010-11-30 09:00:00	SPY	ETF	118.04	119.16	117.81	118.42	31092747.0
2010-11-30 10:00:00	SPY	ETF	118.42	118.88	118.23	118.485	33790541.0
2010-11-30 11:00:00	SPY	ETF	118.49	118.74	118.29	118.65	21138270.0
2010-11-30 12:00:00	SPY	ETF	118.65	118.77	118.465	118.74	20163116.0
2010-11-30 13:00:00	SPY	ETF	118.74	119.17	118.68	118.945	26495079.0
2010-11-30 14:00:00	SPY	ETF	118.95	119.135	118.53	118.86	29066326.0
2010-11-30 15:00:00	SPY	ETF	118.865	119.03	118.41	118.45	41105891.0
2010-11-30 16:00:00	SPY	ETF	118.44	119.193	118.05	118.31	16262120.0
2010-11-30 17:00:00	SPY	ETF	118.3	118.36	118.26	118.35	289025.0
2010-11-30 18:00:00	SPY	ETF	118.34	118.48	118.16	118.18	231193.0
2010-11-30 19:00:00	SPY	ETF	118.2	118.31	118.2	118.25	105203.0
2010-11-30 04:00:00	QQQ	ETF	52.57	52.63	52.54	52.63	900.0
2010-11-30 05:00:00	QQQ	ETF	52.62	52.78	52.6	52.78	18725.0
2010-11-30 06:00:00	QQQ	ETF	52.75	52.75	52.61	52.61	258111.0
2010-11-30 07:00:00	QQQ	ETF	52.61	52.63	52.32	52.32	1386582.0
2010-11-30 08:00:00	QQQ	ETF	52.33	52.5	52.12	52.21	1648340.0
2010-11-30 09:00:00	QQQ	ETF	52.21	52.25	51.88	52.2	12226800.0
2010-11-30 10:00:00	QQQ	ETF	52.2	52.42	52.07	52.2109	12066306.0
2010-11-30 11:00:00	QQQ	ETF	52.21	52.26	52.03	52.14	9012807.0
2010-11-30 12:00:00	QQQ	ETF	52.14	52.175	52.0273	52.11	6804907.0
2010-11-30 13:00:00	QQQ	ETF	52.115	52.36	52.08	52.23	9723327.0
2010-11-30 14:00:00	QQQ	ETF	52.23	52.31	52.04	52.2	10563472.0
2010-11-30 15:00:00	QQQ	ETF	52.2	52.33	52.03	52.06	13228134.0
2010-11-30 16:00:00	QQQ	ETF	52.06	52.28	51.92	52.02	2504399.0
2010-11-30 17:00:00	QQQ	ETF	52.02	52.05	52.0	52.01	69275.0
2010-11-30 18:00:00	QQQ	ETF	52.01	52.03	51.93	51.93	79250.0
2010-11-30 19:00:00	QQQ	ETF	51.96	52.0	51.96	51.99	36957.0
2010-11-30 04:00:00	IWM	ETF	73.01	73.01	73.01	73.01	600.0
2010-11-30 05:00:00	IWM	ETF	73.32	73.32	73.32	73.32	200.0
2010-11-30 06:00:00	IWM	ETF	73.35	73.35	73.17	73.17	2100.0
2010-11-30 07:00:00	IWM	ETF	73.23	73.24	72.72	72.72	354015.0
2010-11-30 08:00:00	IWM	ETF	72.72	73.09	72.39	72.57	1654350.0
2010-11-30 09:00:00	IWM	ETF	72.56	72.65	72.18	72.51	10698271.0
2010-11-30 10:00:00	IWM	ETF	72.54	72.88	72.32	72.61	12595120.0
2010-11-30 11:00:00	IWM	ETF	72.61	72.725	72.38	72.63	5403195.0
2010-11-30 12:00:00	IWM	ETF	72.63	72.87	72.55	72.85	4105678.0
2010-11-30 13:00:00	IWM	ETF	72.83	73.25	72.8001	72.99	5810479.0
2010-11-30 14:00:00	IWM	ETF	72.99	73.11	72.62	72.8	5770969.0
2010-11-30 15:00:00	IWM	ETF	72.8	72.96	72.53	72.77	12693402.0
2010-11-30 16:00:00	IWM	ETF	72.78	72.9	72.5	72.73	2664742.0
2010-11-30 17:00:00	IWM	ETF	72.71	72.73	72.67	72.69	32500.0
2010-11-30 18:00:00	IWM	ETF	72.72	72.72	72.65	72.68	1200.0
2010-11-30 19:00:00	IWM	ETF	72.67	72.69	72.65	72.69	2000.0
2010-11-30 07:00:00	DIA	ETF	110.1	110.1	110.03	110.03	700.0
2010-11-30 08:00:00	DIA	ETF	110.03	110.09	109.58	109.76	464190.0

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

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