PREVIEW / etf_1hour / 2010-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-20.parquet
  size:    179 KB
  rows:    5,512

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
2010-05-20 04:00:00	SPY	ETF	111.71	111.71	111.66	111.7	3500.0
2010-05-20 05:00:00	SPY	ETF	111.51	111.51	111.35	111.35	1900.0
2010-05-20 06:00:00	SPY	ETF	111.32	111.34	110.75	110.88	140450.0
2010-05-20 07:00:00	SPY	ETF	110.87	110.98	109.42	109.87	4495119.0
2010-05-20 08:00:00	SPY	ETF	109.86	112.08	109.02	109.38	10101286.0
2010-05-20 09:00:00	SPY	ETF	109.37	111.6	109.12	109.54	60506407.0
2010-05-20 10:00:00	SPY	ETF	109.53	109.7683	107.95	108.8	84283108.0
2010-05-20 11:00:00	SPY	ETF	108.79	109.46	108.62	108.84	48546541.0
2010-05-20 12:00:00	SPY	ETF	108.85	109.13	107.65	107.68	41768556.0
2010-05-20 13:00:00	SPY	ETF	107.68	109.29	107.61	108.72	68301763.0
2010-05-20 14:00:00	SPY	ETF	108.73	109.88	108.13	109.13	72926736.0
2010-05-20 15:00:00	SPY	ETF	109.12	109.39	107.48	107.538	93268569.0
2010-05-20 16:00:00	SPY	ETF	107.5	111.8565	106.83	107.05	32955938.0
2010-05-20 17:00:00	SPY	ETF	107.06	111.8565	106.7	106.79	10964384.0
2010-05-20 18:00:00	SPY	ETF	106.79	107.55	106.76	106.91	907663.0
2010-05-20 19:00:00	SPY	ETF	106.92	107.24	106.69	107.2	398673.0
2010-05-20 04:00:00	QQQ	ETF	45.99	45.99	45.99	45.99	1023.0
2010-05-20 05:00:00	QQQ	ETF	45.97	45.97	45.93	45.93	1500.0
2010-05-20 06:00:00	QQQ	ETF	45.82	45.82	45.6	45.65	3900.0
2010-05-20 07:00:00	QQQ	ETF	45.66	45.69	45.13	45.32	556848.0
2010-05-20 08:00:00	QQQ	ETF	45.32	45.44	45.04	45.11	1724967.0
2010-05-20 09:00:00	QQQ	ETF	45.12	45.86	44.98	45.1	20172505.0
2010-05-20 10:00:00	QQQ	ETF	45.102	45.23	44.4	44.75	38160061.0
2010-05-20 11:00:00	QQQ	ETF	44.75	45.01	44.67	44.81	17650700.0
2010-05-20 12:00:00	QQQ	ETF	44.81	44.88	44.25	44.28	14909347.0
2010-05-20 13:00:00	QQQ	ETF	44.27	44.95	44.26	44.73	22228772.0
2010-05-20 14:00:00	QQQ	ETF	44.72	45.28	44.49	44.99	27820418.0
2010-05-20 15:00:00	QQQ	ETF	44.99	45.09	44.32	44.32	29944145.0
2010-05-20 16:00:00	QQQ	ETF	44.32	46.106	44.11	44.24	9246916.0
2010-05-20 17:00:00	QQQ	ETF	44.17	44.2	44.06	44.08	236663.0
2010-05-20 18:00:00	QQQ	ETF	44.11	44.22	44.09	44.12	683881.0
2010-05-20 19:00:00	QQQ	ETF	44.14	44.29	44.08	44.25	62495.0
2010-05-20 06:00:00	IWM	ETF	67.01	67.01	66.74	66.74	10400.0
2010-05-20 07:00:00	IWM	ETF	66.83	66.85	65.84	66.04	617500.0
2010-05-20 08:00:00	IWM	ETF	66.03	67.87	65.69	65.83	1538753.0
2010-05-20 09:00:00	IWM	ETF	65.81	67.4	65.5	65.71	15671569.0
2010-05-20 10:00:00	IWM	ETF	65.7	66.03	64.77	64.98	24177569.0
2010-05-20 11:00:00	IWM	ETF	64.98	65.49	64.86	64.96	20147121.0
2010-05-20 12:00:00	IWM	ETF	64.96	65.13	64.1	64.13	13835571.0
2010-05-20 13:00:00	IWM	ETF	64.13	65.16	64.09	64.69	21621657.0
2010-05-20 14:00:00	IWM	ETF	64.69	65.69	64.43	65.2	24326670.0
2010-05-20 15:00:00	IWM	ETF	65.2	65.38	64.08	64.13	28095866.0
2010-05-20 16:00:00	IWM	ETF	64.12	67.5077	63.71	63.75	7479562.0
2010-05-20 17:00:00	IWM	ETF	63.75	63.76	63.58	63.65	204677.0
2010-05-20 18:00:00	IWM	ETF	63.74	63.74	63.16	63.58	35462.0
2010-05-20 19:00:00	IWM	ETF	63.53	63.64	63.42	63.6	32128.0
2010-05-20 06:00:00	DIA	ETF	104.29	104.29	104.0	104.0	27901.0
2010-05-20 07:00:00	DIA	ETF	104.16	104.16	102.99	103.3	29365.0
2010-05-20 08:00:00	DIA	ETF	103.32	103.51	102.79	103.04	112181.0
2010-05-20 09:00:00	DIA	ETF	103.02	103.29	102.56	102.9	3607949.0

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

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