PREVIEW / etf_1hour / 2011-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-15.parquet
  size:    195 KB
  rows:    5,960

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-03-15 04:00:00	SPY	ETF	127.75	128.2	127.51	127.75	306929.0
2011-03-15 05:00:00	SPY	ETF	127.65	127.67	126.61	126.87	204569.0
2011-03-15 06:00:00	SPY	ETF	126.87	127.18	125.8	126.76	948812.0
2011-03-15 07:00:00	SPY	ETF	126.85	127.32	126.63	126.87	4568669.0
2011-03-15 08:00:00	SPY	ETF	126.84	127.9	126.4	126.66	10968761.0
2011-03-15 09:00:00	SPY	ETF	126.67	127.47	126.48	126.83	56548352.0
2011-03-15 10:00:00	SPY	ETF	126.84	128.4	126.8	127.8	53049608.0
2011-03-15 11:00:00	SPY	ETF	127.795	127.97	127.46	127.9	26881831.0
2011-03-15 12:00:00	SPY	ETF	127.91	128.52	127.78	128.07	31797211.0
2011-03-15 13:00:00	SPY	ETF	128.07	128.25	127.22	128.24	24448834.0
2011-03-15 14:00:00	SPY	ETF	128.24	128.87	127.88	128.57	37960437.0
2011-03-15 15:00:00	SPY	ETF	128.57	129.33	128.5233	128.63	46053275.0
2011-03-15 16:00:00	SPY	ETF	128.62	130.0975	126.6441	128.43	50951330.0
2011-03-15 17:00:00	SPY	ETF	128.41	130.0974	128.35	128.38	10651022.0
2011-03-15 18:00:00	SPY	ETF	128.39	128.65	127.52	127.92	1384014.0
2011-03-15 19:00:00	SPY	ETF	127.9	128.61	127.9	128.48	478440.0
2011-03-15 04:00:00	QQQ	ETF	55.8	55.8	55.34	55.35	9982.0
2011-03-15 05:00:00	QQQ	ETF	55.3	55.49	54.69	54.74	23582.0
2011-03-15 06:00:00	QQQ	ETF	54.81	54.87	54.7	54.86	39481.0
2011-03-15 07:00:00	QQQ	ETF	54.9	55.13	54.73	54.84	1476078.0
2011-03-15 08:00:00	QQQ	ETF	54.81	54.89	54.58	54.74	2867783.0
2011-03-15 09:00:00	QQQ	ETF	54.75	55.03	54.47	54.68	22164424.0
2011-03-15 10:00:00	QQQ	ETF	54.68	55.26	54.63	55.2	15343743.0
2011-03-15 11:00:00	QQQ	ETF	55.21	55.35	55.05	55.31	9545006.0
2011-03-15 12:00:00	QQQ	ETF	55.32	55.54	55.17	55.33	11018613.0
2011-03-15 13:00:00	QQQ	ETF	55.3285	55.38	55.23	55.37	5290031.0
2011-03-15 14:00:00	QQQ	ETF	55.37	55.66	55.29	55.529	8976247.0
2011-03-15 15:00:00	QQQ	ETF	55.52	55.82	55.51	55.51	11288026.0
2011-03-15 16:00:00	QQQ	ETF	55.5	55.525	55.19	55.28	4313270.0
2011-03-15 17:00:00	QQQ	ETF	55.28	55.29	55.24	55.28	108224.0
2011-03-15 18:00:00	QQQ	ETF	55.28	55.52	54.96	55.08	268692.0
2011-03-15 19:00:00	QQQ	ETF	55.1	55.36	55.1	55.33	110591.0
2011-03-15 04:00:00	IWM	ETF	78.59	78.63	78.41	78.55	5005.0
2011-03-15 05:00:00	IWM	ETF	78.17	78.17	77.33	77.66	24454.0
2011-03-15 06:00:00	IWM	ETF	77.75	77.84	77.57	77.7	32890.0
2011-03-15 07:00:00	IWM	ETF	77.72	77.99	77.48	77.73	429423.0
2011-03-15 08:00:00	IWM	ETF	77.7	78.375	77.45	77.77	1327765.0
2011-03-15 09:00:00	IWM	ETF	77.77	78.44	77.5699	77.87	15325268.0
2011-03-15 10:00:00	IWM	ETF	77.875	78.7	77.86	78.65	13226026.0
2011-03-15 11:00:00	IWM	ETF	78.66	78.82	78.38	78.78	5998279.0
2011-03-15 12:00:00	IWM	ETF	78.78	79.06	78.6	78.808	6512548.0
2011-03-15 13:00:00	IWM	ETF	78.78	78.84	78.59	78.77	4518120.0
2011-03-15 14:00:00	IWM	ETF	78.77	79.23	78.62	79.07	8978926.0
2011-03-15 15:00:00	IWM	ETF	79.07	79.67	78.75	79.06	14535886.0
2011-03-15 16:00:00	IWM	ETF	79.06	79.7979	78.72	79.01	4368551.0
2011-03-15 17:00:00	IWM	ETF	79.01	79.32	78.92	78.94	114350.0
2011-03-15 18:00:00	IWM	ETF	78.94	78.95	78.55	78.65	87619.0
2011-03-15 19:00:00	IWM	ETF	78.66	79.06	78.66	79.06	27810.0
2011-03-15 04:00:00	DIA	ETF	119.17	119.17	117.95	117.95	15700.0
2011-03-15 05:00:00	DIA	ETF	117.93	117.93	117.01	117.28	58900.0

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

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