PREVIEW / etf_30min / 2007-10-26

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-26.parquet
  size:    133 KB
  rows:    4,991

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
2007-10-26 04:30:00	SPY	ETF	151.63	151.63	151.63	151.63	400.0
2007-10-26 05:00:00	SPY	ETF	151.6	151.68	151.6	151.68	200.0
2007-10-26 06:00:00	SPY	ETF	151.7	151.9	151.65	151.9	9300.0
2007-10-26 06:30:00	SPY	ETF	152.13	152.13	152.08	152.08	33200.0
2007-10-26 07:00:00	SPY	ETF	152.0	152.0	151.81	151.85	110900.0
2007-10-26 07:30:00	SPY	ETF	151.9	151.93	151.54	151.63	488200.0
2007-10-26 08:00:00	SPY	ETF	151.64	152.63	151.53	152.54	7043800.0
2007-10-26 08:30:00	SPY	ETF	152.54	152.82	152.5	152.79	2985600.0
2007-10-26 09:00:00	SPY	ETF	152.79	153.1	152.7	153.06	4394078.0
2007-10-26 09:30:00	SPY	ETF	153.06	153.23	152.5	152.63	24686213.0
2007-10-26 10:00:00	SPY	ETF	152.63	153.25	152.35	152.79	16911700.0
2007-10-26 10:30:00	SPY	ETF	152.78	152.8	152.26	152.56	14074500.0
2007-10-26 11:00:00	SPY	ETF	152.56	153.15	152.18	152.38	7666600.0
2007-10-26 11:30:00	SPY	ETF	152.37	152.49	152.08	152.13	7786650.0
2007-10-26 12:00:00	SPY	ETF	152.13	152.44	151.9	152.4	9078700.0
2007-10-26 12:30:00	SPY	ETF	152.41	152.63	152.3	152.56	9167200.0
2007-10-26 13:00:00	SPY	ETF	152.56	152.85	152.35	152.72	6877528.0
2007-10-26 13:30:00	SPY	ETF	152.7299	152.8	152.46	152.71	6030400.0
2007-10-26 14:00:00	SPY	ETF	152.71	153.46	152.7	153.11	14981800.0
2007-10-26 14:30:00	SPY	ETF	153.12	153.4	153.05	153.16	5847900.0
2007-10-26 15:00:00	SPY	ETF	153.16	153.33	152.81	152.97	8282544.0
2007-10-26 15:30:00	SPY	ETF	152.97	153.5	152.97	153.45	14154100.0
2007-10-26 16:00:00	SPY	ETF	153.49	153.75	152.6987	153.75	6460200.0
2007-10-26 16:30:00	SPY	ETF	153.75	153.89	152.93	153.82	4416000.0
2007-10-26 17:00:00	SPY	ETF	153.8	153.97	153.78	153.78	51500.0
2007-10-26 17:30:00	SPY	ETF	153.78	153.78	153.62	153.73	204200.0
2007-10-26 18:00:00	SPY	ETF	153.77	153.77	153.62	153.75	4300.0
2007-10-26 18:30:00	SPY	ETF	153.75	153.75	153.75	153.75	400.0
2007-10-26 19:00:00	SPY	ETF	153.78	153.8	153.78	153.8	1800.0
2007-10-26 19:30:00	SPY	ETF	153.8	153.8	153.8	153.8	700.0
2007-10-26 04:00:00	QQQ	ETF	53.75	53.75	53.75	53.75	800.0
2007-10-26 06:00:00	QQQ	ETF	53.72	53.82	53.72	53.82	241500.0
2007-10-26 06:30:00	QQQ	ETF	53.8	53.8	53.78	53.78	14600.0
2007-10-26 07:00:00	QQQ	ETF	53.73	53.75	53.71	53.72	189392.0
2007-10-26 07:30:00	QQQ	ETF	53.72	53.73	53.58	53.64	316609.0
2007-10-26 08:00:00	QQQ	ETF	53.62	53.97	53.62	53.87	1810592.0
2007-10-26 08:30:00	QQQ	ETF	53.85	53.99	53.84	53.9	1958537.0
2007-10-26 09:00:00	QQQ	ETF	53.9	54.14	53.9	54.07	1747305.0
2007-10-26 09:30:00	QQQ	ETF	54.07	54.2	53.55	53.63	26004174.0
2007-10-26 10:00:00	QQQ	ETF	53.63	53.82	53.51	53.8	15624358.0
2007-10-26 10:30:00	QQQ	ETF	53.79	53.85	53.6	53.74	12949581.0
2007-10-26 11:00:00	QQQ	ETF	53.74	53.83	53.62	53.71	8380804.0
2007-10-26 11:30:00	QQQ	ETF	53.71	53.74	53.52	53.53	6727960.0
2007-10-26 12:00:00	QQQ	ETF	53.53	53.68	53.44	53.6601	8761038.0
2007-10-26 12:30:00	QQQ	ETF	53.6615	53.74	53.65	53.71	5227379.0
2007-10-26 13:00:00	QQQ	ETF	53.713	53.87	53.64	53.7701	6986899.0
2007-10-26 13:30:00	QQQ	ETF	53.78	53.84	53.71	53.77	5237902.0
2007-10-26 14:00:00	QQQ	ETF	53.7795	54.02	53.76	53.91	9124679.0
2007-10-26 14:30:00	QQQ	ETF	53.91	53.96	53.77	53.83	6739847.0
2007-10-26 15:00:00	QQQ	ETF	53.83	53.88	53.66	53.82	11653395.0

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

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