PREVIEW / etf_1hour / 2011-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-25.parquet
  size:    177 KB
  rows:    5,397

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-25 04:00:00	SPY	ETF	129.1	129.2	128.7	128.7	6964.0
2011-01-25 05:00:00	SPY	ETF	128.81	128.86	128.7	128.7	37994.0
2011-01-25 06:00:00	SPY	ETF	128.68	128.89	128.68	128.87	38066.0
2011-01-25 07:00:00	SPY	ETF	128.85	128.89	128.68	128.68	716308.0
2011-01-25 08:00:00	SPY	ETF	128.72	128.74	128.58	128.59	1043629.0
2011-01-25 09:00:00	SPY	ETF	128.6	129.16	128.59	129.16	13492599.0
2011-01-25 10:00:00	SPY	ETF	129.16	129.28	128.65	128.97	22779651.0
2011-01-25 11:00:00	SPY	ETF	128.97	128.99	128.22	128.37	27407347.0
2011-01-25 12:00:00	SPY	ETF	128.37	128.87	128.36	128.74	17268925.0
2011-01-25 13:00:00	SPY	ETF	128.7499	128.79	128.51	128.7	11500878.0
2011-01-25 14:00:00	SPY	ETF	128.7	129.1281	128.11	128.36	25062508.0
2011-01-25 15:00:00	SPY	ETF	128.36	129.18	128.34	129.14	36348243.0
2011-01-25 16:00:00	SPY	ETF	129.14	129.2	128.635	129.09	9829536.0
2011-01-25 17:00:00	SPY	ETF	129.08	129.15	129.06	129.11	233999.0
2011-01-25 18:00:00	SPY	ETF	129.12	129.13	129.03	129.06	118867.0
2011-01-25 19:00:00	SPY	ETF	129.03	129.14	129.01	129.14	58676.0
2011-01-25 05:00:00	QQQ	ETF	56.2	56.21	56.15	56.15	4490.0
2011-01-25 06:00:00	QQQ	ETF	56.22	56.23	56.22	56.23	40000.0
2011-01-25 07:00:00	QQQ	ETF	56.24	56.26	56.18	56.2	78200.0
2011-01-25 08:00:00	QQQ	ETF	56.2	56.2	56.04	56.06	627767.0
2011-01-25 09:00:00	QQQ	ETF	56.06	56.4	56.06	56.36	6738695.0
2011-01-25 10:00:00	QQQ	ETF	56.36	56.46	56.18	56.42	8295889.0
2011-01-25 11:00:00	QQQ	ETF	56.4155	56.42	56.11	56.18	6720385.0
2011-01-25 12:00:00	QQQ	ETF	56.18	56.43	56.18	56.375	3832641.0
2011-01-25 13:00:00	QQQ	ETF	56.38	56.39	56.27	56.3399	2700869.0
2011-01-25 14:00:00	QQQ	ETF	56.34	56.34	56.05	56.19	7368305.0
2011-01-25 15:00:00	QQQ	ETF	56.19	56.55	56.18	56.51	10849908.0
2011-01-25 16:00:00	QQQ	ETF	56.51	56.55	56.4463	56.46	1548670.0
2011-01-25 17:00:00	QQQ	ETF	56.46	56.55	56.46	56.54	58497.0
2011-01-25 18:00:00	QQQ	ETF	56.51	56.53	56.46	56.46	39523.0
2011-01-25 19:00:00	QQQ	ETF	56.46	56.52	56.46	56.51	10665.0
2011-01-25 04:00:00	IWM	ETF	77.47	77.47	77.4	77.4	2000.0
2011-01-25 05:00:00	IWM	ETF	77.4	77.4	77.28	77.28	3700.0
2011-01-25 06:00:00	IWM	ETF	77.4	77.46	77.4	77.46	2100.0
2011-01-25 07:00:00	IWM	ETF	77.44	77.46	77.29	77.29	53707.0
2011-01-25 08:00:00	IWM	ETF	77.32	77.35	77.15	77.17	200785.0
2011-01-25 09:00:00	IWM	ETF	77.22	77.44	77.08	77.38	5332636.0
2011-01-25 10:00:00	IWM	ETF	77.36	77.61	77.1	77.5902	7709627.0
2011-01-25 11:00:00	IWM	ETF	77.595	77.63	76.95	77.18	6803983.0
2011-01-25 12:00:00	IWM	ETF	77.17	77.66	77.17	77.55	3992177.0
2011-01-25 13:00:00	IWM	ETF	77.56	77.62	77.36	77.57	3141409.0
2011-01-25 14:00:00	IWM	ETF	77.56	77.56	77.08	77.28	6032385.0
2011-01-25 15:00:00	IWM	ETF	77.28	77.9	77.26	77.88	9107482.0
2011-01-25 16:00:00	IWM	ETF	77.88	77.92	77.4281	77.84	1726819.0
2011-01-25 17:00:00	IWM	ETF	77.84	77.9	77.84	77.9	12879.0
2011-01-25 18:00:00	IWM	ETF	77.88	77.94	77.88	77.88	6300.0
2011-01-25 19:00:00	IWM	ETF	77.9	77.94	77.9	77.94	2000.0
2011-01-25 04:00:00	DIA	ETF	119.48	119.48	119.35	119.35	306.0
2011-01-25 05:00:00	DIA	ETF	119.25	119.25	119.25	119.25	100.0
2011-01-25 07:00:00	DIA	ETF	119.34	119.39	119.22	119.24	28100.0

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

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