PREVIEW / etf_1hour / 2009-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-22.parquet
  size:    134 KB
  rows:    4,128

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-04-22 04:00:00	SPY	ETF	84.6	84.6	84.34	84.43	9050.0
2009-04-22 05:00:00	SPY	ETF	84.57	84.84	84.57	84.84	3600.0
2009-04-22 06:00:00	SPY	ETF	84.71	84.88	84.56	84.74	25349.0
2009-04-22 07:00:00	SPY	ETF	84.7	84.98	84.43	84.86	986915.0
2009-04-22 08:00:00	SPY	ETF	84.85	85.08	84.06	84.23	6780973.0
2009-04-22 09:00:00	SPY	ETF	84.23	84.69	84.03	84.63	30225245.0
2009-04-22 10:00:00	SPY	ETF	84.62	85.92	84.3	85.58	65856533.0
2009-04-22 11:00:00	SPY	ETF	85.58	86.13	85.49	86.0999	33062777.0
2009-04-22 12:00:00	SPY	ETF	86.1	86.12	85.03	85.2895	39444678.0
2009-04-22 13:00:00	SPY	ETF	85.29	85.85	85.08	85.36	26647139.0
2009-04-22 14:00:00	SPY	ETF	85.36	86.3	84.65	85.95	42810628.0
2009-04-22 15:00:00	SPY	ETF	85.95	86.34	84.34	84.54	72442769.0
2009-04-22 16:00:00	SPY	ETF	84.52	85.1653	84.02	84.25	16858969.0
2009-04-22 17:00:00	SPY	ETF	84.27	84.43	84.19	84.35	2881939.0
2009-04-22 18:00:00	SPY	ETF	84.35	84.43	84.19	84.4	135220.0
2009-04-22 19:00:00	SPY	ETF	84.38	84.4	84.23	84.28	34920.0
2009-04-22 05:00:00	QQQ	ETF	32.53	32.53	32.53	32.53	100.0
2009-04-22 06:00:00	QQQ	ETF	32.52	32.55	32.45	32.51	9900.0
2009-04-22 07:00:00	QQQ	ETF	32.5	32.68	32.46	32.64	497768.0
2009-04-22 08:00:00	QQQ	ETF	32.63	32.64	32.38	32.48	2955138.0
2009-04-22 09:00:00	QQQ	ETF	32.48	32.929	32.39	32.92	13228914.0
2009-04-22 10:00:00	QQQ	ETF	32.92	33.32	32.911	33.17	30713064.0
2009-04-22 11:00:00	QQQ	ETF	33.16	33.46	33.1	33.42	13571676.0
2009-04-22 12:00:00	QQQ	ETF	33.42	33.42	33.01	33.1299	20630077.0
2009-04-22 13:00:00	QQQ	ETF	33.1221	33.29	33.05	33.08	12398163.0
2009-04-22 14:00:00	QQQ	ETF	33.08	33.48	33.06	33.38	15053592.0
2009-04-22 15:00:00	QQQ	ETF	33.37	33.53	32.77	32.81	40845277.0
2009-04-22 16:00:00	QQQ	ETF	32.81	33.0587	32.46	32.81	7927541.0
2009-04-22 17:00:00	QQQ	ETF	32.82	33.06	32.71	32.89	1223838.0
2009-04-22 18:00:00	QQQ	ETF	32.88	32.91	32.78	32.86	225642.0
2009-04-22 19:00:00	QQQ	ETF	32.87	32.88	32.83	32.87	35727.0
2009-04-22 06:00:00	IWM	ETF	46.54	46.56	46.54	46.56	400.0
2009-04-22 07:00:00	IWM	ETF	46.47	46.67	46.34	46.67	9918.0
2009-04-22 08:00:00	IWM	ETF	46.61	46.61	46.13	46.22	199106.0
2009-04-22 09:00:00	IWM	ETF	46.23	46.79	46.03	46.77	6074704.0
2009-04-22 10:00:00	IWM	ETF	46.77	47.88	46.77	47.63	14747843.0
2009-04-22 11:00:00	IWM	ETF	47.64	48.03	47.53	48.02	5975493.0
2009-04-22 12:00:00	IWM	ETF	48.02	48.04	47.17	47.4	6012876.0
2009-04-22 13:00:00	IWM	ETF	47.4	47.81	47.29	47.39	5042106.0
2009-04-22 14:00:00	IWM	ETF	47.39	48.03	46.6	47.75	6752676.0
2009-04-22 15:00:00	IWM	ETF	47.76	48.16	46.84	46.94	19411447.0
2009-04-22 16:00:00	IWM	ETF	46.93	47.75	46.64	46.92	2765492.0
2009-04-22 17:00:00	IWM	ETF	46.89	46.9956	46.85	46.99	1541150.0
2009-04-22 18:00:00	IWM	ETF	46.91	47.01	46.91	46.91	1300.0
2009-04-22 19:00:00	IWM	ETF	46.97	46.98	46.86	46.95	2099.0
2009-04-22 07:00:00	DIA	ETF	79.1	79.44	79.1	79.4	8588.0
2009-04-22 08:00:00	DIA	ETF	79.39	79.42	78.85	78.98	180154.0
2009-04-22 09:00:00	DIA	ETF	78.95	79.41	78.82	79.28	2251321.0
2009-04-22 10:00:00	DIA	ETF	79.29	80.45	79.2608	80.07	4002478.0
2009-04-22 11:00:00	DIA	ETF	80.0694	80.41	79.97	80.38	1990765.0

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

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