PREVIEW / etf_1hour / 2010-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-17.parquet
  size:    162 KB
  rows:    4,927

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-08-17 04:00:00	SPY	ETF	108.64	108.99	108.64	108.97	4912.0
2010-08-17 05:00:00	SPY	ETF	108.81	109.0	108.81	108.9	9000.0
2010-08-17 06:00:00	SPY	ETF	108.94	109.14	108.94	109.0	29450.0
2010-08-17 07:00:00	SPY	ETF	108.98	109.05	108.87	108.95	604678.0
2010-08-17 08:00:00	SPY	ETF	109.19	109.22	108.79	109.04	2885037.0
2010-08-17 09:00:00	SPY	ETF	109.05	111.17	108.83	109.085	22416885.0
2010-08-17 10:00:00	SPY	ETF	109.085	109.49	108.91	109.43	26364502.0
2010-08-17 11:00:00	SPY	ETF	109.43	110.08	109.2	110.0317	27165061.0
2010-08-17 12:00:00	SPY	ETF	110.0301	110.04	109.85	109.9028	11780272.0
2010-08-17 13:00:00	SPY	ETF	109.91	110.39	109.9	110.19	16844970.0
2010-08-17 14:00:00	SPY	ETF	110.19	110.28	110.09	110.13	10393925.0
2010-08-17 15:00:00	SPY	ETF	110.13	110.13	109.55	109.6	39150057.0
2010-08-17 16:00:00	SPY	ETF	109.59	110.295	108.2959	109.5	9769131.0
2010-08-17 17:00:00	SPY	ETF	109.51	109.51	108.26	108.26	106267.0
2010-08-17 18:00:00	SPY	ETF	109.46	109.59	109.44	109.55	98538.0
2010-08-17 19:00:00	SPY	ETF	109.52	109.55	109.45	109.49	34300.0
2010-08-17 04:00:00	QQQ	ETF	45.0	45.0	44.99	44.99	205.0
2010-08-17 05:00:00	QQQ	ETF	45.04	45.06	45.03	45.03	875.0
2010-08-17 06:00:00	QQQ	ETF	45.03	45.05	45.03	45.03	1450.0
2010-08-17 07:00:00	QQQ	ETF	45.01	45.06	45.0	45.02	67499.0
2010-08-17 08:00:00	QQQ	ETF	45.0	45.14	44.95	45.07	534814.0
2010-08-17 09:00:00	QQQ	ETF	45.07	45.25	45.03	45.19	5563522.0
2010-08-17 10:00:00	QQQ	ETF	45.185	45.36	45.13	45.33	7494970.0
2010-08-17 11:00:00	QQQ	ETF	45.34	45.64	45.33	45.6	8893067.0
2010-08-17 12:00:00	QQQ	ETF	45.6005	45.62	45.2	45.58	2897292.0
2010-08-17 13:00:00	QQQ	ETF	45.585	45.78	45.58	45.66	6657344.0
2010-08-17 14:00:00	QQQ	ETF	45.6599	45.71	45.58	45.6	4903140.0
2010-08-17 15:00:00	QQQ	ETF	45.6	45.61	45.35	45.3779	10212539.0
2010-08-17 16:00:00	QQQ	ETF	45.39	45.6435	44.8067	45.32	6163623.0
2010-08-17 17:00:00	QQQ	ETF	45.33	45.33	45.29	45.32	60851.0
2010-08-17 18:00:00	QQQ	ETF	45.31	45.34	45.3	45.34	42630.0
2010-08-17 19:00:00	QQQ	ETF	45.32	45.34	45.3	45.34	22679.0
2010-08-17 04:00:00	IWM	ETF	61.97	62.03	61.97	62.03	407.0
2010-08-17 06:00:00	IWM	ETF	62.25	62.25	62.14	62.14	600.0
2010-08-17 07:00:00	IWM	ETF	62.13	62.18	62.09	62.11	16500.0
2010-08-17 08:00:00	IWM	ETF	62.36	62.36	62.0	62.12	326754.0
2010-08-17 09:00:00	IWM	ETF	62.1	62.45	61.86	62.27	6579507.0
2010-08-17 10:00:00	IWM	ETF	62.26	62.6	62.07	62.57	6947008.0
2010-08-17 11:00:00	IWM	ETF	62.57	62.99	62.57	62.8301	7952467.0
2010-08-17 12:00:00	IWM	ETF	62.84	62.86	62.52	62.6	3456053.0
2010-08-17 13:00:00	IWM	ETF	62.59	63.155	62.58	62.922	5574696.0
2010-08-17 14:00:00	IWM	ETF	62.93	63.1	62.85	62.8876	3013012.0
2010-08-17 15:00:00	IWM	ETF	62.89	62.98	62.61	62.63	12051248.0
2010-08-17 16:00:00	IWM	ETF	62.63	62.8	61.5513	62.57	4805836.0
2010-08-17 17:00:00	IWM	ETF	62.59	62.65	61.5513	62.65	1003520.0
2010-08-17 18:00:00	IWM	ETF	62.62	62.65	62.62	62.65	911.0
2010-08-17 19:00:00	IWM	ETF	62.63	62.63	62.62	62.63	1400.0
2010-08-17 06:00:00	DIA	ETF	103.92	103.96	103.92	103.96	1000.0
2010-08-17 07:00:00	DIA	ETF	103.84	103.85	103.78	103.78	3600.0
2010-08-17 08:00:00	DIA	ETF	103.76	103.94	103.64	103.81	43450.0

> showing 50 of 4,927 rows — these rows as CSV

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