PREVIEW / etf_1hour / 2010-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-26.parquet
  size:    156 KB
  rows:    4,807

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-01-26 04:00:00	SPY	ETF	109.09	109.27	109.0	109.07	8536.0
2010-01-26 05:00:00	SPY	ETF	108.94	109.08	108.83	109.08	11573.0
2010-01-26 06:00:00	SPY	ETF	109.07	109.17	109.0	109.11	61339.0
2010-01-26 07:00:00	SPY	ETF	109.11	109.51	109.05	109.47	764816.0
2010-01-26 08:00:00	SPY	ETF	109.45	109.64	108.7	109.36	2055616.0
2010-01-26 09:00:00	SPY	ETF	109.36	109.64	109.04	109.33	33531624.0
2010-01-26 10:00:00	SPY	ETF	109.33	110.1	109.23	109.69	37500874.0
2010-01-26 11:00:00	SPY	ETF	109.72	110.27	109.67	110.14	23342172.0
2010-01-26 12:00:00	SPY	ETF	110.15	110.47	110.11	110.43	18161544.0
2010-01-26 13:00:00	SPY	ETF	110.43	110.44	110.15	110.43	12607391.0
2010-01-26 14:00:00	SPY	ETF	110.43	110.46	109.93	110.17	26825855.0
2010-01-26 15:00:00	SPY	ETF	110.16	110.18	109.2	109.3	46318741.0
2010-01-26 16:00:00	SPY	ETF	109.28	110.3511	109.02	109.35	8327858.0
2010-01-26 17:00:00	SPY	ETF	109.35	109.7786	109.3	109.32	1023234.0
2010-01-26 18:00:00	SPY	ETF	109.36	109.7	109.36	109.48	234725.0
2010-01-26 19:00:00	SPY	ETF	109.47	109.58	109.22	109.51	145325.0
2010-01-26 04:00:00	QQQ	ETF	44.18	44.18	44.12	44.12	907.0
2010-01-26 05:00:00	QQQ	ETF	44.07	44.21	44.07	44.21	3100.0
2010-01-26 06:00:00	QQQ	ETF	44.2	44.2	44.14	44.18	5626.0
2010-01-26 07:00:00	QQQ	ETF	44.16	44.35	44.15	44.33	248788.0
2010-01-26 08:00:00	QQQ	ETF	44.32	44.38	43.95	44.29	1061330.0
2010-01-26 09:00:00	QQQ	ETF	44.28	44.29	44.05	44.15	19167541.0
2010-01-26 10:00:00	QQQ	ETF	44.16	44.58	44.11	44.46	29666934.0
2010-01-26 11:00:00	QQQ	ETF	44.45	44.72	44.43	44.68	12819909.0
2010-01-26 12:00:00	QQQ	ETF	44.68	44.89	44.65	44.87	13083305.0
2010-01-26 13:00:00	QQQ	ETF	44.86	44.88	44.7401	44.88	5951944.0
2010-01-26 14:00:00	QQQ	ETF	44.87	44.89	44.57	44.68	17054526.0
2010-01-26 15:00:00	QQQ	ETF	44.69	44.7	44.265	44.34	23712442.0
2010-01-26 16:00:00	QQQ	ETF	44.34	44.7699	44.2	44.35	7379064.0
2010-01-26 17:00:00	QQQ	ETF	44.37	44.38	44.31	44.32	3237455.0
2010-01-26 18:00:00	QQQ	ETF	44.31	44.39	44.3	44.33	79688.0
2010-01-26 19:00:00	QQQ	ETF	44.32	44.35	44.22	44.33	72610.0
2010-01-26 07:00:00	IWM	ETF	61.53	61.63	61.53	61.59	16200.0
2010-01-26 08:00:00	IWM	ETF	61.28	61.72	61.1	61.53	568541.0
2010-01-26 09:00:00	IWM	ETF	61.52	61.59	61.14	61.33	7013723.0
2010-01-26 10:00:00	IWM	ETF	61.33	61.82	61.21	61.58	11507217.0
2010-01-26 11:00:00	IWM	ETF	61.58	61.89	61.54	61.81	4321493.0
2010-01-26 12:00:00	IWM	ETF	61.81	62.0299	61.75	61.95	3198193.0
2010-01-26 13:00:00	IWM	ETF	61.95	61.99	61.7182	61.9826	3656257.0
2010-01-26 14:00:00	IWM	ETF	61.99	62.01	61.5838	61.73	5687635.0
2010-01-26 15:00:00	IWM	ETF	61.73	61.76	61.14	61.21	13815439.0
2010-01-26 16:00:00	IWM	ETF	61.21	61.83	61.14	61.29	4101258.0
2010-01-26 17:00:00	IWM	ETF	61.3	61.32	61.23	61.23	19410.0
2010-01-26 18:00:00	IWM	ETF	61.27	61.36	61.26	61.35	26786.0
2010-01-26 19:00:00	IWM	ETF	61.31	61.32	61.23	61.23	6014.0
2010-01-26 06:00:00	DIA	ETF	101.21	101.21	101.21	101.21	300.0
2010-01-26 07:00:00	DIA	ETF	101.6	101.76	101.6	101.76	500.0
2010-01-26 08:00:00	DIA	ETF	101.82	101.95	101.66	101.7	41744.0
2010-01-26 09:00:00	DIA	ETF	101.7	103.06	101.48	101.78	2403975.0
2010-01-26 10:00:00	DIA	ETF	101.79	102.4	101.66	102.14	3237122.0

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

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