PREVIEW / etf_1hour / 2012-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-13.parquet
  size:    183 KB
  rows:    5,666

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-13 04:00:00	SPY	ETF	129.7	129.7	129.52	129.68	1400.0
2012-01-13 05:00:00	SPY	ETF	129.65	129.74	129.44	129.52	21770.0
2012-01-13 06:00:00	SPY	ETF	129.58	129.58	129.42	129.44	73369.0
2012-01-13 07:00:00	SPY	ETF	129.49	129.5	129.11	129.15	640972.0
2012-01-13 08:00:00	SPY	ETF	129.22	129.45	128.52	128.76	2840324.0
2012-01-13 09:00:00	SPY	ETF	128.75	128.8	128.24	128.52	28588145.0
2012-01-13 10:00:00	SPY	ETF	128.51	128.57	127.72	128.3	48445218.0
2012-01-13 11:00:00	SPY	ETF	128.3	128.72	128.26	128.52	19963690.0
2012-01-13 12:00:00	SPY	ETF	128.53	128.53	128.17	128.39	16400671.0
2012-01-13 13:00:00	SPY	ETF	128.4	128.53	128.04	128.435	12332241.0
2012-01-13 14:00:00	SPY	ETF	128.4372	128.63	128.33	128.61	14631376.0
2012-01-13 15:00:00	SPY	ETF	128.62	128.96	128.59	128.95	26735776.0
2012-01-13 16:00:00	SPY	ETF	128.96	129.45	128.3947	129.13	7847802.0
2012-01-13 17:00:00	SPY	ETF	129.12	129.22	129.09	129.18	324902.0
2012-01-13 18:00:00	SPY	ETF	129.16	129.22	129.01	129.17	81859.0
2012-01-13 19:00:00	SPY	ETF	129.18	129.24	129.15	129.24	141234.0
2012-01-13 06:00:00	QQQ	ETF	58.46	58.46	58.41	58.41	6100.0
2012-01-13 07:00:00	QQQ	ETF	58.4	58.45	58.33	58.33	14270.0
2012-01-13 08:00:00	QQQ	ETF	58.37	58.4	58.2	58.2	423202.0
2012-01-13 09:00:00	QQQ	ETF	58.2	58.22	57.9	58.109	6558743.0
2012-01-13 10:00:00	QQQ	ETF	58.1	58.1015	57.68	57.916	8974512.0
2012-01-13 11:00:00	QQQ	ETF	57.91	58.115	57.88	58.04	4061613.0
2012-01-13 12:00:00	QQQ	ETF	58.03	58.04	57.91	58.0	3111300.0
2012-01-13 13:00:00	QQQ	ETF	57.99	58.03	57.86	57.98	2465135.0
2012-01-13 14:00:00	QQQ	ETF	57.98	58.1	57.94	58.044	2853259.0
2012-01-13 15:00:00	QQQ	ETF	58.05	58.19	58.04	58.18	5810575.0
2012-01-13 16:00:00	QQQ	ETF	58.19	58.34	58.1499	58.29	790816.0
2012-01-13 17:00:00	QQQ	ETF	58.27	58.3	58.21	58.23	30030.0
2012-01-13 18:00:00	QQQ	ETF	58.25	58.29	58.21	58.25	8107.0
2012-01-13 19:00:00	QQQ	ETF	58.25	58.25	58.22	58.22	3840.0
2012-01-13 05:00:00	IWM	ETF	76.99	76.99	76.99	76.99	500.0
2012-01-13 06:00:00	IWM	ETF	77.0	77.0	77.0	77.0	980.0
2012-01-13 07:00:00	IWM	ETF	76.68	76.76	76.52	76.52	185178.0
2012-01-13 08:00:00	IWM	ETF	76.57	76.87	76.22	76.26	237360.0
2012-01-13 09:00:00	IWM	ETF	76.25	76.48	76.0	76.35	6132736.0
2012-01-13 10:00:00	IWM	ETF	76.35	76.37	75.6	76.04	10607212.0
2012-01-13 11:00:00	IWM	ETF	76.03	76.3401	76.0	76.161	4293639.0
2012-01-13 12:00:00	IWM	ETF	76.16	76.16	75.94	76.06	2585639.0
2012-01-13 13:00:00	IWM	ETF	76.0613	76.16	75.8	76.06	2966922.0
2012-01-13 14:00:00	IWM	ETF	76.07	76.17	76.0	76.145	1989374.0
2012-01-13 15:00:00	IWM	ETF	76.14	76.35	76.12	76.33	6323215.0
2012-01-13 16:00:00	IWM	ETF	76.34	76.48	76.295	76.39	5742524.0
2012-01-13 17:00:00	IWM	ETF	76.44	76.5	76.32	76.41	49044.0
2012-01-13 18:00:00	IWM	ETF	76.38	76.44	76.38	76.41	3484.0
2012-01-13 19:00:00	IWM	ETF	76.38	76.4	76.35	76.39	1300.0
2012-01-13 08:00:00	DIA	ETF	124.15	124.37	123.96	123.96	9000.0
2012-01-13 09:00:00	DIA	ETF	123.9	123.92	123.26	123.55	1193554.0
2012-01-13 10:00:00	DIA	ETF	123.53	123.58	122.92	123.39	1447537.0
2012-01-13 11:00:00	DIA	ETF	123.38	123.79	123.35	123.6123	775724.0
2012-01-13 12:00:00	DIA	ETF	123.6225	123.625	123.33	123.53	562315.0

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

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