PREVIEW / etf_1hour / 2011-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-01.parquet
  size:    181 KB
  rows:    5,508

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-02-01 04:00:00	SPY	ETF	128.89	129.05	128.89	129.05	900.0
2011-02-01 05:00:00	SPY	ETF	129.17	129.26	129.17	129.25	38200.0
2011-02-01 06:00:00	SPY	ETF	129.25	129.34	129.25	129.29	322700.0
2011-02-01 07:00:00	SPY	ETF	129.28	129.39	129.13	129.35	547926.0
2011-02-01 08:00:00	SPY	ETF	129.33	129.5	128.67	129.4	1535142.0
2011-02-01 09:00:00	SPY	ETF	129.41	129.88	128.67	129.87	20495057.0
2011-02-01 10:00:00	SPY	ETF	129.87	130.28	129.69	130.2462	28935371.0
2011-02-01 11:00:00	SPY	ETF	130.25	130.52	130.09	130.38	16675428.0
2011-02-01 12:00:00	SPY	ETF	130.39	130.89	130.35	130.89	17819460.0
2011-02-01 13:00:00	SPY	ETF	130.88	130.94	130.66	130.675	16730843.0
2011-02-01 14:00:00	SPY	ETF	130.67	130.82	130.59	130.8	15146393.0
2011-02-01 15:00:00	SPY	ETF	130.81	130.97	130.7	130.75	29088397.0
2011-02-01 16:00:00	SPY	ETF	130.74	130.93	129.465	130.61	14596253.0
2011-02-01 17:00:00	SPY	ETF	130.61	130.8154	130.5294	130.59	1314134.0
2011-02-01 18:00:00	SPY	ETF	130.61	130.71	130.47	130.6	247195.0
2011-02-01 19:00:00	SPY	ETF	130.58	130.72	130.55	130.72	66649.0
2011-02-01 04:00:00	QQQ	ETF	56.21	56.21	56.21	56.21	306.0
2011-02-01 05:00:00	QQQ	ETF	56.32	56.33	56.32	56.33	300.0
2011-02-01 06:00:00	QQQ	ETF	56.37	56.37	56.34	56.35	1600.0
2011-02-01 07:00:00	QQQ	ETF	56.33	56.38	56.3	56.37	68439.0
2011-02-01 08:00:00	QQQ	ETF	56.36	56.42	56.02	56.37	408363.0
2011-02-01 09:00:00	QQQ	ETF	56.38	56.66	56.0	56.6	9085507.0
2011-02-01 10:00:00	QQQ	ETF	56.6	56.92	56.51	56.89	10945977.0
2011-02-01 11:00:00	QQQ	ETF	56.89	56.97	56.73	56.929	11015855.0
2011-02-01 12:00:00	QQQ	ETF	56.92	57.17	56.91	57.15	10133583.0
2011-02-01 13:00:00	QQQ	ETF	57.15	57.18	57.04	57.06	7462493.0
2011-02-01 14:00:00	QQQ	ETF	57.065	57.14	57.02	57.12	3455751.0
2011-02-01 15:00:00	QQQ	ETF	57.13	57.17	57.03	57.04	10191468.0
2011-02-01 16:00:00	QQQ	ETF	57.05	57.07	56.94	57.0	1650455.0
2011-02-01 17:00:00	QQQ	ETF	57.01	57.03	57.0	57.03	28129.0
2011-02-01 18:00:00	QQQ	ETF	57.0	57.07	56.97	56.99	65075.0
2011-02-01 19:00:00	QQQ	ETF	57.03	57.05	57.01	57.03	29700.0
2011-02-01 04:00:00	IWM	ETF	78.46	78.46	78.46	78.46	300.0
2011-02-01 06:00:00	IWM	ETF	78.54	78.54	78.53	78.54	3000.0
2011-02-01 07:00:00	IWM	ETF	78.56	78.58	78.38	78.56	110858.0
2011-02-01 08:00:00	IWM	ETF	78.55	78.62	77.95	78.57	207750.0
2011-02-01 09:00:00	IWM	ETF	78.56	78.7389	77.95	78.6497	6525725.0
2011-02-01 10:00:00	IWM	ETF	78.64	79.26	78.61	79.2	9018070.0
2011-02-01 11:00:00	IWM	ETF	79.19	79.63	79.03	79.54	5897386.0
2011-02-01 12:00:00	IWM	ETF	79.54	79.98	79.51	79.96	6321126.0
2011-02-01 13:00:00	IWM	ETF	79.95	80.01	79.79	79.83	3978686.0
2011-02-01 14:00:00	IWM	ETF	79.83	79.91	79.58	79.79	5268025.0
2011-02-01 15:00:00	IWM	ETF	79.79	79.92	79.65	79.69	11460340.0
2011-02-01 16:00:00	IWM	ETF	79.69	79.8217	79.56	79.72	2045154.0
2011-02-01 17:00:00	IWM	ETF	79.72	79.76	79.68	79.73	63787.0
2011-02-01 18:00:00	IWM	ETF	79.73	79.73	79.65	79.65	1400.0
2011-02-01 19:00:00	IWM	ETF	79.68	79.72	79.68	79.72	1500.0
2011-02-01 05:00:00	DIA	ETF	118.97	119.01	118.97	119.01	2900.0
2011-02-01 06:00:00	DIA	ETF	119.01	119.05	119.01	119.05	1300.0
2011-02-01 07:00:00	DIA	ETF	118.95	119.09	118.78	119.09	2700.0

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

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