PREVIEW / etf_1hour / 2009-07-21

all etf 1-hour files

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

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-21 04:00:00	SPY	ETF	95.21	95.35	95.2	95.25	1750.0
2009-07-21 05:00:00	SPY	ETF	95.21	95.35	95.2	95.31	4200.0
2009-07-21 06:00:00	SPY	ETF	95.37	95.5	95.37	95.42	6105.0
2009-07-21 07:00:00	SPY	ETF	95.37	95.82	95.34	95.73	647152.0
2009-07-21 08:00:00	SPY	ETF	95.73	95.82	94.9	95.77	2161558.0
2009-07-21 09:00:00	SPY	ETF	95.77	96.05	95.18	95.42	30836553.0
2009-07-21 10:00:00	SPY	ETF	95.43	95.61	94.95	95.41	32501512.0
2009-07-21 11:00:00	SPY	ETF	95.41	95.4682	94.6	94.65	23501300.0
2009-07-21 12:00:00	SPY	ETF	94.64	94.85	94.56	94.65	15765097.0
2009-07-21 13:00:00	SPY	ETF	94.65	94.83	94.42	94.71	19144242.0
2009-07-21 14:00:00	SPY	ETF	94.7199	95.43	94.7	95.12	30692072.0
2009-07-21 15:00:00	SPY	ETF	95.13	95.58	95.03	95.58	43372002.0
2009-07-21 16:00:00	SPY	ETF	95.57	96.0	95.38	95.99	9918605.0
2009-07-21 17:00:00	SPY	ETF	95.97	96.01	95.82	95.86	4034080.0
2009-07-21 18:00:00	SPY	ETF	95.84	95.93	95.57	95.83	270819.0
2009-07-21 19:00:00	SPY	ETF	95.85	95.87	95.62	95.62	85343.0
2009-07-21 20:00:00	SPY	ETF	95.64	95.64	95.64	95.64	100.0
2009-07-21 04:00:00	QQQ	ETF	37.89	37.89	37.89	37.89	200.0
2009-07-21 05:00:00	QQQ	ETF	37.89	37.89	37.88	37.88	7000.0
2009-07-21 06:00:00	QQQ	ETF	37.93	37.93	37.93	37.93	200.0
2009-07-21 07:00:00	QQQ	ETF	37.95	38.09	37.93	38.03	96517.0
2009-07-21 08:00:00	QQQ	ETF	38.04	38.06	37.72	38.01	736239.0
2009-07-21 09:00:00	QQQ	ETF	38.0	38.1	37.77	37.87	18337813.0
2009-07-21 10:00:00	QQQ	ETF	37.87	38.02	37.69	37.95	17927782.0
2009-07-21 11:00:00	QQQ	ETF	37.96	37.99	37.7	37.73	11927844.0
2009-07-21 12:00:00	QQQ	ETF	37.73	37.81	37.68	37.7301	10274041.0
2009-07-21 13:00:00	QQQ	ETF	37.73	37.87	37.64	37.8095	14354971.0
2009-07-21 14:00:00	QQQ	ETF	37.81	38.0	37.79	37.99	12499244.0
2009-07-21 15:00:00	QQQ	ETF	37.99	38.18	37.8	38.17	20735900.0
2009-07-21 16:00:00	QQQ	ETF	38.17	38.4	37.75	38.39	17935988.0
2009-07-21 17:00:00	QQQ	ETF	38.39	38.45	38.35	38.42	1111963.0
2009-07-21 18:00:00	QQQ	ETF	38.41	38.42	38.38	38.4	245447.0
2009-07-21 19:00:00	QQQ	ETF	38.39	38.41	38.37	38.37	256791.0
2009-07-21 06:00:00	IWM	ETF	52.67	52.67	52.66	52.66	5000.0
2009-07-21 07:00:00	IWM	ETF	52.63	52.93	52.63	52.88	37425.0
2009-07-21 08:00:00	IWM	ETF	52.9	52.98	52.83	52.89	544735.0
2009-07-21 09:00:00	IWM	ETF	52.89	53.14	52.3	52.5	6285354.0
2009-07-21 10:00:00	IWM	ETF	52.5	52.66	52.16	52.53	6124705.0
2009-07-21 11:00:00	IWM	ETF	52.53	52.58	52.01	52.04	3634860.0
2009-07-21 12:00:00	IWM	ETF	52.05	52.16	51.89	51.97	2941496.0
2009-07-21 13:00:00	IWM	ETF	51.97	52.17	51.79	52.14	3952216.0
2009-07-21 14:00:00	IWM	ETF	52.14	52.41	52.13	52.38	3300805.0
2009-07-21 15:00:00	IWM	ETF	52.39	52.54	52.33	52.46	6380873.0
2009-07-21 16:00:00	IWM	ETF	52.45	52.77	52.43	52.75	1513187.0
2009-07-21 17:00:00	IWM	ETF	52.75	52.77	52.69	52.69	118309.0
2009-07-21 18:00:00	IWM	ETF	52.68	52.72	52.64	52.72	2944.0
2009-07-21 19:00:00	IWM	ETF	52.74	52.76	52.7	52.7	6700.0
2009-07-21 06:00:00	DIA	ETF	88.45	88.62	88.45	88.55	5500.0
2009-07-21 07:00:00	DIA	ETF	88.61	88.99	88.57	88.99	32950.0
2009-07-21 08:00:00	DIA	ETF	89.0	89.11	88.89	89.03	114700.0

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

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