PREVIEW / etf_1hour / 2009-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-13.parquet
  size:    129 KB
  rows:    4,003

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-03-13 04:00:00	SPY	ETF	76.03	76.31	75.99	76.21	36899.0
2009-03-13 05:00:00	SPY	ETF	76.22	76.23	76.0	76.05	68130.0
2009-03-13 06:00:00	SPY	ETF	76.05	76.34	76.02	76.34	46443.0
2009-03-13 07:00:00	SPY	ETF	76.42	76.59	76.18	76.3	911521.0
2009-03-13 08:00:00	SPY	ETF	76.3	76.51	75.4698	75.96	4936730.0
2009-03-13 09:00:00	SPY	ETF	75.96	76.3427	75.41	76.0	46623792.0
2009-03-13 10:00:00	SPY	ETF	76.01	76.39	75.46	75.61	64580901.0
2009-03-13 11:00:00	SPY	ETF	75.57	75.82	74.89	75.11	46230736.0
2009-03-13 12:00:00	SPY	ETF	75.1	75.46	74.73	75.4	36239624.0
2009-03-13 13:00:00	SPY	ETF	75.4	75.84	75.3	75.72	26798680.0
2009-03-13 14:00:00	SPY	ETF	75.72	76.19	75.5	75.8	43409459.0
2009-03-13 15:00:00	SPY	ETF	75.79	76.98	75.75	76.1	48297366.0
2009-03-13 16:00:00	SPY	ETF	76.13	76.49	74.85	76.34	13867642.0
2009-03-13 17:00:00	SPY	ETF	76.34	76.42	76.25	76.25	340216.0
2009-03-13 18:00:00	SPY	ETF	76.25	76.25	76.22	76.25	214895.0
2009-03-13 19:00:00	SPY	ETF	76.25	76.4	76.22	76.31	448338.0
2009-03-13 20:00:00	SPY	ETF	76.39	76.39	76.39	76.39	350.0
2009-03-13 04:00:00	QQQ	ETF	28.86	28.86	28.86	28.86	420.0
2009-03-13 05:00:00	QQQ	ETF	28.83	28.83	28.79	28.79	400.0
2009-03-13 06:00:00	QQQ	ETF	28.79	28.83	28.79	28.83	500.0
2009-03-13 07:00:00	QQQ	ETF	28.91	28.98	28.82	28.85	163468.0
2009-03-13 08:00:00	QQQ	ETF	28.85	28.89	28.57	28.58	1944946.0
2009-03-13 09:00:00	QQQ	ETF	28.59	28.76	28.45	28.731	23127738.0
2009-03-13 10:00:00	QQQ	ETF	28.73	28.84	28.51	28.56	31417916.0
2009-03-13 11:00:00	QQQ	ETF	28.56	28.64	28.34	28.4	18504364.0
2009-03-13 12:00:00	QQQ	ETF	28.4	28.52	28.32	28.5	14125102.0
2009-03-13 13:00:00	QQQ	ETF	28.5	28.67	28.49	28.59	12062030.0
2009-03-13 14:00:00	QQQ	ETF	28.59	28.74	28.47	28.65	17911259.0
2009-03-13 15:00:00	QQQ	ETF	28.64	28.8	28.63	28.76	20515246.0
2009-03-13 16:00:00	QQQ	ETF	28.76	28.86	28.6971	28.83	9607596.0
2009-03-13 17:00:00	QQQ	ETF	28.85	28.87	28.81	28.84	50585.0
2009-03-13 18:00:00	QQQ	ETF	28.83	28.83	28.81	28.82	5908.0
2009-03-13 19:00:00	QQQ	ETF	28.82	28.84	28.81	28.82	8665.0
2009-03-13 04:00:00	IWM	ETF	39.04	39.5	39.04	39.5	900.0
2009-03-13 06:00:00	IWM	ETF	39.42	39.45	39.42	39.45	1000.0
2009-03-13 07:00:00	IWM	ETF	39.62	39.75	39.53	39.53	6625.0
2009-03-13 08:00:00	IWM	ETF	39.51	39.55	38.95	39.27	1148982.0
2009-03-13 09:00:00	IWM	ETF	39.28	39.4	38.89	39.25	10646049.0
2009-03-13 10:00:00	IWM	ETF	39.25	39.54	38.94	39.21	14498829.0
2009-03-13 11:00:00	IWM	ETF	39.21	39.36	38.84	38.94	8501605.0
2009-03-13 12:00:00	IWM	ETF	38.94	39.13	38.76	39.07	7267290.0
2009-03-13 13:00:00	IWM	ETF	39.08	39.3799	39.0	39.31	6833863.0
2009-03-13 14:00:00	IWM	ETF	39.31	39.48	39.13	39.32	6512154.0
2009-03-13 15:00:00	IWM	ETF	39.32	39.66	39.29	39.38	10453435.0
2009-03-13 16:00:00	IWM	ETF	39.38	39.63	39.0851	39.56	4034575.0
2009-03-13 17:00:00	IWM	ETF	39.61	39.62	39.085	39.45	2005930.0
2009-03-13 19:00:00	IWM	ETF	39.38	39.38	39.38	39.38	200.0
2009-03-13 04:00:00	DIA	ETF	72.11	72.32	72.11	72.32	321.0
2009-03-13 06:00:00	DIA	ETF	72.3	72.43	72.22	72.43	38339.0
2009-03-13 07:00:00	DIA	ETF	72.5	72.63	72.35	72.4	48668.0

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

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