PREVIEW / etf_1hour / 2011-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-17.parquet
  size:    185 KB
  rows:    5,648

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-17 04:00:00	SPY	ETF	127.35	127.71	127.2	127.69	51073.0
2011-03-17 05:00:00	SPY	ETF	127.69	127.9	127.43	127.43	70054.0
2011-03-17 06:00:00	SPY	ETF	127.5	127.56	126.77	127.32	399196.0
2011-03-17 07:00:00	SPY	ETF	127.28	127.62	127.0	127.48	1004874.0
2011-03-17 08:00:00	SPY	ETF	127.5	128.31	126.6786	128.1	12587459.0
2011-03-17 09:00:00	SPY	ETF	128.1	128.3	127.47	127.58	27736089.0
2011-03-17 10:00:00	SPY	ETF	127.59	128.39	127.5	128.12	37850004.0
2011-03-17 11:00:00	SPY	ETF	128.11	128.38	127.66	127.72	26266804.0
2011-03-17 12:00:00	SPY	ETF	127.71	128.18	127.645	127.87	16831491.0
2011-03-17 13:00:00	SPY	ETF	127.87	128.14	127.1	127.34	27439694.0
2011-03-17 14:00:00	SPY	ETF	127.35	127.86	127.125	127.7	25000452.0
2011-03-17 15:00:00	SPY	ETF	127.7	128.2	127.5	127.8	44026078.0
2011-03-17 16:00:00	SPY	ETF	127.8	128.34	126.1565	127.75	32701992.0
2011-03-17 17:00:00	SPY	ETF	127.74	127.87	127.71	127.84	687872.0
2011-03-17 18:00:00	SPY	ETF	127.84	127.99	127.32	127.43	330903.0
2011-03-17 19:00:00	SPY	ETF	127.42	127.68	127.15	127.68	228467.0
2011-03-17 04:00:00	QQQ	ETF	54.5	54.79	54.5	54.79	22515.0
2011-03-17 05:00:00	QQQ	ETF	54.78	54.91	54.65	54.67	12187.0
2011-03-17 06:00:00	QQQ	ETF	54.68	54.68	54.45	54.63	129092.0
2011-03-17 07:00:00	QQQ	ETF	54.6	54.76	54.52	54.73	130823.0
2011-03-17 08:00:00	QQQ	ETF	54.75	55.07	54.69	55.01	2183183.0
2011-03-17 09:00:00	QQQ	ETF	55.01	55.1	54.77	54.8375	12496499.0
2011-03-17 10:00:00	QQQ	ETF	54.88	55.18	54.81	55.13	17238688.0
2011-03-17 11:00:00	QQQ	ETF	55.13	55.24	55.02	55.0269	13283880.0
2011-03-17 12:00:00	QQQ	ETF	55.02	55.14	54.99	55.01	4907871.0
2011-03-17 13:00:00	QQQ	ETF	55.0	55.12	54.66	54.76	9565398.0
2011-03-17 14:00:00	QQQ	ETF	54.75	54.91	54.1294	54.84	8251611.0
2011-03-17 15:00:00	QQQ	ETF	54.845	54.9	54.61	54.65	11608408.0
2011-03-17 16:00:00	QQQ	ETF	54.64	54.8536	54.6	54.65	4596423.0
2011-03-17 17:00:00	QQQ	ETF	54.69	54.72	54.65	54.68	12768.0
2011-03-17 18:00:00	QQQ	ETF	54.69	54.77	54.59	54.59	45610.0
2011-03-17 19:00:00	QQQ	ETF	54.61	54.7	54.48	54.69	140013.0
2011-03-17 04:00:00	IWM	ETF	78.66	79.22	78.66	79.22	37383.0
2011-03-17 05:00:00	IWM	ETF	79.31	79.31	78.96	78.96	6300.0
2011-03-17 06:00:00	IWM	ETF	78.99	78.99	78.51	78.79	9250.0
2011-03-17 07:00:00	IWM	ETF	78.89	79.01	78.79	78.95	126377.0
2011-03-17 08:00:00	IWM	ETF	78.95	79.45	78.86	79.36	1998012.0
2011-03-17 09:00:00	IWM	ETF	79.36	79.52	78.76	78.96	8346069.0
2011-03-17 10:00:00	IWM	ETF	79.03	79.33	78.93	79.03	9498433.0
2011-03-17 11:00:00	IWM	ETF	79.03	79.22	78.86	78.91	5545180.0
2011-03-17 12:00:00	IWM	ETF	78.91	79.14	78.91	78.95	2532016.0
2011-03-17 13:00:00	IWM	ETF	78.945	79.1101	78.51	78.66	5804811.0
2011-03-17 14:00:00	IWM	ETF	78.65	78.82	78.48	78.71	5079099.0
2011-03-17 15:00:00	IWM	ETF	78.72	78.84	78.44	78.45	14007542.0
2011-03-17 16:00:00	IWM	ETF	78.46	78.68	78.32	78.37	5381129.0
2011-03-17 17:00:00	IWM	ETF	78.41	78.47	78.32	78.45	41260.0
2011-03-17 18:00:00	IWM	ETF	78.46	78.46	78.34	78.34	15630.0
2011-03-17 19:00:00	IWM	ETF	78.38	78.48	78.24	78.42	27059.0
2011-03-17 04:00:00	DIA	ETF	116.7	117.23	116.7	117.23	45539.0
2011-03-17 05:00:00	DIA	ETF	117.25	117.35	117.04	117.04	9014.0

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

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