PREVIEW / etf_1hour / 2010-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-27.parquet
  size:    169 KB
  rows:    5,090

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-04-27 04:00:00	SPY	ETF	121.2	121.3	121.2	121.25	2464.0
2010-04-27 05:00:00	SPY	ETF	121.27	121.3	121.02	121.02	16800.0
2010-04-27 06:00:00	SPY	ETF	121.01	121.01	120.7	120.75	124350.0
2010-04-27 07:00:00	SPY	ETF	120.79	120.96	120.76	120.78	665850.0
2010-04-27 08:00:00	SPY	ETF	120.8	120.91	120.71	120.79	1600614.0
2010-04-27 09:00:00	SPY	ETF	120.78	120.99	120.57	120.86	29311952.0
2010-04-27 10:00:00	SPY	ETF	120.87	121.27	120.74	121.08	37667320.0
2010-04-27 11:00:00	SPY	ETF	121.09	121.13	119.19	119.26	83657113.0
2010-04-27 12:00:00	SPY	ETF	119.27	119.5	118.84	119.429	36474884.0
2010-04-27 13:00:00	SPY	ETF	119.42	119.97	119.4	119.78	30395704.0
2010-04-27 14:00:00	SPY	ETF	119.78	119.805	119.06	119.17	34462903.0
2010-04-27 15:00:00	SPY	ETF	119.17	119.57	118.25	118.49	75070607.0
2010-04-27 16:00:00	SPY	ETF	118.47	121.3346	118.42	118.61	22239568.0
2010-04-27 17:00:00	SPY	ETF	118.61	118.64	118.45	118.45	865172.0
2010-04-27 18:00:00	SPY	ETF	118.49	118.6	118.48	118.6	201335.0
2010-04-27 19:00:00	SPY	ETF	118.6	118.75	118.55	118.72	133962.0
2010-04-27 05:00:00	QQQ	ETF	50.37	50.37	50.32	50.32	6055.0
2010-04-27 06:00:00	QQQ	ETF	50.27	50.27	50.2	50.2	3583.0
2010-04-27 07:00:00	QQQ	ETF	50.24	50.32	50.24	50.26	66624.0
2010-04-27 08:00:00	QQQ	ETF	50.26	50.3	50.23	50.25	268349.0
2010-04-27 09:00:00	QQQ	ETF	50.25	50.32	50.12	50.26	10244765.0
2010-04-27 10:00:00	QQQ	ETF	50.25	50.43	50.18	50.31	14943837.0
2010-04-27 11:00:00	QQQ	ETF	50.31	50.33	49.49	49.56	26831147.0
2010-04-27 12:00:00	QQQ	ETF	49.56	49.64	49.38	49.54	13864868.0
2010-04-27 13:00:00	QQQ	ETF	49.55	49.85	49.55	49.76	7139790.0
2010-04-27 14:00:00	QQQ	ETF	49.76	49.77	49.49	49.51	8655705.0
2010-04-27 15:00:00	QQQ	ETF	49.52	49.68	49.21	49.37	22540728.0
2010-04-27 16:00:00	QQQ	ETF	49.36	49.6486	49.2865	49.48	4509025.0
2010-04-27 17:00:00	QQQ	ETF	49.45	49.48	49.37	49.41	40877.0
2010-04-27 18:00:00	QQQ	ETF	49.41	49.43	49.41	49.42	27087.0
2010-04-27 19:00:00	QQQ	ETF	49.44	49.5	49.42	49.5	52697.0
2010-04-27 06:00:00	IWM	ETF	73.6	73.6	73.49	73.51	9212.0
2010-04-27 07:00:00	IWM	ETF	73.47	73.65	73.47	73.5	149070.0
2010-04-27 08:00:00	IWM	ETF	73.5	73.59	73.44	73.49	365073.0
2010-04-27 09:00:00	IWM	ETF	73.48	73.99	73.38	73.96	10641793.0
2010-04-27 10:00:00	IWM	ETF	73.97	74.24	73.785	74.08	11371468.0
2010-04-27 11:00:00	IWM	ETF	74.07	74.15	72.67	72.8101	20902551.0
2010-04-27 12:00:00	IWM	ETF	72.81	73.0	72.5	72.76	13108078.0
2010-04-27 13:00:00	IWM	ETF	72.76	73.3	72.76	73.15	7414697.0
2010-04-27 14:00:00	IWM	ETF	73.15	73.1601	72.44	72.49	11335336.0
2010-04-27 15:00:00	IWM	ETF	72.49	73.8846	72.02	72.14	20351749.0
2010-04-27 16:00:00	IWM	ETF	72.14	72.7194	72.1065	72.26	2543035.0
2010-04-27 17:00:00	IWM	ETF	72.23	72.28	72.13	72.15	21400.0
2010-04-27 18:00:00	IWM	ETF	72.2	72.26	72.06	72.16	1685.0
2010-04-27 19:00:00	IWM	ETF	72.16	72.29	72.15	72.25	8401.0
2010-04-27 06:00:00	DIA	ETF	111.78	111.78	111.73	111.73	6100.0
2010-04-27 07:00:00	DIA	ETF	111.8	111.87	111.75	111.81	10500.0
2010-04-27 08:00:00	DIA	ETF	111.85	111.98	111.85	111.92	51900.0
2010-04-27 09:00:00	DIA	ETF	111.89	112.05	111.7	112.02	1021778.0
2010-04-27 10:00:00	DIA	ETF	111.99	112.18	111.8	111.93	2552892.0

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

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