PREVIEW / etf_1hour / 2012-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-26.parquet
  size:    188 KB
  rows:    5,761

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
2012-01-26 04:00:00	SPY	ETF	132.4	132.74	132.2	132.74	9862.0
2012-01-26 05:00:00	SPY	ETF	132.71	132.89	132.71	132.72	187300.0
2012-01-26 06:00:00	SPY	ETF	132.72	132.86	132.64	132.85	98050.0
2012-01-26 07:00:00	SPY	ETF	132.8	133.02	132.77	132.85	368019.0
2012-01-26 08:00:00	SPY	ETF	132.9	133.18	132.81	133.17	2220632.0
2012-01-26 09:00:00	SPY	ETF	133.17	133.4	132.29	133.32	18391320.0
2012-01-26 10:00:00	SPY	ETF	133.32	133.325	132.25	132.265	31364137.0
2012-01-26 11:00:00	SPY	ETF	132.27	132.56	132.23	132.31	19864859.0
2012-01-26 12:00:00	SPY	ETF	132.32	132.41	132.06	132.36	15404131.0
2012-01-26 13:00:00	SPY	ETF	132.36	132.45	131.88	132.03	12962089.0
2012-01-26 14:00:00	SPY	ETF	132.03	132.06	131.65	131.74	20288940.0
2012-01-26 15:00:00	SPY	ETF	131.74	132.6242	131.36	131.88	40343083.0
2012-01-26 16:00:00	SPY	ETF	131.88	132.6242	131.75	132.03	12995449.0
2012-01-26 17:00:00	SPY	ETF	132.03	132.6242	132.02	132.02	7317436.0
2012-01-26 18:00:00	SPY	ETF	132.03	132.11	131.91	131.91	108126.0
2012-01-26 19:00:00	SPY	ETF	131.91	131.92	131.71	131.77	229996.0
2012-01-26 04:00:00	QQQ	ETF	60.3	60.3	60.3	60.3	100.0
2012-01-26 05:00:00	QQQ	ETF	60.55	60.57	60.49	60.49	3550.0
2012-01-26 06:00:00	QQQ	ETF	60.52	60.52	60.44	60.44	3800.0
2012-01-26 07:00:00	QQQ	ETF	60.52	60.56	60.49	60.54	30934.0
2012-01-26 08:00:00	QQQ	ETF	60.53	60.69	60.5	60.68	659415.0
2012-01-26 09:00:00	QQQ	ETF	60.69	60.8	60.5	60.76	3831741.0
2012-01-26 10:00:00	QQQ	ETF	60.76	60.788	60.28	60.28	7376740.0
2012-01-26 11:00:00	QQQ	ETF	60.29	60.47	60.2607	60.329	4621282.0
2012-01-26 12:00:00	QQQ	ETF	60.3299	60.4	60.22	60.35	3118697.0
2012-01-26 13:00:00	QQQ	ETF	60.35	60.39	60.16	60.26	3368820.0
2012-01-26 14:00:00	QQQ	ETF	60.25	60.28	60.08	60.0995	3936689.0
2012-01-26 15:00:00	QQQ	ETF	60.09	60.22	59.93	60.21	7851732.0
2012-01-26 16:00:00	QQQ	ETF	60.23	60.29	60.2	60.22	799999.0
2012-01-26 17:00:00	QQQ	ETF	60.21	60.24	60.19	60.23	34197.0
2012-01-26 18:00:00	QQQ	ETF	60.22	60.26	60.19	60.19	28389.0
2012-01-26 19:00:00	QQQ	ETF	60.19	60.19	60.13	60.15	19120.0
2012-01-26 07:00:00	IWM	ETF	79.66	79.73	79.66	79.67	21295.0
2012-01-26 08:00:00	IWM	ETF	79.65	80.0	77.97	79.83	317986.0
2012-01-26 09:00:00	IWM	ETF	79.84	79.91	79.61	79.83	5614541.0
2012-01-26 10:00:00	IWM	ETF	79.82	79.85	78.98	79.02	10785978.0
2012-01-26 11:00:00	IWM	ETF	79.03	79.46	79.01	79.2916	8195721.0
2012-01-26 12:00:00	IWM	ETF	79.3	79.37	79.05	79.335	4088743.0
2012-01-26 13:00:00	IWM	ETF	79.33	79.41	78.89	79.08	5113544.0
2012-01-26 14:00:00	IWM	ETF	79.08	79.2	78.92	79.06	4127757.0
2012-01-26 15:00:00	IWM	ETF	79.06	79.2	78.75	79.2	9997171.0
2012-01-26 16:00:00	IWM	ETF	79.2	79.3869	79.156	79.26	2484572.0
2012-01-26 17:00:00	IWM	ETF	79.29	79.41	79.28	79.41	153909.0
2012-01-26 18:00:00	IWM	ETF	79.41	79.41	79.2	79.36	5389.0
2012-01-26 19:00:00	IWM	ETF	79.25	79.25	79.17	79.17	2700.0
2012-01-26 05:00:00	DIA	ETF	127.42	127.42	127.42	127.42	100.0
2012-01-26 06:00:00	DIA	ETF	127.39	127.39	127.39	127.39	300.0
2012-01-26 07:00:00	DIA	ETF	127.4	127.64	127.4	127.62	28300.0
2012-01-26 08:00:00	DIA	ETF	127.6	127.85	127.6	127.84	11784.0
2012-01-26 09:00:00	DIA	ETF	127.81	128.13	127.62	128.04	608311.0

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

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