PREVIEW / etf_1hour / 2008-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-14.parquet
  size:    109 KB
  rows:    3,525

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
2008-08-14 05:00:00	SPY	ETF	128.97	129.07	128.97	129.05	4000.0
2008-08-14 06:00:00	SPY	ETF	128.92	129.07	128.89	129.0	52000.0
2008-08-14 07:00:00	SPY	ETF	129.03	129.15	128.97	129.03	399910.0
2008-08-14 08:00:00	SPY	ETF	129.05	129.15	127.86	127.96	9902269.0
2008-08-14 09:00:00	SPY	ETF	127.97	128.5	127.75	128.45	26344569.0
2008-08-14 10:00:00	SPY	ETF	128.45	129.55	128.17	129.35	46792077.0
2008-08-14 11:00:00	SPY	ETF	129.355	129.87	129.26	129.61	25944456.0
2008-08-14 12:00:00	SPY	ETF	129.61	130.28	129.48	130.0	32730233.0
2008-08-14 13:00:00	SPY	ETF	130.0	130.1	129.47	129.73	18272839.0
2008-08-14 14:00:00	SPY	ETF	129.73	129.97	129.2	129.35	27925513.0
2008-08-14 15:00:00	SPY	ETF	129.35	129.59	129.1	129.54	41298703.0
2008-08-14 16:00:00	SPY	ETF	129.52	129.79	129.0	129.74	8130607.0
2008-08-14 17:00:00	SPY	ETF	129.72	129.84	129.72	129.75	68275.0
2008-08-14 18:00:00	SPY	ETF	129.79	129.85	129.78	129.85	81017.0
2008-08-14 19:00:00	SPY	ETF	129.84	129.86	129.81	129.84	24440.0
2008-08-14 06:00:00	QQQ	ETF	47.79	47.82	47.78	47.81	18500.0
2008-08-14 07:00:00	QQQ	ETF	47.8	47.87	47.79	47.79	106490.0
2008-08-14 08:00:00	QQQ	ETF	47.8	47.85	47.51	47.54	2589138.0
2008-08-14 09:00:00	QQQ	ETF	47.54	47.98	47.49	47.98	27130163.0
2008-08-14 10:00:00	QQQ	ETF	47.98	48.29	47.8	48.16	30874388.0
2008-08-14 11:00:00	QQQ	ETF	48.16	48.27	48.12	48.23	14655585.0
2008-08-14 12:00:00	QQQ	ETF	48.23	48.45	48.19	48.36	20819733.0
2008-08-14 13:00:00	QQQ	ETF	48.36	48.46	48.2	48.29	14402420.0
2008-08-14 14:00:00	QQQ	ETF	48.29	48.41	48.14	48.22	17277554.0
2008-08-14 15:00:00	QQQ	ETF	48.21	48.36	48.1	48.29	21755600.0
2008-08-14 16:00:00	QQQ	ETF	48.289	48.36	48.1835	48.32	2044857.0
2008-08-14 17:00:00	QQQ	ETF	48.33	48.36	48.31	48.35	585494.0
2008-08-14 18:00:00	QQQ	ETF	48.35	48.35	48.27	48.35	69682.0
2008-08-14 19:00:00	QQQ	ETF	48.35	48.37	48.33	48.37	27300.0
2008-08-14 05:00:00	IWM	ETF	74.78	74.78	74.78	74.78	3000.0
2008-08-14 06:00:00	IWM	ETF	74.71	74.71	74.7	74.7	3100.0
2008-08-14 07:00:00	IWM	ETF	74.77	74.78	74.68	74.68	24384.0
2008-08-14 08:00:00	IWM	ETF	74.69	74.71	74.15	74.23	1889521.0
2008-08-14 09:00:00	IWM	ETF	74.24	74.66	74.06	74.64	14560132.0
2008-08-14 10:00:00	IWM	ETF	74.64	75.35	74.52	75.23	21783225.0
2008-08-14 11:00:00	IWM	ETF	75.24	75.42	75.14	75.34	11935174.0
2008-08-14 12:00:00	IWM	ETF	75.34	75.64	75.23	75.42	15347623.0
2008-08-14 13:00:00	IWM	ETF	75.42	75.46	75.08	75.18	11188183.0
2008-08-14 14:00:00	IWM	ETF	75.18	75.34	75.12	75.21	13125514.0
2008-08-14 15:00:00	IWM	ETF	75.2	75.33	75.03	75.22	19640640.0
2008-08-14 16:00:00	IWM	ETF	75.23	75.41	74.85	75.41	6343882.0
2008-08-14 17:00:00	IWM	ETF	75.42	75.42	75.38	75.38	5543.0
2008-08-14 18:00:00	IWM	ETF	75.4	75.4	75.4	75.4	21810.0
2008-08-14 19:00:00	IWM	ETF	75.4	75.4	75.36	75.39	15700.0
2008-08-14 04:00:00	DIA	ETF	115.96	115.96	115.96	115.96	200.0
2008-08-14 06:00:00	DIA	ETF	115.7	115.95	115.7	115.95	600.0
2008-08-14 07:00:00	DIA	ETF	115.95	115.95	115.83	115.87	3830.0
2008-08-14 08:00:00	DIA	ETF	115.85	115.92	114.92	114.95	176813.0
2008-08-14 09:00:00	DIA	ETF	114.98	115.33	114.69	115.28	2642756.0
2008-08-14 10:00:00	DIA	ETF	115.28	116.37	115.22	116.24	4249886.0

> showing 50 of 3,525 rows — these rows as CSV

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