PREVIEW / etf_1hour / 2009-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-28.parquet
  size:    141 KB
  rows:    4,312

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
2009-07-28 04:00:00	SPY	ETF	98.45	98.45	98.2	98.24	27700.0
2009-07-28 05:00:00	SPY	ETF	98.3	98.3	98.06	98.17	20700.0
2009-07-28 06:00:00	SPY	ETF	98.16	98.25	97.96	97.98	23400.0
2009-07-28 07:00:00	SPY	ETF	98.03	98.05	97.69	97.7	697408.0
2009-07-28 08:00:00	SPY	ETF	97.71	97.91	97.69	97.9	2418155.0
2009-07-28 09:00:00	SPY	ETF	97.91	98.37	97.6	98.26	24134383.0
2009-07-28 10:00:00	SPY	ETF	98.31	98.335	97.41	97.8	32329940.0
2009-07-28 11:00:00	SPY	ETF	97.81	98.3305	97.06	97.34	26235298.0
2009-07-28 12:00:00	SPY	ETF	97.34	97.48	97.18	97.39	13097912.0
2009-07-28 13:00:00	SPY	ETF	97.39	97.86	97.19	97.77	19957432.0
2009-07-28 14:00:00	SPY	ETF	97.78	98.25	97.55	97.82	24922474.0
2009-07-28 15:00:00	SPY	ETF	97.82	98.15	97.57	98.06	34308877.0
2009-07-28 16:00:00	SPY	ETF	98.05	98.3305	97.5	97.89	7080631.0
2009-07-28 17:00:00	SPY	ETF	97.87	97.9679	97.8	97.87	181441.0
2009-07-28 18:00:00	SPY	ETF	97.85	97.87	97.78	97.82	107808.0
2009-07-28 19:00:00	SPY	ETF	97.81	97.81	97.63	97.63	143578.0
2009-07-28 04:00:00	QQQ	ETF	39.37	39.39	39.33	39.33	1800.0
2009-07-28 05:00:00	QQQ	ETF	39.32	39.32	39.28	39.32	5869.0
2009-07-28 06:00:00	QQQ	ETF	39.26	39.27	39.26	39.27	577.0
2009-07-28 07:00:00	QQQ	ETF	39.3	39.3	39.15	39.16	292742.0
2009-07-28 08:00:00	QQQ	ETF	39.15	39.24	39.13	39.23	778541.0
2009-07-28 09:00:00	QQQ	ETF	39.25	39.42	39.12	39.35	13491746.0
2009-07-28 10:00:00	QQQ	ETF	39.38	39.38	38.99	39.2	18068152.0
2009-07-28 11:00:00	QQQ	ETF	39.2	39.2001	38.93	39.0701	12930628.0
2009-07-28 12:00:00	QQQ	ETF	39.07	39.13	39.02	39.1	5690914.0
2009-07-28 13:00:00	QQQ	ETF	39.1002	39.39	39.04	39.36	10244934.0
2009-07-28 14:00:00	QQQ	ETF	39.36	39.59	39.291	39.3601	16498106.0
2009-07-28 15:00:00	QQQ	ETF	39.36	39.51	39.25	39.47	21779507.0
2009-07-28 16:00:00	QQQ	ETF	39.47	39.5	39.08	39.41	9785005.0
2009-07-28 17:00:00	QQQ	ETF	39.42	39.43	39.37	39.38	185434.0
2009-07-28 18:00:00	QQQ	ETF	39.4	39.4	39.37	39.38	69514.0
2009-07-28 19:00:00	QQQ	ETF	39.39	39.39	39.3	39.3	86291.0
2009-07-28 06:00:00	IWM	ETF	55.0	55.0	54.91	54.91	6000.0
2009-07-28 07:00:00	IWM	ETF	54.89	54.89	54.67	54.72	23266.0
2009-07-28 08:00:00	IWM	ETF	54.72	54.86	54.68	54.85	256731.0
2009-07-28 09:00:00	IWM	ETF	54.88	55.32	54.67	55.26	5866132.0
2009-07-28 10:00:00	IWM	ETF	55.23	55.28	54.68	55.03	8467938.0
2009-07-28 11:00:00	IWM	ETF	55.03	55.03	54.34	54.51	7093847.0
2009-07-28 12:00:00	IWM	ETF	54.518	54.66	54.435	54.6016	1450586.0
2009-07-28 13:00:00	IWM	ETF	54.61	55.06	54.47	55.03	5913138.0
2009-07-28 14:00:00	IWM	ETF	55.0301	55.26	54.89	54.95	5455265.0
2009-07-28 15:00:00	IWM	ETF	54.95	55.23	54.8	55.11	11469109.0
2009-07-28 16:00:00	IWM	ETF	55.11	55.22	55.01	55.12	7278593.0
2009-07-28 17:00:00	IWM	ETF	55.09	55.09	55.03	55.06	16504.0
2009-07-28 18:00:00	IWM	ETF	55.05	55.06	55.02	55.02	800.0
2009-07-28 19:00:00	IWM	ETF	55.05	55.08	55.04	55.05	1200.0
2009-07-28 06:00:00	DIA	ETF	90.96	90.96	90.96	90.96	100.0
2009-07-28 07:00:00	DIA	ETF	90.93	90.93	90.64	90.64	900.0
2009-07-28 08:00:00	DIA	ETF	90.64	90.8	90.6	90.8	22150.0
2009-07-28 09:00:00	DIA	ETF	90.83	91.28	90.54	91.22	1394987.0

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

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