PREVIEW / etf_1hour / 2011-04-25

all etf 1-hour files

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

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-04-25 04:00:00	SPY	ETF	133.85	133.95	133.85	133.91	2835.0
2011-04-25 05:00:00	SPY	ETF	133.92	133.92	133.91	133.91	500.0
2011-04-25 06:00:00	SPY	ETF	133.92	133.94	133.9	133.94	23100.0
2011-04-25 07:00:00	SPY	ETF	133.95	133.96	133.88	133.91	134516.0
2011-04-25 08:00:00	SPY	ETF	133.93	133.93	133.61	133.67	538799.0
2011-04-25 09:00:00	SPY	ETF	133.68	133.86	133.49	133.76	9072530.0
2011-04-25 10:00:00	SPY	ETF	133.76	133.83	133.23	133.32	15028099.0
2011-04-25 11:00:00	SPY	ETF	133.32	133.54	133.2	133.505	7897467.0
2011-04-25 12:00:00	SPY	ETF	133.5	133.61	133.48	133.55	4572299.0
2011-04-25 13:00:00	SPY	ETF	133.54	133.64	133.5	133.62	2889985.0
2011-04-25 14:00:00	SPY	ETF	133.62	133.72	133.58	133.65	4995539.0
2011-04-25 15:00:00	SPY	ETF	133.66	133.8066	133.49	133.61	12287356.0
2011-04-25 16:00:00	SPY	ETF	133.63	133.71	133.46	133.67	5805155.0
2011-04-25 17:00:00	SPY	ETF	133.65	133.73	133.62	133.65	114699.0
2011-04-25 18:00:00	SPY	ETF	133.67	133.78	133.62	133.75	297956.0
2011-04-25 19:00:00	SPY	ETF	133.76	133.78	133.7	133.74	114976.0
2011-04-25 04:00:00	QQQ	ETF	58.48	58.52	58.48	58.52	1129.0
2011-04-25 06:00:00	QQQ	ETF	58.5	58.51	58.5	58.51	800.0
2011-04-25 07:00:00	QQQ	ETF	58.54	58.55	58.52	58.52	46913.0
2011-04-25 08:00:00	QQQ	ETF	58.5	58.51	58.39	58.42	220798.0
2011-04-25 09:00:00	QQQ	ETF	58.42	58.52	58.33	58.481	2950107.0
2011-04-25 10:00:00	QQQ	ETF	58.49	58.51	58.29	58.34	6137919.0
2011-04-25 11:00:00	QQQ	ETF	58.34	58.41	58.28	58.405	1713279.0
2011-04-25 12:00:00	QQQ	ETF	58.4038	58.44	58.36	58.392	1114062.0
2011-04-25 13:00:00	QQQ	ETF	58.4	58.45	58.37	58.43	687638.0
2011-04-25 14:00:00	QQQ	ETF	58.435	58.52	58.43	58.51	3198489.0
2011-04-25 15:00:00	QQQ	ETF	58.505	58.52	58.44	58.49	3992773.0
2011-04-25 16:00:00	QQQ	ETF	58.49	58.5072	58.38	58.46	1734883.0
2011-04-25 17:00:00	QQQ	ETF	58.45	58.52	58.45	58.52	40831.0
2011-04-25 18:00:00	QQQ	ETF	58.51	58.51	58.3352	58.5	2072120.0
2011-04-25 19:00:00	QQQ	ETF	58.5	58.51	58.48	58.48	50336.0
2011-04-25 05:00:00	IWM	ETF	84.53	84.53	84.53	84.53	854.0
2011-04-25 07:00:00	IWM	ETF	84.52	84.52	84.47	84.48	13300.0
2011-04-25 08:00:00	IWM	ETF	84.46	84.49	84.29	84.31	121462.0
2011-04-25 09:00:00	IWM	ETF	84.31	84.51	84.19	84.48	3035713.0
2011-04-25 10:00:00	IWM	ETF	84.49	84.53	83.98	84.0	5087893.0
2011-04-25 11:00:00	IWM	ETF	84.0	84.1501	83.77	84.11	3585808.0
2011-04-25 12:00:00	IWM	ETF	84.11	84.18	84.0326	84.11	846825.0
2011-04-25 13:00:00	IWM	ETF	84.11	84.24	84.08	84.24	855752.0
2011-04-25 14:00:00	IWM	ETF	84.24	84.31	84.17	84.21	1117046.0
2011-04-25 15:00:00	IWM	ETF	84.22	84.36	84.1	84.35	4791603.0
2011-04-25 16:00:00	IWM	ETF	84.35	84.4645	84.16	84.24	2919594.0
2011-04-25 17:00:00	IWM	ETF	84.27	84.3	84.27	84.3	5043.0
2011-04-25 18:00:00	IWM	ETF	84.3	84.3	84.3	84.3	1100.0
2011-04-25 19:00:00	IWM	ETF	84.3	84.3	84.28	84.28	6500.0
2011-04-25 07:00:00	DIA	ETF	125.08	125.08	124.92	124.95	3050.0
2011-04-25 08:00:00	DIA	ETF	124.88	124.9	124.71	124.71	8730.0
2011-04-25 09:00:00	DIA	ETF	124.77	124.8	124.48	124.63	391865.0
2011-04-25 10:00:00	DIA	ETF	124.65	124.69	124.23	124.3126	1111188.0
2011-04-25 11:00:00	DIA	ETF	124.32	124.42	124.21	124.4	331015.0

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

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