PREVIEW / etf_1hour / 2011-01-20

all etf 1-hour files

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

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-20 04:00:00	SPY	ETF	128.05	128.36	128.05	128.21	1850.0
2011-01-20 05:00:00	SPY	ETF	128.23	128.23	128.02	128.02	2400.0
2011-01-20 06:00:00	SPY	ETF	127.96	128.14	127.89	128.1	27570.0
2011-01-20 07:00:00	SPY	ETF	128.04	128.17	127.78	127.83	485242.0
2011-01-20 08:00:00	SPY	ETF	127.81	128.27	127.8	128.21	2416284.0
2011-01-20 09:00:00	SPY	ETF	128.22	128.23	127.48	128.0	24680047.0
2011-01-20 10:00:00	SPY	ETF	128.0	128.2	127.22	127.28	34886741.0
2011-01-20 11:00:00	SPY	ETF	127.29	127.52	127.13	127.505	20649683.0
2011-01-20 12:00:00	SPY	ETF	127.5072	127.93	127.5	127.88	13680064.0
2011-01-20 13:00:00	SPY	ETF	127.88	128.0	127.62	127.999	11537348.0
2011-01-20 14:00:00	SPY	ETF	127.99	128.4	127.925	128.25	20959509.0
2011-01-20 15:00:00	SPY	ETF	128.25	128.26	127.79	128.09	32825083.0
2011-01-20 16:00:00	SPY	ETF	128.1	128.3	127.25	128.14	11400069.0
2011-01-20 17:00:00	SPY	ETF	128.14	128.17	128.08	128.12	312171.0
2011-01-20 18:00:00	SPY	ETF	128.12	128.14	127.98	127.98	103709.0
2011-01-20 19:00:00	SPY	ETF	127.98	127.98	127.8	127.84	143455.0
2011-01-20 04:00:00	QQQ	ETF	56.37	56.37	56.37	56.37	2000.0
2011-01-20 05:00:00	QQQ	ETF	56.34	56.39	56.32	56.32	9500.0
2011-01-20 06:00:00	QQQ	ETF	56.28	56.33	56.25	56.3	6000.0
2011-01-20 07:00:00	QQQ	ETF	56.28	56.32	56.2	56.21	281506.0
2011-01-20 08:00:00	QQQ	ETF	56.21	56.38	56.04	56.38	754122.0
2011-01-20 09:00:00	QQQ	ETF	56.38	56.38	56.04	56.16	13203439.0
2011-01-20 10:00:00	QQQ	ETF	56.16	56.24	55.79	55.83	16910828.0
2011-01-20 11:00:00	QQQ	ETF	55.83	55.9	55.68	55.841	8017255.0
2011-01-20 12:00:00	QQQ	ETF	55.84	56.02	55.82	56.0	7251712.0
2011-01-20 13:00:00	QQQ	ETF	56.0	56.01	55.85	55.98	6035305.0
2011-01-20 14:00:00	QQQ	ETF	55.9891	56.32	55.95	56.275	10777160.0
2011-01-20 15:00:00	QQQ	ETF	56.275	56.275	55.89	56.11	13642863.0
2011-01-20 16:00:00	QQQ	ETF	56.11	56.5373	55.95	56.15	5276511.0
2011-01-20 17:00:00	QQQ	ETF	56.15	56.15	56.12	56.13	283119.0
2011-01-20 18:00:00	QQQ	ETF	56.13	56.14	56.09	56.09	11205.0
2011-01-20 19:00:00	QQQ	ETF	56.08	56.1	55.98	56.1	23749.0
2011-01-20 06:00:00	IWM	ETF	78.33	78.33	78.28	78.28	600.0
2011-01-20 07:00:00	IWM	ETF	78.29	78.36	78.0	78.0	37478.0
2011-01-20 08:00:00	IWM	ETF	78.0	78.27	77.73	78.24	491971.0
2011-01-20 09:00:00	IWM	ETF	78.24	78.37	77.43	78.23	10197566.0
2011-01-20 10:00:00	IWM	ETF	78.21	78.54	77.49	77.5	13458163.0
2011-01-20 11:00:00	IWM	ETF	77.5	77.72	77.34	77.5602	8002197.0
2011-01-20 12:00:00	IWM	ETF	77.56	77.8774	77.51	77.79	6228607.0
2011-01-20 13:00:00	IWM	ETF	77.782	77.782	77.48	77.75	6433677.0
2011-01-20 14:00:00	IWM	ETF	77.75	78.1	77.69	78.01	7050100.0
2011-01-20 15:00:00	IWM	ETF	78.018	78.02	77.62	77.72	10106251.0
2011-01-20 16:00:00	IWM	ETF	77.71	78.5479	77.56	77.71	4896706.0
2011-01-20 17:00:00	IWM	ETF	77.72	77.78	77.68	77.71	5018096.0
2011-01-20 18:00:00	IWM	ETF	77.71	77.74	77.66	77.67	14217.0
2011-01-20 19:00:00	IWM	ETF	77.69	77.69	77.59	77.59	12937.0
2011-01-20 04:00:00	DIA	ETF	118.25	118.25	118.16	118.16	1900.0
2011-01-20 05:00:00	DIA	ETF	118.21	118.21	118.07	118.07	18500.0
2011-01-20 06:00:00	DIA	ETF	118.05	118.05	117.95	117.95	7700.0
2011-01-20 07:00:00	DIA	ETF	118.11	118.11	117.83	117.96	20135.0

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

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