PREVIEW / etf_1hour / 2011-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-24.parquet
  size:    173 KB
  rows:    5,315

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-01-24 04:00:00	SPY	ETF	128.65	128.89	128.2	128.7	8050.0
2011-01-24 05:00:00	SPY	ETF	128.43	128.43	128.4	128.4	200.0
2011-01-24 06:00:00	SPY	ETF	128.37	128.4	128.24	128.24	167100.0
2011-01-24 07:00:00	SPY	ETF	128.25	128.5	128.23	128.5	190901.0
2011-01-24 08:00:00	SPY	ETF	128.49	128.57	128.25	128.48	787303.0
2011-01-24 09:00:00	SPY	ETF	128.48	128.65	128.26	128.3438	14020470.0
2011-01-24 10:00:00	SPY	ETF	128.35	128.7894	128.27	128.7435	14257927.0
2011-01-24 11:00:00	SPY	ETF	128.75	129.04	128.67	128.95	14754416.0
2011-01-24 12:00:00	SPY	ETF	128.945	129.16	128.94	128.9601	10123734.0
2011-01-24 13:00:00	SPY	ETF	128.96	129.18	128.93	129.07	9011194.0
2011-01-24 14:00:00	SPY	ETF	129.07	129.25	128.93	128.97	11654018.0
2011-01-24 15:00:00	SPY	ETF	128.96	129.14	128.76	129.13	22291745.0
2011-01-24 16:00:00	SPY	ETF	129.12	129.35	128.73	129.16	9598764.0
2011-01-24 17:00:00	SPY	ETF	129.16	129.21	129.1	129.16	103193.0
2011-01-24 18:00:00	SPY	ETF	129.16	129.21	129.14	129.14	23635.0
2011-01-24 19:00:00	SPY	ETF	129.16	129.27	129.16	129.23	54022.0
2011-01-24 04:00:00	QQQ	ETF	55.75	55.75	55.72	55.72	200.0
2011-01-24 06:00:00	QQQ	ETF	55.7	55.7	55.67	55.67	27000.0
2011-01-24 07:00:00	QQQ	ETF	55.67	55.78	55.67	55.76	40826.0
2011-01-24 08:00:00	QQQ	ETF	55.77	55.8	55.68	55.74	169536.0
2011-01-24 09:00:00	QQQ	ETF	55.74	55.99	55.67	55.73	7727986.0
2011-01-24 10:00:00	QQQ	ETF	55.74	55.99	55.68	55.96	10604089.0
2011-01-24 11:00:00	QQQ	ETF	55.95	56.26	55.92	56.231	8003322.0
2011-01-24 12:00:00	QQQ	ETF	56.23	56.38	56.23	56.33	5413866.0
2011-01-24 13:00:00	QQQ	ETF	56.32	56.46	56.3	56.355	5499617.0
2011-01-24 14:00:00	QQQ	ETF	56.35	56.46	56.34	56.38	5087720.0
2011-01-24 15:00:00	QQQ	ETF	56.38	56.45	56.29	56.45	8918247.0
2011-01-24 16:00:00	QQQ	ETF	56.45	56.5	56.33	56.39	3622665.0
2011-01-24 17:00:00	QQQ	ETF	56.39	56.4	56.32	56.32	38313.0
2011-01-24 18:00:00	QQQ	ETF	56.35	56.4	56.35	56.4	26802.0
2011-01-24 19:00:00	QQQ	ETF	56.4	56.42	56.36	56.36	13643.0
2011-01-24 05:00:00	IWM	ETF	77.18	77.18	77.18	77.18	200.0
2011-01-24 06:00:00	IWM	ETF	77.12	77.12	77.1	77.1	400.0
2011-01-24 07:00:00	IWM	ETF	77.05	77.2	77.04	77.2	6872.0
2011-01-24 08:00:00	IWM	ETF	77.18	77.29	77.07	77.21	111406.0
2011-01-24 09:00:00	IWM	ETF	77.2	77.54	77.12	77.1401	4976752.0
2011-01-24 10:00:00	IWM	ETF	77.145	77.5	77.09	77.45	5493949.0
2011-01-24 11:00:00	IWM	ETF	77.45	77.888	77.395	77.75	8641906.0
2011-01-24 12:00:00	IWM	ETF	77.751	77.93	77.66	77.67	4103316.0
2011-01-24 13:00:00	IWM	ETF	77.67	78.0	77.65	77.8	6556024.0
2011-01-24 14:00:00	IWM	ETF	77.8025	78.07	77.78	78.01	4328456.0
2011-01-24 15:00:00	IWM	ETF	78.01	78.05	77.66	77.76	9301996.0
2011-01-24 16:00:00	IWM	ETF	77.76	77.8216	77.66	77.69	2042136.0
2011-01-24 17:00:00	IWM	ETF	77.69	77.7441	77.68	77.73	6873.0
2011-01-24 18:00:00	IWM	ETF	77.82	77.82	77.77	77.82	5500.0
2011-01-24 07:00:00	DIA	ETF	118.5	118.6	118.47	118.6	13400.0
2011-01-24 08:00:00	DIA	ETF	118.61	118.61	118.44	118.44	154066.0
2011-01-24 09:00:00	DIA	ETF	118.5	118.86	118.34	118.71	749254.0
2011-01-24 10:00:00	DIA	ETF	118.71	119.06	118.66	119.03	1064793.0
2011-01-24 11:00:00	DIA	ETF	119.03	119.3	118.98	119.25	2487891.0

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

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