PREVIEW / etf_1hour / 2009-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-14.parquet
  size:    135 KB
  rows:    4,117

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-05-14 04:00:00	SPY	ETF	89.09	89.22	89.07	89.15	3770.0
2009-05-14 05:00:00	SPY	ETF	89.0	89.1	89.0	89.01	16400.0
2009-05-14 06:00:00	SPY	ETF	88.94	88.95	88.55	88.71	36837.0
2009-05-14 07:00:00	SPY	ETF	88.68	89.08	88.54	88.95	1118800.0
2009-05-14 08:00:00	SPY	ETF	88.95	89.12	88.34	88.75	9432018.0
2009-05-14 09:00:00	SPY	ETF	88.73	89.22	88.5	88.75	34284963.0
2009-05-14 10:00:00	SPY	ETF	88.74	89.34	88.74	89.11	41026678.0
2009-05-14 11:00:00	SPY	ETF	89.11	89.52	89.08	89.43	25741258.0
2009-05-14 12:00:00	SPY	ETF	89.43	89.85	89.41	89.61	24088539.0
2009-05-14 13:00:00	SPY	ETF	89.6114	89.72	89.33	89.47	15932592.0
2009-05-14 14:00:00	SPY	ETF	89.47	90.12	89.47	89.92	42422899.0
2009-05-14 15:00:00	SPY	ETF	89.92	90.01	89.32	89.44	49612674.0
2009-05-14 16:00:00	SPY	ETF	89.44	89.6	88.6514	89.45	9279243.0
2009-05-14 17:00:00	SPY	ETF	89.44	89.533	89.37	89.44	190911.0
2009-05-14 18:00:00	SPY	ETF	89.44	89.45	89.32	89.42	159901.0
2009-05-14 19:00:00	SPY	ETF	89.44	89.6	89.37	89.55	54907.0
2009-05-14 04:00:00	QQQ	ETF	33.15	33.18	33.09	33.18	1250.0
2009-05-14 05:00:00	QQQ	ETF	33.18	33.18	33.18	33.18	100.0
2009-05-14 07:00:00	QQQ	ETF	33.09	33.23	33.02	33.23	944735.0
2009-05-14 08:00:00	QQQ	ETF	33.23	33.25	32.99	33.14	6121305.0
2009-05-14 09:00:00	QQQ	ETF	33.14	33.34	33.08	33.23	19091691.0
2009-05-14 10:00:00	QQQ	ETF	33.23	33.43	33.22	33.35	18143456.0
2009-05-14 11:00:00	QQQ	ETF	33.3475	33.5	33.34	33.48	11157944.0
2009-05-14 12:00:00	QQQ	ETF	33.48	33.6	33.41	33.54	9891268.0
2009-05-14 13:00:00	QQQ	ETF	33.54	33.58	33.44	33.49	11332042.0
2009-05-14 14:00:00	QQQ	ETF	33.4899	33.7	33.4899	33.63	14789720.0
2009-05-14 15:00:00	QQQ	ETF	33.63	33.66	33.38	33.39	30706139.0
2009-05-14 16:00:00	QQQ	ETF	33.39	33.4599	33.32	33.4	4621707.0
2009-05-14 17:00:00	QQQ	ETF	33.38	33.42	33.36	33.39	155087.0
2009-05-14 18:00:00	QQQ	ETF	33.39	33.4	33.35	33.39	76200.0
2009-05-14 19:00:00	QQQ	ETF	33.39	33.43	33.38	33.43	22560.0
2009-05-14 06:00:00	IWM	ETF	47.44	47.44	47.44	47.44	4000.0
2009-05-14 07:00:00	IWM	ETF	47.36	47.58	47.3	47.54	198121.0
2009-05-14 08:00:00	IWM	ETF	47.53	47.74	47.26	47.46	2781176.0
2009-05-14 09:00:00	IWM	ETF	47.44	47.76	47.06	47.26	7880258.0
2009-05-14 10:00:00	IWM	ETF	47.27	47.82	47.1	47.69	10845092.0
2009-05-14 11:00:00	IWM	ETF	47.69	48.11	47.6176	47.96	6796353.0
2009-05-14 12:00:00	IWM	ETF	47.97	48.45	47.95	48.26	7776836.0
2009-05-14 13:00:00	IWM	ETF	48.27	48.46	48.07	48.31	4611292.0
2009-05-14 14:00:00	IWM	ETF	48.32	48.75	48.315	48.51	7336539.0
2009-05-14 15:00:00	IWM	ETF	48.5	48.75	47.91	47.99	15899045.0
2009-05-14 16:00:00	IWM	ETF	47.99	48.4034	47.1796	47.98	4013674.0
2009-05-14 17:00:00	IWM	ETF	47.99	48.05	47.99	48.03	1966.0
2009-05-14 19:00:00	IWM	ETF	48.0	48.0	48.0	48.0	200.0
2009-05-14 07:00:00	DIA	ETF	83.09	83.09	83.0	83.0	400.0
2009-05-14 08:00:00	DIA	ETF	83.29	83.47	82.84	83.17	288303.0
2009-05-14 09:00:00	DIA	ETF	83.15	83.58	82.94	83.14	2275643.0
2009-05-14 10:00:00	DIA	ETF	83.15	83.55	83.11	83.32	2461407.0
2009-05-14 11:00:00	DIA	ETF	83.33	83.61	83.3	83.48	1393556.0
2009-05-14 12:00:00	DIA	ETF	83.49	83.84	83.48	83.63	1880887.0

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

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