PREVIEW / etf_1hour / 2009-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-27.parquet
  size:    128 KB
  rows:    3,996

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-02-27 04:00:00	SPY	ETF	75.72	75.84	75.62	75.62	17100.0
2009-02-27 05:00:00	SPY	ETF	75.62	75.9	75.56	75.83	26968.0
2009-02-27 06:00:00	SPY	ETF	75.93	75.97	75.35	75.42	56700.0
2009-02-27 07:00:00	SPY	ETF	75.45	75.48	74.4	74.77	3660952.0
2009-02-27 08:00:00	SPY	ETF	74.82	76.83	73.53	74.06	15674844.0
2009-02-27 09:00:00	SPY	ETF	74.06	74.69	73.81	74.46	47392275.0
2009-02-27 10:00:00	SPY	ETF	74.46	75.17	74.2	74.85	71276282.0
2009-02-27 11:00:00	SPY	ETF	74.85	75.3	74.34	75.1296	45139325.0
2009-02-27 12:00:00	SPY	ETF	75.1299	75.39	74.71	75.1	31238333.0
2009-02-27 13:00:00	SPY	ETF	75.11	75.39	74.41	75.28	48892556.0
2009-02-27 14:00:00	SPY	ETF	75.29	75.6872	74.5	75.06	59167133.0
2009-02-27 15:00:00	SPY	ETF	75.06	75.06	73.85	73.97	105693424.0
2009-02-27 16:00:00	SPY	ETF	73.97	75.6872	73.65	73.81	40607340.0
2009-02-27 17:00:00	SPY	ETF	73.78	74.245	73.69	73.78	179811.0
2009-02-27 18:00:00	SPY	ETF	73.78	73.89	73.78	73.81	35559.0
2009-02-27 19:00:00	SPY	ETF	73.81	73.88	73.76	73.85	39107.0
2009-02-27 04:00:00	QQQ	ETF	27.87	27.9	27.87	27.9	300.0
2009-02-27 05:00:00	QQQ	ETF	27.91	27.91	27.91	27.91	1000.0
2009-02-27 06:00:00	QQQ	ETF	27.93	27.93	27.93	27.93	100.0
2009-02-27 07:00:00	QQQ	ETF	27.77	27.79	27.49	27.62	196101.0
2009-02-27 08:00:00	QQQ	ETF	27.8	27.97	27.3	27.42	2243244.0
2009-02-27 09:00:00	QQQ	ETF	27.43	27.86	27.39	27.7612	25555027.0
2009-02-27 10:00:00	QQQ	ETF	27.77	27.96	27.64	27.75	28829605.0
2009-02-27 11:00:00	QQQ	ETF	27.75	27.89	27.55	27.82	22393186.0
2009-02-27 12:00:00	QQQ	ETF	27.82	27.93	27.57	27.75	18922847.0
2009-02-27 13:00:00	QQQ	ETF	27.75	27.89	27.59	27.87	18495377.0
2009-02-27 14:00:00	QQQ	ETF	27.86	27.98	27.66	27.87	17424837.0
2009-02-27 15:00:00	QQQ	ETF	27.87	27.87	27.52	27.54	45670620.0
2009-02-27 16:00:00	QQQ	ETF	27.54	28.5	27.4	27.46	18180600.0
2009-02-27 17:00:00	QQQ	ETF	27.45	27.7662	27.42	27.46	1038444.0
2009-02-27 18:00:00	QQQ	ETF	27.46	27.5	27.45	27.49	26072.0
2009-02-27 19:00:00	QQQ	ETF	27.46	27.5	27.43	27.43	12861.0
2009-02-27 07:00:00	IWM	ETF	39.28	39.38	38.88	39.04	130436.0
2009-02-27 08:00:00	IWM	ETF	38.934	39.5	38.42	38.68	766885.0
2009-02-27 09:00:00	IWM	ETF	38.72	39.34	38.61	39.18	9471932.0
2009-02-27 10:00:00	IWM	ETF	39.17	39.63	39.0	39.37	16740803.0
2009-02-27 11:00:00	IWM	ETF	39.37	39.54	39.05	39.5	9546057.0
2009-02-27 12:00:00	IWM	ETF	39.5	39.64	39.31	39.5774	4778796.0
2009-02-27 13:00:00	IWM	ETF	39.58	39.74	39.16	39.69	8297163.0
2009-02-27 14:00:00	IWM	ETF	39.68	39.88	39.28	39.55	8241383.0
2009-02-27 15:00:00	IWM	ETF	39.55	39.55	38.92	39.08	18841951.0
2009-02-27 16:00:00	IWM	ETF	39.06	39.3864	38.71	38.85	5001076.0
2009-02-27 17:00:00	IWM	ETF	39.3165	39.3165	38.77	38.86	503907.0
2009-02-27 18:00:00	IWM	ETF	38.76	38.76	38.76	38.76	100.0
2009-02-27 07:00:00	DIA	ETF	71.59	71.77	71.0	71.2	38573.0
2009-02-27 08:00:00	DIA	ETF	71.2	71.85	70.29	70.61	416838.0
2009-02-27 09:00:00	DIA	ETF	70.71	71.1499	70.37	70.94	4652285.0
2009-02-27 10:00:00	DIA	ETF	70.94	71.55	70.73	71.3	6682095.0
2009-02-27 11:00:00	DIA	ETF	71.3	71.82	70.85	71.71	3690424.0
2009-02-27 12:00:00	DIA	ETF	71.72	71.94	71.32	71.62	2352164.0

> showing 50 of 3,996 rows — these rows as CSV

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