PREVIEW / etf_1hour / 2011-01-19

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-19.parquet
  size:    180 KB
  rows:    5,466

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-01-19 04:00:00	SPY	ETF	129.65	129.74	129.59	129.68	4844.0
2011-01-19 05:00:00	SPY	ETF	129.66	129.75	129.57	129.75	1000.0
2011-01-19 06:00:00	SPY	ETF	129.69	129.72	129.59	129.7	22200.0
2011-01-19 07:00:00	SPY	ETF	129.7	129.92	129.69	129.9	230869.0
2011-01-19 08:00:00	SPY	ETF	129.89	129.89	129.35	129.42	2648849.0
2011-01-19 09:00:00	SPY	ETF	129.42	129.5	128.99	129.08	18726119.0
2011-01-19 10:00:00	SPY	ETF	129.08	129.21	128.56	128.74	23131460.0
2011-01-19 11:00:00	SPY	ETF	128.75	128.78	128.54	128.695	12254362.0
2011-01-19 12:00:00	SPY	ETF	128.69	128.75	128.29	128.41	14464822.0
2011-01-19 13:00:00	SPY	ETF	128.42	128.7	128.29	128.555	12849454.0
2011-01-19 14:00:00	SPY	ETF	128.56	128.57	127.96	128.14	18848296.0
2011-01-19 15:00:00	SPY	ETF	128.14	128.26	127.91	128.26	34452682.0
2011-01-19 16:00:00	SPY	ETF	128.26	129.5357	128.2	128.22	10261140.0
2011-01-19 17:00:00	SPY	ETF	128.21	128.26	128.18	128.2	733864.0
2011-01-19 18:00:00	SPY	ETF	128.21	128.27	128.16	128.19	206832.0
2011-01-19 19:00:00	SPY	ETF	128.2	128.4	128.11	128.4	138642.0
2011-01-19 04:00:00	QQQ	ETF	57.26	57.27	57.26	57.27	700.0
2011-01-19 05:00:00	QQQ	ETF	57.24	57.24	57.21	57.22	400.0
2011-01-19 06:00:00	QQQ	ETF	57.22	57.22	57.2	57.2	15000.0
2011-01-19 07:00:00	QQQ	ETF	57.21	57.35	57.21	57.33	175868.0
2011-01-19 08:00:00	QQQ	ETF	57.32	57.34	57.15	57.23	1006866.0
2011-01-19 09:00:00	QQQ	ETF	57.24	57.32	56.97	57.0	11660750.0
2011-01-19 10:00:00	QQQ	ETF	56.99	57.11	56.76	56.86	9506409.0
2011-01-19 11:00:00	QQQ	ETF	56.865	56.9	56.72	56.79	7357327.0
2011-01-19 12:00:00	QQQ	ETF	56.791	56.825	56.61	56.69	4446031.0
2011-01-19 13:00:00	QQQ	ETF	56.69	56.79	56.61	56.69	3131607.0
2011-01-19 14:00:00	QQQ	ETF	56.6875	56.71	56.35	56.44	8635684.0
2011-01-19 15:00:00	QQQ	ETF	56.45	56.53	56.32	56.52	12093721.0
2011-01-19 16:00:00	QQQ	ETF	56.53	56.57	56.27	56.34	6325479.0
2011-01-19 17:00:00	QQQ	ETF	56.34	56.34	56.28	56.31	335362.0
2011-01-19 18:00:00	QQQ	ETF	56.31	56.35	56.3	56.32	48831.0
2011-01-19 19:00:00	QQQ	ETF	56.32	56.51	56.28	56.45	40679.0
2011-01-19 04:00:00	IWM	ETF	80.71	80.71	80.71	80.71	100.0
2011-01-19 06:00:00	IWM	ETF	80.66	80.66	80.66	80.66	20000.0
2011-01-19 07:00:00	IWM	ETF	80.73	80.86	80.69	80.86	43900.0
2011-01-19 08:00:00	IWM	ETF	80.86	80.9	80.08	80.49	379787.0
2011-01-19 09:00:00	IWM	ETF	80.46	80.7	79.79	79.86	7802033.0
2011-01-19 10:00:00	IWM	ETF	79.87	80.01	79.35	79.54	11167441.0
2011-01-19 11:00:00	IWM	ETF	79.54	79.64	79.33	79.468	5680066.0
2011-01-19 12:00:00	IWM	ETF	79.47	79.51	79.06	79.1999	5379497.0
2011-01-19 13:00:00	IWM	ETF	79.1901	79.27	79.04	79.13	4552668.0
2011-01-19 14:00:00	IWM	ETF	79.13	79.13	78.61	78.74	8994714.0
2011-01-19 15:00:00	IWM	ETF	78.74	78.8001	78.36	78.54	15355122.0
2011-01-19 16:00:00	IWM	ETF	78.54	80.6103	78.43	78.47	2567225.0
2011-01-19 17:00:00	IWM	ETF	78.47	78.48	78.42	78.43	120975.0
2011-01-19 18:00:00	IWM	ETF	78.43	78.47	78.32	78.45	6665.0
2011-01-19 19:00:00	IWM	ETF	78.47	78.56	78.42	78.56	10599.0
2011-01-19 08:00:00	DIA	ETF	118.63	118.63	118.31	118.32	29747.0
2011-01-19 09:00:00	DIA	ETF	118.32	118.47	118.22	118.29	1902199.0
2011-01-19 10:00:00	DIA	ETF	118.27	118.49	118.06	118.24	1058426.0

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

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