PREVIEW / etf_1hour / 2010-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-25.parquet
  size:    159 KB
  rows:    4,851

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
2010-06-25 04:00:00	SPY	ETF	107.72	107.72	107.39	107.39	1609.0
2010-06-25 05:00:00	SPY	ETF	107.37	107.37	107.07	107.07	4800.0
2010-06-25 06:00:00	SPY	ETF	107.24	107.59	107.22	107.59	21560.0
2010-06-25 07:00:00	SPY	ETF	107.57	107.99	107.49	107.92	790032.0
2010-06-25 08:00:00	SPY	ETF	107.9	107.93	107.22	107.47	3089876.0
2010-06-25 09:00:00	SPY	ETF	107.47	107.76	107.08	107.5	28176350.0
2010-06-25 10:00:00	SPY	ETF	107.48	107.83	106.77	106.89	37583229.0
2010-06-25 11:00:00	SPY	ETF	106.89	107.55	106.88	107.37	23850712.0
2010-06-25 12:00:00	SPY	ETF	107.37	107.73	107.26	107.445	22791136.0
2010-06-25 13:00:00	SPY	ETF	107.44	108.42	107.39	108.23	26779220.0
2010-06-25 14:00:00	SPY	ETF	108.22	108.38	108.01	108.15	16835069.0
2010-06-25 15:00:00	SPY	ETF	108.1524	108.24	107.55	107.89	50501430.0
2010-06-25 16:00:00	SPY	ETF	107.89	108.27	106.99	108.0	23194761.0
2010-06-25 17:00:00	SPY	ETF	108.0	108.02	107.8	107.89	560113.0
2010-06-25 18:00:00	SPY	ETF	107.87	107.95	107.42	107.64	866908.0
2010-06-25 19:00:00	SPY	ETF	107.65	107.75	107.62	107.72	147347.0
2010-06-25 04:00:00	QQQ	ETF	45.47	45.49	45.3	45.36	28514.0
2010-06-25 05:00:00	QQQ	ETF	45.3	45.3	45.3	45.3	20400.0
2010-06-25 06:00:00	QQQ	ETF	45.35	45.4	45.35	45.39	1900.0
2010-06-25 07:00:00	QQQ	ETF	45.44	45.59	45.38	45.54	68212.0
2010-06-25 08:00:00	QQQ	ETF	45.56	45.56	45.06	45.44	1914719.0
2010-06-25 09:00:00	QQQ	ETF	45.44	45.56	45.05	45.26	11480943.0
2010-06-25 10:00:00	QQQ	ETF	45.26	45.44	44.95	45.0	14607248.0
2010-06-25 11:00:00	QQQ	ETF	45.005	45.26	44.99	45.1901	7890058.0
2010-06-25 12:00:00	QQQ	ETF	45.19	45.4	45.14	45.26	7088115.0
2010-06-25 13:00:00	QQQ	ETF	45.26	45.66	45.24	45.5572	11842732.0
2010-06-25 14:00:00	QQQ	ETF	45.555	45.61	45.4	45.45	5748654.0
2010-06-25 15:00:00	QQQ	ETF	45.45	45.49	45.195	45.26	13813138.0
2010-06-25 16:00:00	QQQ	ETF	45.26	45.3412	45.08	45.15	6285093.0
2010-06-25 17:00:00	QQQ	ETF	45.13	45.18	45.13	45.14	40674.0
2010-06-25 18:00:00	QQQ	ETF	45.14	45.21	45.1	45.12	36769.0
2010-06-25 19:00:00	QQQ	ETF	45.13	45.15	45.11	45.14	21886.0
2010-06-25 05:00:00	IWM	ETF	63.36	63.36	63.22	63.23	332.0
2010-06-25 06:00:00	IWM	ETF	63.36	63.52	63.32	63.52	13890.0
2010-06-25 07:00:00	IWM	ETF	63.51	63.8	63.48	63.75	98099.0
2010-06-25 08:00:00	IWM	ETF	63.75	63.79	63.45	63.65	1046908.0
2010-06-25 09:00:00	IWM	ETF	63.62	63.85	63.2	63.57	7532294.0
2010-06-25 10:00:00	IWM	ETF	63.56	63.94	63.44	63.56	11328976.0
2010-06-25 11:00:00	IWM	ETF	63.57	64.05	63.56	63.96	8293631.0
2010-06-25 12:00:00	IWM	ETF	63.96	64.31	63.87	64.15	6961731.0
2010-06-25 13:00:00	IWM	ETF	64.14	64.915	63.9223	64.68	9977384.0
2010-06-25 14:00:00	IWM	ETF	64.68	64.76	64.42	64.57	7004280.0
2010-06-25 15:00:00	IWM	ETF	64.56	64.7	64.14	64.651	21838266.0
2010-06-25 16:00:00	IWM	ETF	64.66	64.71	63.6	64.69	6274918.0
2010-06-25 17:00:00	IWM	ETF	64.67	64.73	64.6	64.65	19789.0
2010-06-25 18:00:00	IWM	ETF	64.59	64.61	64.56	64.56	4915.0
2010-06-25 19:00:00	IWM	ETF	64.56	64.56	64.5	64.53	39925.0
2010-06-25 06:00:00	DIA	ETF	101.36	101.47	101.36	101.45	400.0
2010-06-25 07:00:00	DIA	ETF	101.54	101.74	101.54	101.7	600.0
2010-06-25 08:00:00	DIA	ETF	101.87	101.87	101.39	101.54	72690.0

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

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