PREVIEW / etf_1hour / 2010-02-16

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-16.parquet
  size:    156 KB
  rows:    4,850

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-02-16 04:00:00	SPY	ETF	108.94	109.0	108.86	108.86	8907.0
2010-02-16 05:00:00	SPY	ETF	108.92	109.0	108.82	108.87	18750.0
2010-02-16 06:00:00	SPY	ETF	108.82	108.89	108.78	108.83	82460.0
2010-02-16 07:00:00	SPY	ETF	108.81	108.89	108.45	108.59	1315551.0
2010-02-16 08:00:00	SPY	ETF	108.572	109.0	107.87	108.86	4285638.0
2010-02-16 09:00:00	SPY	ETF	108.87	109.1	108.42	108.6195	23773949.0
2010-02-16 10:00:00	SPY	ETF	108.62	109.16	108.43	108.91	25259959.0
2010-02-16 11:00:00	SPY	ETF	108.91	109.35	108.47	109.21	16998777.0
2010-02-16 12:00:00	SPY	ETF	109.2001	109.3	109.14	109.24	12793750.0
2010-02-16 13:00:00	SPY	ETF	109.2499	109.39	109.1	109.32	11908281.0
2010-02-16 14:00:00	SPY	ETF	109.31	109.43	109.17	109.35	15120636.0
2010-02-16 15:00:00	SPY	ETF	109.36	109.85	109.34	109.73	36622703.0
2010-02-16 16:00:00	SPY	ETF	109.73	109.83	108.55	109.8	6741204.0
2010-02-16 17:00:00	SPY	ETF	109.8	109.83	109.77	109.79	139529.0
2010-02-16 18:00:00	SPY	ETF	109.8	109.92	107.8208	109.87	2151362.0
2010-02-16 19:00:00	SPY	ETF	109.88	109.95	109.82	109.95	146417.0
2010-02-16 20:00:00	SPY	ETF	109.95	109.95	109.95	109.95	200.0
2010-02-16 04:00:00	QQQ	ETF	44.14	44.16	44.14	44.16	1590.0
2010-02-16 05:00:00	QQQ	ETF	44.17	44.17	44.12	44.12	200.0
2010-02-16 06:00:00	QQQ	ETF	44.13	44.13	44.11	44.11	350.0
2010-02-16 07:00:00	QQQ	ETF	44.13	44.14	43.94	44.0	568667.0
2010-02-16 08:00:00	QQQ	ETF	43.98	44.15	43.95	44.1	2329879.0
2010-02-16 09:00:00	QQQ	ETF	44.11	44.17	43.85	43.97	14626254.0
2010-02-16 10:00:00	QQQ	ETF	43.965	44.26	43.89	44.14	16925017.0
2010-02-16 11:00:00	QQQ	ETF	44.14	44.29	44.0629	44.23	7987619.0
2010-02-16 12:00:00	QQQ	ETF	44.221	44.2593	44.18	44.21	5957314.0
2010-02-16 13:00:00	QQQ	ETF	44.201	44.24	44.15	44.21	6553969.0
2010-02-16 14:00:00	QQQ	ETF	44.21	44.28	44.16	44.221	7320721.0
2010-02-16 15:00:00	QQQ	ETF	44.23	44.35	44.22	44.31	11938577.0
2010-02-16 16:00:00	QQQ	ETF	44.32	44.35	44.0629	44.33	3234074.0
2010-02-16 17:00:00	QQQ	ETF	44.31	44.34	44.3	44.34	632875.0
2010-02-16 18:00:00	QQQ	ETF	44.34	44.4	44.32	44.4	39403.0
2010-02-16 19:00:00	QQQ	ETF	44.37	44.38	44.34	44.36	15808.0
2010-02-16 07:00:00	IWM	ETF	61.48	61.51	61.42	61.51	13580.0
2010-02-16 08:00:00	IWM	ETF	61.52	61.95	61.01	61.69	347002.0
2010-02-16 09:00:00	IWM	ETF	61.7	61.78	61.08	61.31	8961954.0
2010-02-16 10:00:00	IWM	ETF	61.32	61.67	61.12	61.4495	8730968.0
2010-02-16 11:00:00	IWM	ETF	61.45	61.7	61.41	61.63	3867518.0
2010-02-16 12:00:00	IWM	ETF	61.63	61.73	61.56	61.65	2273154.0
2010-02-16 13:00:00	IWM	ETF	61.65	61.7499	61.58	61.721	2885586.0
2010-02-16 14:00:00	IWM	ETF	61.72	61.85	61.655	61.81	2770319.0
2010-02-16 15:00:00	IWM	ETF	61.8	62.11	61.76	62.05	12798747.0
2010-02-16 16:00:00	IWM	ETF	62.05	62.1	61.553	62.05	2045943.0
2010-02-16 17:00:00	IWM	ETF	62.04	62.11	62.04	62.11	41411.0
2010-02-16 18:00:00	IWM	ETF	62.06	62.25	61.1005	62.17	561992.0
2010-02-16 19:00:00	IWM	ETF	62.11	62.15	62.1	62.15	4300.0
2010-02-16 07:00:00	DIA	ETF	102.7	102.7	101.7	101.7	1100.0
2010-02-16 08:00:00	DIA	ETF	101.99	102.03	101.59	101.98	35215.0
2010-02-16 09:00:00	DIA	ETF	102.02	102.13	101.59	101.83	1201741.0
2010-02-16 10:00:00	DIA	ETF	101.81	102.28	101.69	102.12	1675180.0

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

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