PREVIEW / etf_1hour / 2011-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-15.parquet
  size:    176 KB
  rows:    5,382

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-15 04:00:00	SPY	ETF	131.15	131.22	131.1	131.2	7883.0
2011-04-15 05:00:00	SPY	ETF	131.18	131.26	131.05	131.26	24200.0
2011-04-15 06:00:00	SPY	ETF	131.28	131.33	131.25	131.3	22905.0
2011-04-15 07:00:00	SPY	ETF	131.28	131.36	131.18	131.23	279589.0
2011-04-15 08:00:00	SPY	ETF	131.23	131.52	131.07	131.44	1964536.0
2011-04-15 09:00:00	SPY	ETF	131.44	131.93	131.41	131.77	22485277.0
2011-04-15 10:00:00	SPY	ETF	131.77	132.08	131.51	131.82	25507086.0
2011-04-15 11:00:00	SPY	ETF	131.83	132.06	131.66	131.965	13075309.0
2011-04-15 12:00:00	SPY	ETF	131.97	132.32	131.97	132.319	15210115.0
2011-04-15 13:00:00	SPY	ETF	132.32	132.37	132.09	132.11	9686040.0
2011-04-15 14:00:00	SPY	ETF	132.11	132.26	131.5134	132.19	12144938.0
2011-04-15 15:00:00	SPY	ETF	132.19	132.22	131.87	132.05	35392997.0
2011-04-15 16:00:00	SPY	ETF	132.05	132.37	131.5134	131.99	23637573.0
2011-04-15 17:00:00	SPY	ETF	132.0	132.0639	131.5134	132.0	6430514.0
2011-04-15 18:00:00	SPY	ETF	132.12	132.15	132.03	132.15	198586.0
2011-04-15 19:00:00	SPY	ETF	132.16	132.2	132.1	132.17	54609.0
2011-04-15 05:00:00	QQQ	ETF	56.42	56.45	56.42	56.45	6839.0
2011-04-15 06:00:00	QQQ	ETF	56.52	56.53	56.52	56.53	300.0
2011-04-15 07:00:00	QQQ	ETF	56.5	56.54	56.47	56.49	67207.0
2011-04-15 08:00:00	QQQ	ETF	56.49	56.52	56.38	56.5	410900.0
2011-04-15 09:00:00	QQQ	ETF	56.5	56.65	56.28	56.43	10066124.0
2011-04-15 10:00:00	QQQ	ETF	56.43	56.63	56.425	56.59	12253980.0
2011-04-15 11:00:00	QQQ	ETF	56.59	56.741	56.56	56.65	3802289.0
2011-04-15 12:00:00	QQQ	ETF	56.65	56.85	56.65	56.83	7378092.0
2011-04-15 13:00:00	QQQ	ETF	56.83	56.87	56.68	56.69	6484251.0
2011-04-15 14:00:00	QQQ	ETF	56.69	56.75	56.67	56.72	2493363.0
2011-04-15 15:00:00	QQQ	ETF	56.7199	56.72	56.53	56.63	8060641.0
2011-04-15 16:00:00	QQQ	ETF	56.64	56.82	56.5922	56.74	2713699.0
2011-04-15 17:00:00	QQQ	ETF	56.74	56.79	56.7	56.76	268862.0
2011-04-15 18:00:00	QQQ	ETF	56.77	56.78	56.72	56.78	4996.0
2011-04-15 19:00:00	QQQ	ETF	56.78	56.83	56.78	56.83	10267.0
2011-04-15 04:00:00	IWM	ETF	82.44	82.44	82.35	82.39	14311.0
2011-04-15 05:00:00	IWM	ETF	82.3	82.45	82.3	82.45	3500.0
2011-04-15 06:00:00	IWM	ETF	82.45	82.51	82.45	82.51	5800.0
2011-04-15 07:00:00	IWM	ETF	82.47	82.51	82.43	82.43	49511.0
2011-04-15 08:00:00	IWM	ETF	82.42	82.93	82.31	82.57	293494.0
2011-04-15 09:00:00	IWM	ETF	82.57	82.78	82.26	82.56	6032952.0
2011-04-15 10:00:00	IWM	ETF	82.56	82.86	82.31	82.76	6691496.0
2011-04-15 11:00:00	IWM	ETF	82.76	83.21	82.65	83.07	4227653.0
2011-04-15 12:00:00	IWM	ETF	83.07	83.34	83.05	83.32	3755595.0
2011-04-15 13:00:00	IWM	ETF	83.32	83.36	83.11	83.16	2621376.0
2011-04-15 14:00:00	IWM	ETF	83.155	83.38	83.15	83.37	4476770.0
2011-04-15 15:00:00	IWM	ETF	83.37	83.48	83.15	83.48	10059389.0
2011-04-15 16:00:00	IWM	ETF	83.48	83.53	82.6459	83.42	5427544.0
2011-04-15 17:00:00	IWM	ETF	83.42	83.48	83.41	83.48	24555.0
2011-04-15 18:00:00	IWM	ETF	83.49	83.5	83.49	83.5	500.0
2011-04-15 19:00:00	IWM	ETF	83.54	83.54	83.49	83.52	2010.0
2011-04-15 06:00:00	DIA	ETF	122.34	122.34	122.34	122.34	600.0
2011-04-15 07:00:00	DIA	ETF	122.39	122.39	122.3	122.32	2200.0
2011-04-15 08:00:00	DIA	ETF	122.34	122.54	122.2	122.45	12090.0

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

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