PREVIEW / etf_1hour / 2009-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-14.parquet
  size:    136 KB
  rows:    4,194

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-14 04:00:00	SPY	ETF	90.23	90.34	90.19	90.34	33800.0
2009-07-14 05:00:00	SPY	ETF	90.17	90.35	90.11	90.32	15982.0
2009-07-14 06:00:00	SPY	ETF	90.24	90.24	90.17	90.18	4800.0
2009-07-14 07:00:00	SPY	ETF	90.11	90.77	90.1	90.73	1007023.0
2009-07-14 08:00:00	SPY	ETF	90.71	90.83	89.96	90.18	7640559.0
2009-07-14 09:00:00	SPY	ETF	90.18	90.59	89.91	90.0078	26153165.0
2009-07-14 10:00:00	SPY	ETF	90.0	90.4	89.73	90.0	25790605.0
2009-07-14 11:00:00	SPY	ETF	89.99	90.64	89.94	90.56	18846096.0
2009-07-14 12:00:00	SPY	ETF	90.56	90.61	90.17	90.34	13986830.0
2009-07-14 13:00:00	SPY	ETF	90.35	90.5	90.24	90.34	10463416.0
2009-07-14 14:00:00	SPY	ETF	90.34	90.63	90.11	90.51	22229013.0
2009-07-14 15:00:00	SPY	ETF	90.52	90.69	90.41	90.68	43295838.0
2009-07-14 16:00:00	SPY	ETF	90.67	91.69	90.03	91.5	9823412.0
2009-07-14 17:00:00	SPY	ETF	91.51	91.7	91.44	91.56	1517047.0
2009-07-14 18:00:00	SPY	ETF	91.54	91.54	90.63	91.46	243448.0
2009-07-14 19:00:00	SPY	ETF	91.46	91.46	91.41	91.45	47876.0
2009-07-14 05:00:00	QQQ	ETF	35.61	35.66	35.61	35.63	3600.0
2009-07-14 06:00:00	QQQ	ETF	35.59	35.59	35.59	35.59	587.0
2009-07-14 07:00:00	QQQ	ETF	35.56	35.69	35.54	35.69	296585.0
2009-07-14 08:00:00	QQQ	ETF	35.69	35.74	35.43	35.46	3040110.0
2009-07-14 09:00:00	QQQ	ETF	35.45	35.76	35.4	35.48	16507819.0
2009-07-14 10:00:00	QQQ	ETF	35.48	35.68	35.4	35.53	16098385.0
2009-07-14 11:00:00	QQQ	ETF	35.53	35.74	35.5	35.72	15147637.0
2009-07-14 12:00:00	QQQ	ETF	35.72	35.72	35.57	35.65	5700893.0
2009-07-14 13:00:00	QQQ	ETF	35.66	35.72	35.64	35.67	6652791.0
2009-07-14 14:00:00	QQQ	ETF	35.6602	35.79	35.6	35.7516	12534755.0
2009-07-14 15:00:00	QQQ	ETF	35.75	35.77	35.61	35.73	21555164.0
2009-07-14 16:00:00	QQQ	ETF	35.72	36.36	35.62	36.26	13858499.0
2009-07-14 17:00:00	QQQ	ETF	36.26	36.29	36.23	36.24	530421.0
2009-07-14 18:00:00	QQQ	ETF	36.26	36.26	36.21	36.24	218867.0
2009-07-14 19:00:00	QQQ	ETF	36.24	36.25	36.23	36.24	65873.0
2009-07-14 06:00:00	IWM	ETF	49.31	49.31	49.31	49.31	5000.0
2009-07-14 07:00:00	IWM	ETF	49.26	49.55	49.26	49.55	50593.0
2009-07-14 08:00:00	IWM	ETF	49.54	49.55	49.12	49.19	460505.0
2009-07-14 09:00:00	IWM	ETF	49.19	49.46	48.95	49.04	6041804.0
2009-07-14 10:00:00	IWM	ETF	49.05	49.33	48.97	49.16	4427283.0
2009-07-14 11:00:00	IWM	ETF	49.16	49.7	49.1	49.61	5800436.0
2009-07-14 12:00:00	IWM	ETF	49.62	49.6399	49.35	49.52	1568890.0
2009-07-14 13:00:00	IWM	ETF	49.52	49.62	49.44	49.5201	1302060.0
2009-07-14 14:00:00	IWM	ETF	49.53	49.68	49.38	49.62	2227399.0
2009-07-14 15:00:00	IWM	ETF	49.615	49.72	49.53	49.58	4893720.0
2009-07-14 16:00:00	IWM	ETF	49.58	50.24	49.5	50.16	2162103.0
2009-07-14 17:00:00	IWM	ETF	50.15	50.2	50.07	50.15	46291.0
2009-07-14 18:00:00	IWM	ETF	50.1	50.16	49.8	50.1	9840.0
2009-07-14 19:00:00	IWM	ETF	50.08	50.09	50.0	50.03	7300.0
2009-07-14 07:00:00	DIA	ETF	83.4	83.9	83.4	83.9	7700.0
2009-07-14 08:00:00	DIA	ETF	83.85	83.87	83.29	83.45	84267.0
2009-07-14 09:00:00	DIA	ETF	83.37	83.71	83.1	83.18	2414156.0
2009-07-14 10:00:00	DIA	ETF	83.19	83.56	82.93	83.1	1665539.0
2009-07-14 11:00:00	DIA	ETF	83.13	83.69	83.12	83.63	1308481.0

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

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